SQL Server Tutorials

Getting started with MS SQL Server

SQL Stands for Structured Query Language. It is a relational database management system (RDBMS), developed by Microsoft.

SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.

Top 50 SQL Interview Questions and Answers

150 SQL Interview Questions and Answers Cheat Sheet

Let’s get started with below topics-

What is SQL SERVER?

CREATE TABLE

INSERT

UPDATE

DELETE

SELECT

SQL Keys

SQL Commands

Alter Table

IDENTITY Functions in SQL Server

SQL Server Configurations Functions

SQL OUTPUT Clause

Query Optimization in SQL Server

Replicate Function in SQL Server

SQL CAST vs TRY_CAST()

SQL CONVETRT vs TRY_CONVERT 

Full Database Backup Script in SQL Server

SQL Server Dirty Read Concurrency

BEGIN TRAN

ROLLBACK TRANSACTION

COMMIT TRANSACTION

SAVEPOINT TRANSACTION

How to Find and Remove Duplicate Records in SQL and Keep Only One Record

How to Calculate Running Total in SQL