Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a stored procedure and a user
defined function in sql server?
- 2 Answers
- 7856 Views
- Millennium, I also Faced
- E-Mail Answers
Answer Posted / kumar.t
1. Stored Procedure to return the output parameter.
but function only return single values no output
parameter.
2. Select Clause we cann't use stored procdure. but
fucntion we can use.
3. XMl Clause contain we can use stored procdure. but
function we cann't use.
4. Whenever to execute function at present any error in the
function automatically to exit from the function. but
stored procudure to ignore the error then go to next line.
By
Kumar.T
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is a heap?
Write a sql query to delete duplicate records from a table called table1
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What are the transaction properties?
What is a coalesce function?
Do you know spatial data types - geometry and geography in sql server 2008?
What are the types of user defined functions in sql server?
What new changes are being made in SQL Server?
Can we delete data from a view?
List down some advantages of sql stored procedure?
Where can you add custom error messages to sql server?
Explain transaction server consistency?
What are the advantages of mirroring?
How to find the service pack installed? : sql server database administration
What is “asynchronous” communication in sql server service broker?
