Articles by Rakesh Kalluri

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

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