[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