Stored Procedure in SQL Server A stored procedure is a group of one or more pre-compiled SQL statements into a logical unit.…
Tag:
primary keys
-
-
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…