I was under the impression that selects DID run faster as stored procs, but I'm not sure. Not sure about the wizard either, but I can give you some code:
CREATE PROC MyProcsName @parameter1 int, @parameter2 nvarchar(100) as select * from foo where fooid = @parameter1 or fooname = @parameter2 ----- Original Message ----- From: "Michael Dinowitz" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Sunday, November 10, 2002 6:36 PM Subject: SP creation > I was looking at the SQL 2k stored procedure wizard and noticed that it does not > have anything for select. I was under the impression that a select based stored > procedure would be quicker than a non-stored procedure version. Was I wrong? Is > there a different way to set them up with the wizard? Should views be used? > What's the threshold of savings when using stored procedures? > (I've used them in the past with earlier versions of SQL but I'm unsure of any > changes in 2k and efficiency) > Thanks > > Michael Dinowitz > Master of the House of Fusion > http://www.houseoffusion.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
