SQL Server

SQL Server basic to advance level tutorials with query Optimization techniques, learn step by step with an example.

SQL Server Configuration Functions

Some useful SQL Server configuration functions: @@SERVERNAME, @@VERSION, @@SPID & @@LANGUAGE Read More

Types of SQL Server commands- DDL, DML, DCL, TCL, DQL, Or list of SQL Server commands. Read More

SQL Replicate is a String function, it is used to repeat the existing string for a specified number of times. Read More

A SQL Server IDENTITY column is used to generate key values automatically based on a provided seed and increment value. Read More

What is SQL Server Query optimization? Improving Query Performance in SQL Server. Read More

Database backup is very important for any organization, this post explains how you can take SQL backup through SQL script. Read More

In this tutorial we will understand, How we can Get same prefix- suffix tables from SQL Database?
Read More