Rakesh Kalluri's contributions

Learn how to use SQL Server ranking functions including ROW_NUMBER, RANK, DENSE_RANK, and NTILE with ORDER BY and PARTITION BY examples.

Learn how to use SQL Server OFFSET-FETCH with ORDER BY to skip rows, fetch result sets, and implement pagination.

This article explains the use of the merge statement with XML data in SQL Server.

This article explains the Merge statement in SQL Server. With the Merge statement we can merge the data from a source table into a target table.

This article will show the differences among scope_identity (), @@identity and ident_current.

In this blog you will learn how to use the CHARINDEX function in SQL Server.

This blog describes the difference between Delete and Truncate in a SQL query.

In this blog you will learn how to use WAITFOR query in SQL.

In this blog, you will learn how to reset an Identity Column Value in SQL Server.

This blog describe the difference between LEN and DATALENGTH function in SQL database.

In this blog you will learn how to Inserting Data From Store Procedure.

In this blog, I am demonstrating running the .sql files form the command prompt.

In this article, I explain the best way to insert valid data using constraints. How to enable check constraint on the table, How to enable FOREIGN KEY Constraint.

Learn how to create SQL Server computed columns with CREATE TABLE and ALTER TABLE, compare persisted and non-persisted columns, and understand their limitations.

This blog defines data base management system.

This blog defines how to export excel data to SQL using T-SQL.

This article explains Union and Union All in SQL Server.

In this article we will see a simple script to backup a database to disk drives.