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 the security principal at the server level that represents your session?
What is the difference between createstatement and preparedstatement?
What is exporting utility?
How to list all user defined functions in the current database?
What are the differences between substr and charindex in sql server.
optimization techinques
Define master database?
What is a non equi join?
What is the maximum number of index per table?
Can an entity have two primary keys?
Differentiate between delete and truncate.
Do you know the capabilities of cursors?
Explain filtered indexes?
Which command is used for user defined error messages?
What are the steps you will take to improve the performance of a poor performing query?