Tag: TSQL

Published October 1, 2020

Using COALESCE to avoid using sp_executeSql

When creating stored procedures, we sometimes have to include null or optional parameters. We are then forced to manage the situation where the parameter is…

Published October 1, 2020

Format datetime & date in SQL Server 2005

Often we end up on older versions of SQL Server and we have to recall the old ways for doing things. Here is a handy…