SQL Server Tutorial

SQL Server Transaction A transaction in SQL Server is a sequential group of statements or queries to perform single or multiple tasks…

View in SQL Server A view is a database object that has no values. It is a virtual table, which is created…

SQL Server Replication Replication in SQL Server is a technology for copying and distributing data and database objects from one database to…

SQL Server Truncate Table The TRUNCATE TABLE statement in SQL Server is a DDL (Data Definition Language) command. This statement is used…

SQL Server Tutorial SQL Server Tutorial provides basic and advanced concepts of SQL Server. Our SQL Server Tutorial is designed for beginners…

SQL Server Composite Key A composite key in SQL Server is a combination of more than one column. It is used to…

SQL Server DELETE Data In SQL Server database, DELETE statement is used to delete records from the table. Syntax: SELECT TOP 1000…

SQL Server GROUPING SETS GROUPING SET is an extension of the GROUP BY clause. The GROUP BY statement is GROUPING SET is…

SQL Server Mathematical Functions Functions are objects that have a set of SQL statements. Each function accepts parameters as input and performs…

SQL Server CONCAT Function The SQL Server CONCAT is a string function used for joining two or more strings. If it finds…