Pradeep Raturi

I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.

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.

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 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

SQL Primary Key constraint

A PRIMARY KEY constraint uniquely identifies each record in a table .

SQL FOREIGN KEY Constraint

A foreign key is a key used to link two tables together. This is sometimes also called as a referencing key , usually a primary key table is considered as a parent table while a foreign key table is considered as a child table .