Tag: Microsoft SQL Server 2012

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

To TRIM a string in MSSQL you can use the following Userdefinedfunction Snippet. Sample MSSQL

To check if a column exists in MSSQL you can use the following snippet. Sample MSSQL

To select date from datetime in MSSQL you can use the following snippet. Sample MSSQL The 104 is for tt.mm.jjjj, a list of formats can be found at the MSDN…

To list all users in MSSQL you can use the following snippet.

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…

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…