Tag: 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 get the current Database and Log Filesize using MSSQL you can use the snippet below. Tested using SQL Server 2012. Sample MSSQL Sample Output

To drop Primary Key of a Table using MSSQL you can use the snippet below. http://youtu.be/0kfyw8M83bA Sample MSSQL

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 remove any post that is older than X days in WordPress you can use the query below. Sample mySQL

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.