What is the difference between a stored procedure and a user
defined function in sql server?
Answer Posted / samant
1.For user defined function one must have to specify it's
return type while in stored procedure it is not mandatory.
2. u can use function in expression but not stored
procedures
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is the use of tempdb? What values does it hold?
Describe in brief system database.
Define cursor locking
How can we migrate from SQL server to SQL Azure?
Explain the different types of joins?
Explain syntax for disabling triggers?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
How to add a new dsn with the odbc driver for sql server?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
whats new about truncate in sql server 2008?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Explain the truncate command?
How many partitions a clustered index has by default in sql server 2012?
What is provisioning, billing and metering, and connection routing concepts in the service layer?