Tag: sql server

To split a delimited string to multiple rows using MSSQL you can use the snippet below. Sample MSSQL

To use select statement in a delete statement using MSSQL you can use the snippet below. Sample MSSQL

To get the size of all tables using MSSQL you can use the snippet below. Sample MSSQL

To use a select statement in a update statement using MSSQL you can use the snippet below. Sample SQL

To get the Monday date of the current week you can use the snippet below.

To delete duplicate records using MSSQL you can use the following snippet. The table must have identity column, which will be used to identify the duplicate records.

To check if a column exists in MSSQL you can use the following snippet. Sample MSSQL

To learn how to use the Space() function in MSSQL you can take a look at the following snippet.   Let’s say you have a table (tblTest) like this: ID…

To list all databases in MSSQL you can use the following snippet. Sample 1 MSSQL Sample 2 MSSQL