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/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dlists/cf_t=
alk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' =
in
the body.
=
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=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"
TITLERE: Noodling over Switch Statements and Stored Procedures and =
Eff icie ncy/TITLE
/HEAD
BODY
PFONT SIZE=3D2Groovy.nbsp; I want to thank you and Andy for both =
of your help./FONT
/P
PFONT SIZE=3D2Sincerely,/FONT
BRFONT SIZE=3D2Robert/FONT
/P
PFONT SIZE=3D2-Original Message-/FONT
BRFONT SIZE=3D2From: Andy Ewings [A =
HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]=
uk/A]/FONT
BRFONT SIZE=3D2Sent: Thursday, August 17, 2000 9:52 AM/FONT
BRFONT SIZE=3D2To: '[EMAIL PROTECTED]'/FONT
BRFONT SIZE=3D2Subject: RE: Noodling over Switch Statements and =
Stored Procedures and/FONT
BRFONT SIZE=3D2Eff icie ncy/FONT
/P
BR
PFONT SIZE=3D2There's your answer...that's the last time I'll =
use EXEC!!!/FONT
/P
PFONT SIZE=3D2-Original Message-/FONT
BRFONT SIZE=3D2From: [EMAIL PROTECTED] [A =
HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT=
BRFONT SIZE=3D2Sent: 17 August 2000 14:50/FONT
BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT
BRFONT SIZE=3D2Subject: Re: Noodling over Switch Statements and =
Stored Procedures and/FONT
BRFONT SIZE=3D2Eff icie ncy/FONT
/P
BR
PFONT SIZE=3D2If you're using MS-SQL 7.0 you may want to consider =
sp_executesql. From /FONT
BRFONT SIZE=3D2documention:/FONT
/P
PFONT SIZE=3D2sp_executesql is introduced in Microsoft=C2=AE SQL =
Server=E2quot;=A2 version 7.0. Using /FONT
BRFONT SIZE=3D2sp_executesql is recommended over using the EXECUTE =
statement to execute a /FONT
BRFONT SIZE=3D2string. Not only does the support for parameter =
substitution make /FONT
BRFONT SIZE=3D2sp_executesql more versatile than EXECUTE, it also =
makes sp_executesql more /FONT
BRFONT SIZE=3D2efficient because it generates execution plans that =
are more likely to be /FONT
BRFONT SIZE=3D2reused by SQL Server./FONT
/P
PFONT SIZE=3D2Bill Reichard/FONT
BRFONT SIZE=3D2Willow Gold/FONT
BRFONT SIZE=3D2A HREF=3D"http://www.willowgold.com" =
TARGET=3D"_blank"http://www.willowgold.com/A/FONT
BRFONT =
SIZE=3D2---=
-/FONT
BRFONT SIZE=3D2--/FONT
BRFONT SIZE=3D2Archives: A =
HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" =
TARGET=3D"_blank"http://www.mail-archive.com/cf-talk
