Differences between functions and stored procedures?

Answer Posted / santhoshkumar.k

store procedure takes less time to execute the statement
than functions, also we can create loops inside the store
procedure.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know what are the steps to process a single select statement?

535


What are clustered and non-clustered index?

550


What is transaction server implicit?

534


What is index, cluster index and nonclustered index?

516


What is bit data type? What's the information that can be stored inside a bit column?

523






Explain tables in SQL Azure?

96


What is sql server query analyzer?

513


What is snapshot report?

129


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1514


Which is the best place or learning center for MS SQL?????In Bangladesh?????

1595


How many types of cursor type are there?

591


What are the basic functions for master, msdb, model, tempdb databases?

591


What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

590


What is the distinction amongst delete and truncate?

585


What are sub reports?

151