Stored procedure for insert, update, delete, Select and search operation in table In SQL Server

What is Stored Procedure?

A stored procedure is a pre-compiled group of Transact-SQL statements. A stored procedure is a group of SQL statements that has been created and stored in the database . Stored procedure will reduce network traffic and increase the performance.

It is always recommended to create Stored Procedure instead of writing Inline queries so that we can just call the Stored Procedures whenever required instead of writing Inline queries each time.

Read More

Difference between Delete and Truncate in SQL server

Introduction:

Difference between DELETE and TRUNCATE in SQL Server is one of the most important interview questions asked to fresher. I have tried to explain it here so that fresher can better understand the difference between these two.

Read More