sum function

SQL Server Replace The name ‘replace’ defines itself that means it replaces something with another value. The replace function in SQL Server…

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 ROLLUP The ROLLUP clause in SQL Server is an extension of the grouping set operator. This article will give a…

SQL Server UNION Operator In SQL Server, the UNION operator is used to combine the result-set of two or more SELECT statements.…

SQL Server Row Number Row number is the most common ranking function used in SQL Server. The ROW_NUMBER() function generates a sequential…

MS SQL Server Select Database SQL Server select database specifies your database in which you want to create your table and further…