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.
