What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 107453 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / jitendra
>Procedure may return none or more values.
->Function must always return one value either a scalar value or a table.
>Procedure allow modular programming.
>Function can be used in a select statement where as procedure can't.
>procedure can input and output parameter but Function takes only input parameter.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define indexes?
What are sp_configure commands and set commands?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is it unwise to create wide clustered index keys?
What is join query?
What are the different index configurations a table can have?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
How to divide query output into multiple groups with the group by clause in ms sql server?
How many databases can we create in a single server?
What is hot add cpu in sql server 2008?
How to set the current database in ms sql server?
How to insert stored procedure result into temporary table?
What are the export options of ssrs?
explain how to create a new schema in a database? : Sql server database administration
How do you rebuild an identity column?
