Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between stored procedure and function?
- 3 Answers
- 7430 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / a.suresh
1.Stored Procedure return 0 to nth value where as function
return only one value which is must.
2.we can't use the stored procedure in select select
statement where as function can be used in the select statement.
3.we can use all the dml(insert,update,delete) commands in
stored procedure where as select statement only used in
functions.
4.we can use try catch in stored procedure where as in
functions cant.
function must be used with its schema where as stored
procedure used with out schema name
ex.dbo.function name
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the function of inner join?
What is a ddl statement?
What is ssrs?
What will be query used to get the list of triggers in a database?
What is the difference between a function and a trigger?
What do you mean by acid?
What is dynamic cursor in SQL SERVER?
How to access the deleted record of an event?
what is datawarehouse?
What do you mean by the term 'normalization'?
What is a dbms wizard?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
Is sql server difficult to learn?
What is resource governor in sql server?
What is the tcp/ip port on which sql server runs?
