Tag: database

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 return the SHA1 hash value of a string in SQL Server ?

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

Sleep Command 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

How to drop a table if it exists in SQL Server 2014 ?

How to rename a column in SQL Server ?

How to escape a single quote in SQL Server ?

How to find the duplicate records on certain fields in SQL Server ?

How to get the list of all tables from a SQL Server database ?