sql server tutorials

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

SQL Server DELETE or DROP Table SQL Server allows DBA to remove a table, which is not relevant or obsolete in our…

SQL Server HAVING The HAVING clause in SQL Server is used to specify the search condition for a group or an aggregate.…

SQL Server MAX() Function The MAX() function in SQL Server is a type of aggregate function. It is used to get the…

SQL Server CONCAT_WS Function The CONCAT_WS is a string function that returns a single string by concatenating or joining two or more…

SQL Server DELETE Top Statement In SQL Server, DELETE TOP statement is used to delete the records from a table and limit…

SQL Server IDENTITY The IDENTITY keyword is a property in SQL Server. When a table column is defined with an identity property,…

SQL Server MERGE This article will give a detailed explanation of the MERGE statement in SQL Server. It was first introduced by…

SQL Server Constraints Constraints are the predefined set of rules and restrictions applied on the tables or columns for restricting unauthorised values…

SQL Server Describe Table DESCRIBE means to show the information in detail. Since we have several tables in our SQL Server database,…