learn sql

SQL SERVER REVERSE

SQL Server REVERSE Function is a string function that returns the reverse order of a string value. It returns a value of type varchar or nvarchar .

SQL SERVER SET IDENTITY_INSERT

SQL Server IDENTITY_INSERT allows explicit values to be inserted into the identity column of a table.

The IDENTITY_INSERT statement must be set ON to insert explicit value for identity column. By default IDENTITY_INSERT is OFF.

SQL SERVER SET DATEFORMAT

SQL Server SET DATEFORMAT is used to set the order of the month, day, and year date parts for interpreting date character strings.

SQL SERVER SET XACT_ABORT

SQL Server SET XACT_ABORT controls the atomicity of any user defined transaction.

SQL SERVER ISNULL

SQL Server ISNULL() Function is a system function that returns the specified value if the expression is NULL else it returns the expression.

SQL Server @@ERROR is a global variable that returns an error number if the last statement encountered an error but we have to trace it within just after the next line where the actual error occurred, otherwise, it will reset to 0.

SQL Server NEWID()

SQL Server NEWID() function is a system function that is used to generate a unique value of type uniqueidentifier.

SQL SERVER @@IDENTITY

SQL Server @@IDENTITY function is a system function that is used to get the last IDENTITY value generated for any table with an identity column under the current session, regardless of the scope of the T-SQL statement that generated the value.

SQL Server Create SCHEMA

A Schema in SQL Server is a collection of database objects associated with a database.

SQL Server Recursive CTE

A Recursive CTE (Common Table Expression) is a CTE that references itself. In doing so, the initial CTE is repeatedly executed, returning subsets of data, until it returns the complete result set.

SQL Server CONCAT_WS Function

SQL Server CONCAT_WS() function is a string function that is used concatenates two or more strings together with a separator.

It separates those concatenated string values with the delimiter specified in the first function parameter.

SQL Server GROUPING SETS

SQL GROUPING SETS allows computing multiple GROUP BY clauses in a single statement. The results of GROUPING SETS are the equivalent of UNION ALL of the specified groups.

How to Retrieve data in XML Format in SQL SERVER

How to Retrieve data in XML Format in SQL SERVER ?

SQL SERVER TRY_CAST()

SQL Server TRY_CAST() Function is a conversion functions that is used to cast a value to a specified data type.

Delete duplicate rows from a table in SQL Server

how to delete duplicates records from a table in sql server ?.

SQL Server CTE

SQL Server CTE (Common Table Expression) is temporary result set that is used to reference within another SELECT, INSERT, UPDATE, or DELETE statement.

SQL Server Sequence

A Sequence objects are used to sequentially generate numeric values that can be in ascending or descending order at a defined interval and may cycle if requested.