Tag: database

How to Display list of databases on a MySQL?

CASE expression in a Query in SQL Server

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

Using FETCH and OFFSET to get N records in SQL Server

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

How to get the Size of all tables in a SQL Server ?

How to disable Foreign Key constraints using T-SQL 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 get the first character of a string in SQL Server ?

Checking the version of a SQL Server using T-SQL

How to get the date part from the date time in SQL Server ?

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

Exit the Current Scope with a return value in SQL Server

How to escape a single quote in SQL Server ?

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

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

How to rename a column in SQL Server ?

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

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