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
How to display a past time in days, hours and minutes?
Would you store your query in a ssrs report or a database server? State the reason why?
Explain having clause?
How to find index size for each index on table?
What is raiseerror? What is raiseerror?
What are recommended options to be used while using db mirroring? : sql server database administration
What is scheduled job and how to create it?
Do I need a report server to run reports in my application?
What is the use of sign function?
What happens if we shrink log file in sql server?
What is single-user mode?
What are the main sources of data?
What are rows and columns?
Will count(column) include columns with null values in its count?
What is sql profiler. What are the default templates with it? : sql server database administration