[thelist] Friday Freebie --CLARIFIED
Scott Dexter
sgd at ti3.com
Fri Jun 22 16:17:57 CDT 2001
SQL Server will let you use [] in the parameter list of a stored proc to
encapsulate character data instead of using single quotes (').
The first [ encountered is the delimiter, and subsequent [ are treated as
character data. The closing ] is escaped by using two: ]]. Since one would
now have to search and replace on ] instead of ', this doesn't buy us
anything and gets chalked up as just a different way of skinning the same
cat. (though it does get you obfuscation points)
Now you know more than you wanted =)
sgd
> -----Original Message-----
> From: Scott Dexter [mailto:sgd at ti3.com]
>
> [] are used in the context of column names. SQL Server
> complains if you use
More information about the thelist
mailing list