Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql statement with multiple single quotations
Message
From
19/04/2007 04:25:40
Issam Mansour
Jordan Business Machines
Amman, Jordan
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Sql statement with multiple single quotations
Miscellaneous
Thread ID:
01217632
Message ID:
01217632
Views:
59
Hi,

i have the following case with Sql statment with single qoutations:


DECLARE @L_SQLCOMM VARCHAR(8000)

SET @L_SQLCOMM = 'SELECT * FROM AMASTER where ACCTNAME = 'CASH''

EXEC(@L_SQLCOMM

Regards
Next
Reply
Map
View

Click here to load this message in the networking platform