2010-10-04 (first published: 2010-09-29)
2,904 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,620 reads
2010-07-27 (first published: 2010-07-09)
2,156 reads
2010-07-20 (first published: 2010-06-23)
2,567 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,180 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,569 reads
Blogs
Visiting with DBAs at midnight : T-SQL Tuesday #153
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our...
Working with Neo4j Imports–I HATE CASE SENSITIVITY
By Steve Jones
I’ve been working to better understand graph databases and where they can be useful....
Daily Coping 8 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
MAX not working with a CTE
I have a query that is supposed to return one patient id but even...
doe it locks my view while checking it ? EXEC sp_refreshview '[View_SCHEMA]'
i have a cursor that runs on all my views and then exec...
Transaction log full error 9002 on Alwayon Availability groups
Hi All, I am looking for some inputs on how to avoid or prevent...
Ask SSC