SQL Advance Tutorial
SQL Server Dynamic PIVOT
SQL server allows us to transform a row- level data into columnar data using SQL Pivot.
SQL CLUSTERED INDEX
SQL Server Clustered index
A clustered index defines the order in which data is physically stored in a table. A table can have only one clustered index because data rows can be only sorted in one order.
SQL SERVER IF..ELSE
SQL Server IF..ELSE block is a control-of-flow that allows you to execute or skip a statement block based on a specified condition.
SYNTAX
IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE { sql_statement | statement_block } ]
SYNTAX
IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE { sql_statement | statement_block } ]
SQL Server NCHAR
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 Download links
Following are the links to download SQL Server 2019 and Database sample files
SQL Server PATINDEX
SQL Server PATINDEX function is a string function that returns the starting position of the first occurrence of a pattern in a specified expression.
SQL Server @@Version
SQL Server @@Version is a configuration function that returns system and build information for the current installation of SQL Server. SYNTAX @@Version Return Type of… Read More »SQL Server @@Version
SQL SERVER SP_MONITOR
SP_MONITOR is a SQL Server Database Engine system stored procedure which is used to Display statistics about Microsoft SQL Server.
SYNTAX
EXEC sp_monitor
SP_RENAME in SQL Server
SQL Server SP_NAME is SQL Server Database Engine stored procedure that is used to Changes the name of a user-created object in the current database. This object can be a table, index column or alias datatype.
SQL Server STRING_AGG Function
SQL Server STRING_AGG() Function is string function which concatenates values for any given string expressions and separate them a specified separator.
It does not add the separator at the end of the result string.
String expression values are implicitly converted to string types and then concatenated.
SQL Server Format Function
The SQL Format function is a SQL Server string function which is used to format the specified value in the given format such as to format the date/time values and number values.
Troubleshooting Database Mail in SQL Server
Troubleshooting Database Mail
If you are not getting Database Mail after configuring it , you need to got through few more step to fix it.
Displaying Emoji in SQL Server
In SQL Server we can create a database, table and write T-SQL query using emoji.
Here we will create a table and then insert few records into table.
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 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.