This website provides a SQL server, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .
You will find out a step-by-step walk through of the basics and advanced topics with practical and include numerous hands-on activities.
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 WHILE loop sets a condition for the repeated execution of an SQL statement or statement block.
SQL Server UNPIVOT allow us to transform columns of a table-valued expression into column values that is rotating columns into rows.
It performs a reverse operation of SQL Server PIVOT.
SYNTAX
SELECT …
FROM …
UNPIVOT (
FOR
[ … ]
SQL Server FOR JSON Clause
SQL Server FOR JSON Clause is used to format query result to JSON format or export data from SQL Server as JSON format. It was introduced in SQL Server 2016 version.
What is the difference between SQL Server Stored Procedures and User Defined Functions (UDF)?
Following are the some major difference between Stored procedures and User Defined functions
Return a value
Stored procedure may or may not return a value while UDF function must return a value.
How to get dark theme for SQL Server Management studio?
By default it is hidden in SQL Server management studio, you can quickly check by following below steps.
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 VARCHAR Data Type is used to store non-unicode string data of varaible length.
How to Display calendar dates for any n numbers of years in SQL Server?
Following are the links to download SQL Server 2019 and Database sample files
SQL Server CHAR data type is used to store non-Unicode string data of fixed-length.
SQL Server OFFSET FETCH clauses are used to set the limit to number of rows returned by a query.
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 Verbose Truncation Warnings
Sometimes we receives data truncation error in SQL Server such as “String or binary data would be truncated” and it does not specify exact source of error in terms of Database name, table name , column name and truncated values.
This is one of the most commonly asked question in SQL Server interview that how to find the Nth highest salary of employee with their… Read More »How to find Nth Highest Salary in SQL Server
SQL Server @@SPID
SQL Server @@SPID is a SQL Server configuration function that is used to return the session id of current user process.
SYNTAX
@@SPID
