Differences between functions and stored procedures?
Answer Posted / purushotam bhardwaj
FUnction use when you want to return any value only
but SP is best for all
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are parameterized reports?
What is table valued function and scalar valued functions?
How do I find my localdb version?
what is isolation level at dead lock?
How can we use ConnectorJ JDBC Driver with MS SQL?
Explain the use of containers in ssis and also their types?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What number sorts of privileges are accessible in sql?
Explain the difference between HTTP and HTTPS in database?
Can we use having clause without group by?
What are different types of join?
How to link tables in sql server?
what is dbcc? : Sql server database administration
How to access the deleted record of an event?
What is a livelock?