Monthly Archives: December 2009

Sql Server- Difference between Stored Procedure and Function

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 … Continue reading

Posted in Imp SQL Difference, Interview Questions, SQL Functions, SQL Server, SQL Stored Procedure | Tagged | 6 Comments

Difference between Delete and Truncate Command

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 … Continue reading

Posted in Imp SQL Difference, Interview Questions, SQL Basic Concepts, SQL Server | Tagged | 1 Comment

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

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  … Continue reading

Posted in Most Imp SQL Concepts, SQL Server, SQL Stored Procedure | Tagged , , | 42 Comments