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 are the advantages of using stored procedures in sql server?
What is rtm version in sql server?
Define primary key?
How do I find the sql server version?
Why use view instead of a table?
What is temporary table in sql server? Why we use temp table?
What is the stuff and how does it differ from the replace function?
What is usually the first word in a sql query?
Explain the database you used in your final year project?
Describe the functionalities that views support.
What are the differences between ms sql server & oracle?
How to set database to be read_only in ms sql server?
What are the requirements on sql server network connections?
What is t-sql script to take database offline – take database online.
What is a virtual table in sql?