Tag: SQL Server

SQL Server 101 – Return the Current DateTime

How to Specify port number for Server when connecting in SQL Management Studio ?

Dealing with the column names that looks like SQL Keywords in SQL Server

SQL Server 101 – How to add a column with a default value to existing table ?

SQL Server 101 – Get the size of all tables in database

How to Export the Query Result to .csv file in SQL Server?

SQL Server’s ISNULL() equivalent in PostgreSQL

How to Get the Number of Tables from SQL Server Database ?

white smartphone

Open DBDiff for SQL Server

How to check if the table exists in a database in SQL Server ?

Column Alias and Square brackets in SQL Query.

What are the Limitations of SQL Server Express Edition ?

WAITFOR TIME in SQL Server

How to replace NULL values with alternate values in SQL Server ?

Other ways of specifying the alias name for a column in SQL Server

Difference between DELETE and TRUNCATE command in SQL Server

How to Create a Database Backup in SQL Server using SQL Scripts?

Using Expressions for SORT Order in SQL Server

SQL Server 101 – How to Delete Top N records ?

Wildcard Search in SQL Query