SQL Server CUBE
CUBE operator is used to calculate subtotals and grand total for all combinations of grouping columns specified in the GROUP BY clause.
Home » SQL Tutorials »
SQL Tutorials
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 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.
SQL Server CHOOSE Function
SQL Server Tutorials By Pradeep Raturi : SQL Server CHOOSE Functions is the logical function that returns the item at the specified index from a list of values in SQL Server.
SQL Server IIF Function
SQL Server Tutorials By Pradeep Raturi : SQL Server IIF function is the logical function that returns one of two parts, depending on the evaluation of an expression.
Temporary table / temp table in SQL Server
Temporary or Temp tables are tables that exist temporarily on the 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.
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.
SQL Server Interview Question & Answer Quiz on CREATE statement
SQL Server Interview Question & Answer Quiz on CREATE statement
SQL SERVER Interview Q & A QUIZ on SUBSTRING()
SQL interview question and answer on Substring function
SQL Server DENSE_RANK()
The DENSE_RANK() is a Ranking function that is used to assign ranks to rows in partitions with no gaps in the ranking values.
SQL RANK()
The RANK() function is a window function that is used to assign a rank to each row in the partition of a result set.
SQL Server ROW_NUMBER()
SQL Row_Number() is a ranking function/window function that is used to assign a sequential integer to each row within a partition of a result set. The row number starts with one for the first row in each partition.
SQL SERVER EXCEPT
The SQL EXCEPT clause is used to combine two SELECT statements and returns rows from the first SELECT statement that are not returned by the second SELECT statement.
SQL SERVER INTERSECT
The SQL INTERSECT clause is used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement.
SQL SERVER User Defined Table Type and Table Valued Parameters
The Concept of User Defined table type and table valued parameters were introduced in SQL server 2008.
Get the definitions of Stored procedures, User Defined functions and Triggers in SQL
How to get the full text descriptions / definitions of any stored procedures , UDF or triggers in SQL ? There are many ways to… Read More »Get the definitions of Stored procedures, User Defined functions and Triggers in SQL
SQL Unique Key Constraint
A unique key constraint is a set of one or more than one columns of a table that uniquely identify a record in a database table.
SQL Q & A on SELECT Statement
Q 1 > SELECT Count(1) as Output 1> NULL 2> Error 3> 1 4> Invalid select statement Answer Q 2 > SELECT Count(*) as… Read More »SQL Q & A on SELECT Statement
