Differences between functions and stored procedures?
Answer Posted / santhoshkumar.k
store procedure takes less time to execute the statement
than functions, also we can create loops inside the store
procedure.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
is there a column to which a default can't be bound? : Sql server database administration
What is ssl in sql server?
What is tablix?
How do you make a trace?
What is DCL?
Explain the difference between function and stored procedure?
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 a db view?
What is similarity and difference between truncate and delete in sql?
Does partitioning ssd reduce performance?
What is open database communication (odbc)?
Tell me what is use of except clause? How it differs from not in clause?
What is an execution plan? When would you use it?
Explain full-text query in sql server?
List the different types of collation sensitivities in sql server?