----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Prasanna_kakanoor Message 5 in Discussion Hi, You can use In and OUT in T-SQL Here is the saplme code for T-SQL with OUT keyword DECLARE @object int DECLARE @hr int -- Create an object that points to the SQL Server EXEC @hr = sp_OACreate 'SQLDMO.SQLServer', @object OUT IF @hr <> 0 BEGIN EXEC sp_displayoaerrorinfo @object, @hr RETURN END Prasanna K L<o:p></o:p> Sr. Software Engineer<o:p></o:p> [MCAD(CM) | MCSD.NET(Early Achiever)]<o:p></o:p> <o:p> </o:p> ZapApp India Private Limited Level G & 1, Explorer Building, International TechPark, Whitefield Road, Bangalore - 560 066. INDIA 91-80- 5115 6050 extn. 4061 (phone) 91-80- 841 1858 (fax) [EMAIL PROTECTED]<o:p></o:p> <o:p> </o:p> -----Original Message----- From: BDOTNET [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 5:26 PM To: [EMAIL PROTECTED] Subject: Specifying IN OUT Parameter in T-SQL Procedure? New Message on BDOTNET Specifying IN OUT Parameter in T-SQL Procedure? Reply Recommend Message 1 in Discussion From: Gogi7735 hi, Can I Specify a Parameter as IN OUT in a T-SQL Procedure ?if so how? Thanks -Srinivas View other groups in this category. ----------------------------------------------------------- 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]
