How would it work where you have the same signature? Suppose I have an OrderDetails table. Sometimes I want to search by OrderDetailID (to find the details of a particular item). Sometimes I want to search by OrderID (to find all the details of all the items for a particular order). Both are int.
? Cheers Ken ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Anders Lundholm" <[EMAIL PROTECTED]> Subject: Re: Overloading stored procedures in SQL Server "Yukon" : Hello! : : > Whats stopping you just sending different parameters to a stored : > procedure anyway and setting up constants in your vb prog for each : > parameter? : : I know about the different workarounds, but they aren't really that pretty : compared to the overloading approach. The method you describe is not at all : that fancy when you need to pass in arguments to the stored procedure. : : We'll see what TinySoft has got for us :-) : : with regards : anders l. borum � [EMAIL PROTECTED] : the sphereworx / monoliner experience ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
