Tag: microsoft sql

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 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.

In MSSQL IF ELSE is not supported inside the SQL-Query. For a similiar behaviour you should use CASE WHEN keyword. Sample Query

To list all Databases in MSSQL you can use the following snippet. Sample MSSQL SQL Server Version newer than MS SQL 2000 also support these StoredProcedures. or