select database

SQL Server SELECT The SELECT statement in SQL Server is used to display all or specific records from the table. This statement…

SQL Server WHERE Clause The WHERE clause in SQL Server is used to filter records from the table. It is an optional…

SQL Server Sequence SQL Server Sequence is used to create a sequence object and its properties can also be specified. A sequence…

SQL Server WHILE LOOP This article will teach you about a complete overview of using the WHILE loop in SQL Server. A…

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…

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

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.…

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