hi everyone to specify state difference just visit the

http://sqldebate.blogspot.in/2012/02/diffrence-between-stored-procedure-and.html

I am sure you will get 100% satisfactions with answer.

Hi for more practical explanation and conceptual funda visit

http://sqldebate.blogspot.in/2012/01/difference-between-truncate-and-delete.html

HI this was nice post

for further more simple practical example visit

hI there is nothing but probably it may have sql server error which you have to check from your procedure

here i have paste the link where i have...