Xp_readerrorlog is a SQL Server extend stored procedure allows you read the contents of the SQL Server error log files. It allows you to read… Read More »How to Read SQL Server error logs using the xp_readerrorlog
SQL JSON_QUERY is a JSON function which extracts an object or an array from a JSON string. JSON_QUERY function introduced in SQL Server 2016. You… Read More »SQL JSON_QUERY Function
The JSON_MODIFY is a JSON functions that allows you to update the value of a property in a JSON string. It introduced in SQL Server… Read More »SQL JSON_MODIFY Function
A correlated subquery is a subquery that uses the values of the outer query and it is evaluated for each row processed by the outer… Read More »SQL Correlated Subquery
The SQL GOTO statement is used to alter the flow of execution. When the execution reaches the GOTO statement.
A SQL cursor is a database object that is used to retrieve data from a result set one row at a time. A SQL cursor is used when the data needs to be updated row by row.
SQL Server FIRST_VALUE function is a Analytic function which returns the first value in an ordered set of values.
SQL Server WHILE loop sets a condition for the repeated execution of an SQL statement or statement block.
NCHAR data type is used to store Unicode string data of fixed-length.
NCHAR data type is used to store Unicode string data of fixed-length.
It stores data at 2 byte per character.
It supports up to 4000 characters.
SQL Server NVARCHAR is used to store uniqcode string data of variable length, it can store both unicode and non unicode strings.
SQL Server OFFSET FETCH clauses are used to set the limit to number of rows returned by a query.
How to Display currency symbol in SQL Sever?
Sometimes we are required to display a currency symbol along with the amount in query result set, It becomes challenge to displaying a currency symbol with amount.
SQL Server LAG() function is a Analytics Functions that provides access to a row at a given physical offset that comes before the current row.
SQL Server LEAD() function is a Analytics function that provides access to a row at a specified physical offset which follows the current row.
Basically, LEAD() function provides access to a row at a given physical offset that follows the current row.
How to send a SQL Server Query result in e-mail message?
If we have configured SQL Server Database Mail then we can easily send query result as an attachment in mail body.
A synonym is a database object that allows an alternative name for another database object, referred to as the base object, that can exist on a local or remote server.
How to Find out Identity Column Without Using Column Name ?
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 ISNUMERIC( ) function is System Functions which is used to check if the expression is valid numeric type or not.
