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
Can you explain different types of locks in sql server?
What is clustered vs nonclustered index?
When a primary key constraint is included in a table, what other constraints does this imply?
What is the difference between TRUNCATE and DROP?
How many tables can be joined in SQL Server?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
How to create a large table with random data for index testing in ms sql server?
Explain raiserror in sql server?
How to scale out a federation by Sql statement?
What is the purpose of forms?
What is the use of builtinadministrators group in sql server? : sql server security
How will you add a dimension to cube? : sql server analysis services, ssas
What are the differences between web role and worker role?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What is repeatable read?