ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories >> Software >> Databases >> SQL-PLSQL
 
 
 
Question
wht is the difference between truncat,drop in sqlserver
wht is the difference between function and stored procedure
 Question Submitted By :: Aseem
I also faced this Question!!     Rank Answer Posted By  
 
Answer
truncate command will remove the table and again recreate 
the table.
drop command will remove the table permanently from the 
database.


Function must return a value where as stored procedure may 
or may not return a value.
Function can return only one value where as stored 
procedure can return multiple values.
Function can be used in sql query where as stored procedure 
cannot be used in sql query.
Function is used to compute a value where as stored 
procedure can be used to perform a task
 
0
Chandra Shekher
 
View All Answers
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com