2018-05-18
954 reads
Coalesce()
2016-01-29
1,664 reads
COALESCE in SQL Server
Sandeep Mittal provides an introduction to the COALESCE function and shows how to use it.
2015-11-25
4,572 reads
2013-09-20
2,698 reads
2013-06-03
2,585 reads
2012-11-09
2,194 reads
2012-10-17
2,476 reads
Create string from table
This simple script retrieves a range of values from a table and presents the results as a string.
2008-09-15 (first published: 2008-07-16)
1,586 reads
Blogs
SQL in the City Comes Back to Seattle
By Steve Jones
This year at the PASS Summit, Redgate is holding our SQL in the City...
Backup Techniques for SQL Server on Azure Virtual Machines
By Arun Sirpal
In the previous blog post I did a quick overview building a SQL VM...
SQLCover 0.5 - Fixes, smaller features and an exciting surprise
By Ed Elliott
It has been a little while but I have updated SQLCover to include a...
Forums
Exception handling for backup related errors.
Hi All, Need some help in exception handling. In below code, I want to...
DB Log File Location Error
Hi, I am taking full backup of db on remote location. The issue we...
SQL query help
I have a table like this: Year month col_abc1 col_abc2 col_abc3 col_abc4 col_processing 2019...
Ask SSC