What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / bhupi
SP return a single result-set,
SP works with table variables,
SP uses EXEC stmts
Is This Answer Correct ? | 28 Yes | 12 No |
Post New Answer View All Answers
What is temporal table?
What is the usage of the sign function?
Tell me what is log shipping?
Different types of keys in SQL?
List the different types of joins?
is there a column to which a default can't be bound? : Sql server database administration
How to Check if table exists in sql server?
How to fine-tune reports?
What is SQL Server?
What is an etl file?
Mention the uses of stored procedures.
How to call a function from a stored procedure in SQL Server ?
Explain different forms of normalization?
What are triggers? How do you invoke a trigger on demand?
Does partitioning improve performance?