SQL Stored Procedures A stored procedure is a group of Transact- SQL statements compiled into a single execution plan. So if you think...

A stored procedure is a subroutine available to applications that access a relational database system. A stored procedure (sometimes calle...

SQL SELECT TOP, LIMIT, ROWNUM - In a Query Recently in one of the interviews I was asked how to Limit SQL Query result in MS SQL , M...

SQL Database Naming Convention In this post I will explain about naming convention for database schema  such as database table, field, p...

Codd's 12 rules - A Gentle Introduction to SQL Database Edgar Frank “Ted” Codd, the same person who invented relational data base...

All about Sql Server: example of Cursor in sql server What is a Cursor in SQL Server? A Cursor is a SQL Object, or we can say like a...

SQL Server Tutorials For Beginners Microsoft's SQL Server is a powerful database server that integrates well with other Microsoft ...