SQL Server Tutorial

Stored Procedure in SQL Server A stored procedure is a group of one or more pre-compiled SQL statements into a logical unit.…

SQL Server STUFF() Function This article will describe a complete overview of the STUFF function in SQL Server. Most of the DBA…

SQL Server Substring SUBSTRING is a SQL Server built-in function that allows us to extract a specific substring from any given string…

SQL Server SUM() Function The SUM() function in SQL Server is a type of aggregate function. We use this function to calculate…

SQL Server Synonym An alias or alternative names can be given to any of the database objects like a table, view, stored…

Table Variable in SQL Server Table variables are a special part of the local variable that allows us to hold complete table…

SQL Server Rename Table When the table name is no longer relevant or no longer serves the purpose of creation, we can…

SQL Server Temp Table A temporary (temp) table in SQL Server is a special table that cannot be stored permanently on the…

Triggers in SQL Server A trigger is a set of SQL statements that reside in system memory with unique names. It is…

SQL Server Replace The name ‘replace’ defines itself that means it replaces something with another value. The replace function in SQL Server…