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
- 7950 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 service broker? : sql server database administration
How to download and install microsoft .net framework version 2.0?
Tell me what is a linked server?
What is sql or structured query language?
How do I perform an unattended install of sql server 2000?
Can you force a query to use a specific index?
What is a ddl statement?
What are the acid properties?
How to return the top 5 rows from a select query in ms sql server?
What are the different types of data sources in ssrs?
What is the difference between a check constraint and a rule?
Explain linked server in sql?
Is there any difference between primary key and unique with the not null condition?
What is intellisense?
Tell me what is the significance of null value and why should we avoid permitting null values?
