Knowledge Walls
Gopal Rao
Mumbai, Maharashtra, India
Passcode:
Truncate stored procedure sql server in Queries of SQL Queries
2341 Views
Hints 
Store procedure used to write to do some specific task like function and the same store procedure can used in various place according to the need to redues the coding.

Difference between function and store procedure :
  1. function can return only one value.but store procedure can return many values with out parameter.
  2. store procedure have input and output parameters but function have only input parameters.
In following example i show how to truncate the store procedure
Syntax
truncate procedure procedureName;
Example
truncate procedure SP_example;
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details