no probs -----Original Message----- From: Eberhart, Robert D [mailto:[EMAIL PROTECTED]] Sent: 17 August 2000 15:02 To: '[EMAIL PROTECTED]' Subject: RE: Noodling over Switch Statements and Stored Procedures and Eff icie ncy This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C00853.C6A9D2E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Groovy. I want to thank you and Andy for both of your help. Sincerely, Robert -----Original Message----- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 9:52 AM To: '[EMAIL PROTECTED]' Subject: RE: Noodling over Switch Statements and Stored Procedures and Eff icie ncy 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=C2=AE SQL Server=E2"=A2 = version 7.0. Using=20 sp_executesql is recommended over using the EXECUTE statement to = execute a=20 string. Not only does the support for parameter substitution make=20 sp_executesql more versatile than EXECUTE, it also makes sp_executesql = more=20 efficient because it generates execution plans that are more likely to = be=20 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=3Dlists&body=3Dlists/cf_t= alk 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?sidebar=3Dlists&body=3Dlists/cf_t= alk or send a message to [EMAIL PROTECTED] with 'unsubscribe' = in the body. ------_=_NextPart_001_01C00853.C6A9D2E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2652.35"> <TITLE>RE: Noodling over Switch Statements and Stored Procedures and = Eff icie ncy</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Groovy. I want to thank you and Andy for both = of your help.</FONT> </P> <P><FONT SIZE=3D2>Sincerely,</FONT> <BR><FONT SIZE=3D2>Robert</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Andy Ewings [<A = HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]= uk</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Thursday, August 17, 2000 9:52 AM</FONT> <BR><FONT SIZE=3D2>To: '[EMAIL PROTECTED]'</FONT> <BR><FONT SIZE=3D2>Subject: RE: Noodling over Switch Statements and = Stored Procedures and</FONT> <BR><FONT SIZE=3D2>Eff icie ncy</FONT> </P> <BR> <P><FONT SIZE=3D2>There's your answer.......that's the last time I'll = use EXEC!!!</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: [EMAIL PROTECTED] [<A = HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT>= <BR><FONT SIZE=3D2>Sent: 17 August 2000 14:50</FONT> <BR><FONT SIZE=3D2>To: [EMAIL PROTECTED]</FONT> <BR><FONT SIZE=3D2>Subject: Re: Noodling over Switch Statements and = Stored Procedures and</FONT> <BR><FONT SIZE=3D2>Eff icie ncy</FONT> </P> <BR> <P><FONT SIZE=3D2>If you're using MS-SQL 7.0 you may want to consider = sp_executesql. From </FONT> <BR><FONT SIZE=3D2>documention:</FONT> </P> <P><FONT SIZE=3D2>sp_executesql is introduced in Microsoft=C2=AE SQL = Server=E2"=A2 version 7.0. Using </FONT> <BR><FONT SIZE=3D2>sp_executesql is recommended over using the EXECUTE = statement to execute a </FONT> <BR><FONT SIZE=3D2>string. Not only does the support for parameter = substitution make </FONT> <BR><FONT SIZE=3D2>sp_executesql more versatile than EXECUTE, it also = makes sp_executesql more </FONT> <BR><FONT SIZE=3D2>efficient because it generates execution plans that = are more likely to be </FONT> <BR><FONT SIZE=3D2>reused by SQL Server.</FONT> </P> <P><FONT SIZE=3D2>Bill Reichard</FONT> <BR><FONT SIZE=3D2>Willow Gold</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.willowgold.com" = TARGET=3D"_blank">http://www.willowgold.com</A></FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -------------</FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Archives: <A = HREF=3D"http://www.mail-archive.com/[email protected]/" = TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/= </A></FONT> <BR><FONT SIZE=3D2>To Unsubscribe visit</FONT> <BR><FONT SIZE=3D2><A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli= sts/cf_talk" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= &body=3Dlists/cf_talk</A> or</FONT> <BR><FONT SIZE=3D2>send a message to [EMAIL PROTECTED] = with 'unsubscribe' in</FONT> <BR><FONT SIZE=3D2>the body.</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= ---------------</FONT> <BR><FONT SIZE=3D2>Archives: <A = HREF=3D"http://www.mail-archive.com/[email protected]/" = TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/= </A></FONT> <BR><FONT SIZE=3D2>To Unsubscribe visit <A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli= sts/cf_talk" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= &body=3Dlists/cf_talk</A> or send a message to = [EMAIL PROTECTED] with 'unsubscribe' in the = body.</FONT></P> </BODY> </HTML> ------_=_NextPart_001_01C00853.C6A9D2E0-- ---------------------------------------------------------------------------- -- 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?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
