Difference between Function and Procedure-in general?
Answer Posted / arif
function can not have update,delete or insert statement but
Stored procedure can have
| Is This Answer Correct ? | 15 Yes | 9 No |
Post New Answer View All Answers
How do I clean up sql server transaction log?
What is a user-defined function in the sql server and what is its advantage?
What is row_number function?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is sql injection and why is it a problem? : sql server security
Can we perform backup restore operation on tempdb? : sql server database administration
In what sequence sql statement is processed?
How to create a stored procedure with a statement block in ms sql server?
what is the difference between a primary key and a unique key? : Sql server database administration
What is user-defined scalar function?
How to get the definition of a trigger back?
What is the purpose of optimization?
How to make a remote connection in a database?
How can you manage sql azure security?
What are triggers? How do you invoke a trigger on demand?