December 2009 - Technology with Vivek Johari

Sql Server- Difference between Stored Procedure and Function

December 22, 2009February 1, 2019 vivekjohari6 Comments

In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to complete a task, but still there are many differences between Stored procedure and Functions. These differences can be summarized as follows:- 1) A stored procedure can return a value or it may not return any […]

Difference between Delete and Truncate Command

December 17, 2009February 1, 2019 vivekjohari1 Comment

Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still there are many differences in their working. These differences are given below:- 1) Delete command maintained the logs files of each deleted row but Truncate command do not maintain the logs files for each deleted […]

Sql Server – How to write a Stored procedure in Sql server

December 5, 2009February 1, 2019 vivekjohari42 Comments

Stored Procedure:- Stored Procedure In Sql server can be defined as the set of logically group of sql statement which are grouped to perform a specific task. There are many benefits of using a stored procedure. The main benefit of using a stored procedure is that it increases the performance of the database.The other benefits […]