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.
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.
Pages : 1