Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Maximum length is 30?
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00237395
Message ID:
00237674
Views:
11
> dum = ;
> [exec Sp_AddCus ]+;
> ["]+allt(custfl.password)+[",]+;
> ["]+[AUTO]+[",]+;
> +allt(str(4.0,5,2))+[,]+;
> ["]+allt(custfl.firm)+[",]+;
> ["]+allt(custfl.poc)+[",]+;
> ["]+allt(custfl.address1)+[",]+;
> ["]+allt(custfl.address2)+[",]+;
> ["]+allt(custfl.city)+[",]+;
> ["]+allt(custfl.st)+[",]+;
> ["]+allt(custfl.zip)+[",]+;
> ["]+allt(custfl.zip4)+[",]+;
> ["]+strtran(allt(custfl.phone),"-","")+[",]+;
> ["]+strtran(allt(custfl.fax),"-","")+[",]+;
> ["]+allt(custfl.email)+[",]+;
> [2]

OK, SQL Server uses single quotes to delimit strings. Double quotes have a special meaning depending on whether SET QUOTED_IDENTIFIER is ON or OFF.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform