What are the differences between stored procedure and
functions in SQL Server 2000?

Answer Posted / pss

Function return only one value where as procedure can more
than

Is This Answer Correct ?    58 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is report snapshot in ssrs?

166


Where in ms sql server is ’100’ equal to ‘0’?

602


What is the difference between a function and a stored procedure?

568


Can we shrink data file in sql server?

539


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

1722






What are the new features of sql server 2008 r2 reporting service?

110


What is the impact on other user sessions when creating indexes?

544


How to recover from sql injection? : sql server security

522


application server is slow what may be the problem

1784


How to encrypt data between dialogs?

574


Explain the database you used in your final year project?

538


Why do you need a sql server?

510


What is thr feature of change data capture?

510


Explain what are partitioned views and distributed partitioned views?

584


What do I need to start working with sql studio? : sql server management studio

596