How to split a delimited string to multiple rows using MSSQL
To split a delimited string to multiple rows using MSSQL you can use the snippet below. Sample MSSQL
All the Code Snippets and Samples you need
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.
When using a case-insensitive Server Collation your sql queries are case-insensitive by default. To write a case-sensitive MS-SQL query, you need to add the keyword. In this sample we used…