I use IF EXISTS (SELECT null FROM .. ) as a programming standard. Once you get used to it, it makes statements with existence tests easier to read. I got this tip from the O'Reilly book SQL Cookbook....

I use IF EXISTS (SELECT null FROM .. ) as a programming standard. Once you get used to it, it makes statements with existence tests easier to read. I got this tip from the O'Reilly book SQL Cookbook....

I use IF EXISTS (SELECT null FROM .. ) as a programming standard. Once you get used to it, it makes statements with existence tests easier to read. I got this tip from the O'Reilly book SQL Cookbook....

The link just takes me to the SolidQ web site. What's up with that?...

The link just takes me to the SolidQ web site. What's up with that?...

The link just takes me to the SolidQ web site. What's up with that?...

This is a good tip to feature, but your "usage" description is inaccurate. Compare to this: Usage: The string specified in the expression param replaces the number of characters specified in @Length param starting from the position mentioned in @Offset...

This is a good tip to feature, but your "usage" description is inaccurate. Compare to this: Usage: The string specified in the expression param replaces the number of characters specified in @Length param starting from the position mentioned in @Offset...

This is a good tip to feature, but your "usage" description is inaccurate. Compare to this: Usage: The string specified in the expression param replaces the number of characters specified in @Length param starting from the position mentioned in @Offset...

The IN clause in T-SQL can be used to find a single value present in any one of multiple supplied columns. For example, in the AdventureWorks database: [code] SELECT Title, FirstName, MiddleName, LastName, Suffix FROM Person.Contact WHERE 'Lee' I...