2010-10-04 (first published: 2010-09-29)
2,901 reads
Atif-ullah Sheikh
Way to Check Multiple LIKE without dynamic SQL
I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.
2010-09-16 (first published: 2010-09-15)
3,538 reads
2010-07-27 (first published: 2010-07-09)
2,156 reads
2010-07-20 (first published: 2010-06-23)
2,562 reads
Parsing / breaking character separated values in a table in one query
At times, we have situation to parse the character separated string in the table column.
2010-07-14 (first published: 2010-06-17)
2,177 reads
Get default values of parameters in stored procedures
Helps to get the default value of parameters from stored procedures and functions.
2010-06-22 (first published: 2010-05-26)
2,299 reads
Blogs
Gathering More Digital Data with Tile Slim
By Steve Jones
After my wallet misadventures, I ordered a Tile Slim to track my wallet. It...
Accessibility is not just about slides
Although I don’t write about it much on this website, I am on the...
Daily Coping 4 Aug 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Nested Join Alternative
Is there a better way to write this nested join query? I'm concerned about...
How to determine whether SSIS is being used?
Hello I've inherited some dev environment which looks like was abandoned, but I'd like...
xml output from sql query
The script runs but gives me "no data to export" I see data in...
Ask SSC