advance operator

SQL Server Show/List Databases It’s a common task to display or list all databases, listing tables of a particular database, and information…

SQL Server Window Functions We are all well-known for the regular aggregate function that performs calculations on the table and works with…

SQL Server String Functions A string function accepts a string value as an input and returns a string value regardless of the…

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…