----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: VinodK [TLabs, SCT] Message 2 in Discussion Hi Srinivas, I think you are trying to compare this with Oracles IN OUT Parameter... If yes, then unlike in Oracle World where an Ouput parameter cannot accept an input value and vice versa ... Here in SQL Server you can mark a parameter as output and then pass an input value to the same. See the below code for example. It illustrates how SQL Server can have IN OUT Params ... Create Proc Vin_Test (@Param Int OUTPUT) As BEGIN Select @Param Set @Param=10 END GO Declare @ParamOut Int Set @ParamOut=1 Exec Vin_Test @ParamOut OUTPUT Select @ParamOut HTH, Vinod Kumar Microsoft India Community Star www.extremeexperts.com ----------------------------------------------------------- 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]
