----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: SaifIkram Message 10 in Discussion Hi Giridhar, ThankQ very much i had found the solution to display ths list of table and the column names from the db whose type is int select distinct b.name as TableName, a.name as ColumnName from syscolumns a,sysobjects b where a.id = b.id and a.type = 38 and a.name not like '@%' and b.type = 'U'; Regards, Venkata Krishna Asst. Consultant Genisys Software Plot No. 33-36 & 43-46 Export Promotion Industrial Park (EPIP) Whitefield, Bangalore - 560 066, India. Phone : +91-80-841 0297 Extn :325 FAX : +91-80-841 2007 Web : <http://www.genuk.com/> -----Original Message----- From: BDOTNET [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 5:18 AM To: BDOTNET Subject: Re: Hi Sensitivity: Confidential New Message on BDOTNET Hi Reply Recommend Message 8 in Discussion From: Girdhar77 Hi Saif, Try this select distinct b.name as TableName from syscolumns a,sysobjects b where a.type = 38 regs Rishi ----------------------------------------------------------- New Message on BDOTNET ----------------------------------------------------------- From: SaifIkram Message 6 in Discussion Hi All, I want to displays all the tables from the database which is having a field of type "int" using system stored procedures in SQL Server Please can any one of u can help to write this query regards, Saif Ikram ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED] ********************************************************************* Disclaimer: The information in this e-mail and any attachments is confidential / privileged. It is intended solely for the addressee or addressees. If you are not the addressee indicated in this message, you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. ********************************************************************* View other groups in this category. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
