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 ?