SQL Server Configuration Functions
Some useful SQL Server configuration functions: @@SERVERNAME, @@VERSION, @@SPID & @@LANGUAGE Read More
![]()
SQL Server basic to advance level tutorials with query Optimization techniques, learn step by step with an example.
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
![]()