How to search stored procedures using MS-SQL
To search stored procedures using MS-SQL you can use the snippet below. https://www.youtube.com/watch?v=qbHT5HYyTKg Sample MSSQL
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
How to use select statement in a delete statement using MSSQL
To use select statement in a delete statement using MSSQL you can use the snippet below. Sample MSSQL
How to get the size of all tables in MSSQL
To get the size of all tables using MSSQL you can use the snippet below. Sample MSSQL
How to use a select in update statement using MSSQL
To use a select statement in a update statement using MSSQL you can use the snippet below. Sample SQL
How to delete duplicate records using MSSQL
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.
How to list all databases in MSSQL
To list all databases in MSSQL you can use the following snippet. Sample 1 MSSQL Sample 2 MSSQL