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
- 7837 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
How to Check if table exists in sql server?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Can I work with several databases simultaneously? : sql server management studio
What are the advantages of passing name-value pairs as parameters?
What is dbcc? Give few examples.
What is star, snowflake and star flake schema? : sql server analysis services, ssas
Explain what is the purpose of sql profiler in sql server?
Do you know how to make remote connection in database?
What is indexing in sql server with example?
how many no of arguments can be passed in procedures and functions
What does select 1 mean?
What does nvl stand for?
How can you append an identity column to a temporary table?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
