There's your answer.......that's the last time I'll use EXEC!!!
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 17 August 2000 14:50
To: [EMAIL PROTECTED]
Subject: Re: Noodling over Switch Statements and Stored Procedures and
Eff icie ncy
If you're using MS-SQL 7.0 you may want to consider sp_executesql. From
documention:
sp_executesql is introduced in Microsoft® SQL Server�"� version 7.0. Using
sp_executesql is recommended over using the EXECUTE statement to execute a
string. Not only does the support for parameter substitution make
sp_executesql more versatile than EXECUTE, it also makes sp_executesql more
efficient because it generates execution plans that are more likely to be
reused by SQL Server.
Bill Reichard
Willow Gold
http://www.willowgold.com
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
