create database

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…

SQL Server Rename Table When the table name is no longer relevant or no longer serves the purpose of creation, we can…

SQL Server Temp Table A temporary (temp) table in SQL Server is a special table that cannot be stored permanently on the…

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…

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…