Category Archive

What is Output Clause in SQL SERVER? OUTPUT clause enables us to get access to recently inserted or deleted rows or records in a table. The OUTPUT clause can be …

What is Truncate Command in SQL SERVER? TRUNCATE Commands deletes all data from a table. The TRUNCATE command is similar to the DELETE command but it is like dropping a …

How to delete a row in SQL Server Delete Command is used to delete existing data from a table. The Data that is entered incorrectly should be deleted or sometimes …

How to update in SQL SERVER? The Update query is used to update the existing data in the database. Suppose the data entered is incorrect and needs to be changed …

What are Aggregate Functions in SQL SERVER? Aggregate functions are some built-in functions by SQL SERVER that performs calculations on any set of data. Aggregate Functions return a single value …

What are Joins? Joins enable us to retrieve columns from more than one table at a time as one result set. The relationship between the tables is not mandatory. There …

Select Statement in SQL Server The SELECT statement is used to retrieve data from the database. We use a SELECT statement with ‘SELECT’ keywords followed by column names and the …

Insert Command in SQL SERVER Insert command is used to insert data into SQL Server table. You can use the ‘insert command‘ to insert data directly into a table using …

Create Table Create Table command is used to create a table in SQL Server. Create Table Command syntax is as follows. In order to create a table in T-SQL, we …

After creating a database in SQL Server Now it is time to create a table. Scenario Create a table that stores basic information about a user that can log in …