Differences between functions and stored procedures?
Answer Posted / manoj pandey
Check following blog post for difference between UDF & Stored Procedures: http://sqlwithmanoj.wordpress.com/2011/09/21/stored-procedures-vs-functions-difference-between-sp-udf/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to connect to SQL Azure Database by using sqlcmd?
Does an index slow down updates on indexed columns?
What is page-level compression?
Explain the benefits of user-defined functions?
Where are SQL server users names and passwords are stored in sql server?
Define outer join?
How many types of schemas are there?
What are clustered and non-clustered index?
What are “lost updates”?
How do I view a stored procedure in sql server query?
Explain microsoft sql server functions?
What is difference between oltp and olap?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is difference between commit and rollback when used in transactions?
Explain the rules for designing files and file groups in sql server?