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
- 112786 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
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What is transaction server explicit transaction?
What are the purposes of floor and sign functions?
What are the types of joins in sql?
How to move database physical files in ms sql server?
How can we determine what objects a user-defined function depends upon?
What is sparse columns of sql server 2008?
How do triggers work?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
Can you name some of the dml commands in sql?
What is the difference between varchar and varchar types?
Differentiate between ms sql server reporting services vs crystal reports?
How data can be copied from one table to another table?
Can sub report data source be different from that of the parent report?
What is buffer cash and log cache in sql server?
