Today, I am going to explain, what is stored procedure in SQL and advantage of stored procedure in SQL and something more about stored procedure how to create stored. So, I am trying to explain stored procedure with example.

Stored Procedure is a group of precompiled Transact SQL statement into a single execution plan. It reduces the network traffic and increase the performance because of the commands in stored procedure is executed as single batch of code.

Today I am going to explain difference between Primary key and Foreign key in SQL. It is very frequently asked interview question for beginner or experienced. So, I will try to explain one by one.

Primary Key

1.  Primary key is a column or set of columns that is basically used to identity a rows in table.

2.  Primary key can’t be null. It means that if you define a column or set of columns as primary key then you can not pass null value in that column.