[thelist] Stored procedure
JSchell at doeanderson.com
JSchell at doeanderson.com
Mon Feb 3 04:53:01 CST 2003
Your line should read
SELECT @sDescription = 'steve and ''john'' went on a trip'
When using single quotes in a variable assignment they need to be escaped
with the single quote.
Jeremy Schell
Senior Internet Developer/Technical Lead, Interactive
Doe Anderson, Inc.
(502) 815-3339
"Stevenson Ngila"
<Stevenson at epr.footman- To: "Thelist at Lists. Evolt. Org" <thelist at lists.evolt.org>
walker.com> cc:
Sent by: Subject: [thelist] Stored procedure
thelist-admin at lists.evo
lt.org
02/03/2003 02:11 AM
Please respond to
thelist
hi all,
I want to run a stored procedure sp_testing @sDescription as ntext where
@sDescription is:- 'steve and 'john' went on a trip'.
But John is in quotes and this data is feed automatically, how can i make
this run.
i have tried using sp_testing replace (@sDescription, '''', '''''') as
ntext, but it's failing.
Please assist
--
* * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/
For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
More information about the thelist
mailing list