SQL Server Archives - Abundant Code

Checking the version of a SQL Server using T-SQL

How to get the first character of a string in SQL Server ?

How to change the ‘Edit Top 200 Rows’ in SQL Management Studio ?

How to Check if a login exists in SQL Server ?

What is the equivalent of MySQL’s Now() function in SQL Server ?

How to get the first day of the month in SQL Server ?

Get the date in YYYY-MM-DD format in SQL Server.

SQL Server – Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

How do you check if an index exists in a table?

How to select N random rows using a T-SQL Query ?

How to display Row Numbers in the results in SQL Query ?

How to return the SHA1 hash value of a string in SQL Server ?

How to get the table structure in SQL Server ?

Specify a port number when connecting to SQL Server in Management Studio

Sleep Command in SQL Server

How to return rows in random order in SQL Server ?

How to remove a column from an existing table in SQL Server?

How to copy tables from a database to another in SQL Server ?

How to get all the column names of a table in SQL Server ?

Inserting a line break in the NVARCHAR data in SQL Server