----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: csudhir Message 3 in Discussion Hi Vinay, You can use this to find the no of arguments used by any stored procedure. All the parameters of stored procedures are stored in syscolumns table. select * from syscolumns where id in ( select id from sysobjects where name = 'Employee Sales by Country' and type = 'P') Hope this will solve your purpose. Regards Sudhir ________________________________ From: WinDotNet [mailto:[EMAIL PROTECTED] Sent: Fri 2/11/2005 10:20 AM To: BDOTNET Subject: Wrong no. of arguments in Stored Procedure New Message on BDOTNET <http://groups.msn.com/BDOTNET> Wrong no. of arguments in Stored Procedure <http://groups.msn.com/BDOTNET/_notifications.msnw?type=msg&action=showdiscussion&parent=1&item=23984> Reply <mailto:[EMAIL PROTECTED]> Reply to Sender <mailto:[EMAIL PROTECTED]> Recommend <http://groups.msn.com/BDOTNET/_notifications.msnw?type=msg&action=recommend&parent=1&item=23984> Message 1 in Discussion From: WinDotNet <http://groups.msn.com/BDOTNET/profile?user=WinDotNet%E2%9C%93> Hi All, Can any body tell me how to find the no. of araguments to be passed to a stored procedure. I have a SP say : sp_invoke(@var1 integer, @var2 integer)..... and if i pass only one argument , an error is generated... plz tell me how to handel that. thanks in advance. Vinay View other groups in this category. <http://groups.msn.com/Browse?CatId=26> Also on MSN: Start Chatting <http://g.msn.com/2GRENUS/2_8085_01> | Listen to Music <http://g.msn.com/2GRENUS/2_8085_02> | House & Home <http://g.msn.com/2GRENUS/2_8085_03> | Try Online Dating <http://g.msn.com/2GRENUS/2_8085_04> | Daily Horoscopes <http://g.msn.com/2GRENUS/2_8085_05> 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 <http://groups.msn.com/contact> page. 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. Remove my e-mail address from BDOTNET. <mailto:[EMAIL PROTECTED]> ----------------------------------------------------------- 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]
