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
What is cached report?
What is user defined stored procedures?
What is lookup override?
What is sql collation?
can you instantiate a com object by using t-sql? : Sql server database administration
What is an indexing technique?
What is difference between cte and view?
Can we return Data from 4(more than 1) tables in stored procedure?
What is SQL Azure Firewall?
What are the different editions available in sql server 2000?
How to provide login information for a new odbc dsn?
what is denormalization? : Sql server database administration
How can we determine what objects a user-defined function depends upon?
What functions can a view be used to performed?
What is acid properties?