Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 112165 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
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 do I install only the client tools of sql server 2000?
State the difference between union and union all?
How do I run sql server 2014?
Define primary key?
What is a scheduled job or what is a scheduled task?
What is an inner join?
What is a user-defined function in the sql server and what is its advantage?
What are the common performance issues in sql server?
Does table partitioning improve performance?
Can a table have 2 primary keys?
What is side by side migration in sql server?
How to insert multiple rows with a subquery?
How can you find out how many rows returned in a cursor?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
How to find the version of sql server? : sql server database administration
