Tag: MS-SQL

To catch specific SQLExceptions using Microsoft.NET and Microsoft Sequel Server you can use the snippet below. You also need to look for the specific error numbers/codes you want to catch.…

To search stored procedures using MS-SQL you can use the snippet below. https://www.youtube.com/watch?v=qbHT5HYyTKg Sample MSSQL

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 table exists in MSSQL you can use one of these two snippets. Sample MSSQL using INFORMATION_SCHEMA Sample MSSQL using OBJECT_ID

To add a new column to an existing table in MSSQL Server you can use the following snippet. if you need to check if the column already exists you can…