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
Why should we go for stored procedures? Why not direct queries?
Explain collation?
Which data type columns are the best candidates for full-text indexing?
What is data set in report?
How can I know what locks are running on which resource?
What is Command line parameters in PLSQL.?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What are the steps you must follow to hide sql server instances?
What are the different types of collation sensitivity in sql server?
What is a non-clustered index?
whats the maximum size of view state??
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is the full form of ddl?
Define primary key?
How would you add a section to a table?