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
- 113668 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
List few advantages of stored procedure.
How to list all tables in the database using odbc_tables()?
Explain about protocol layer present in SQL server?
How to select all columns of all rows from a table with a select statement in ms sql server?
What is difference between view and materialized view?
How would you go about developing a ssrs report?
If a table does not have a unique index, can a cursor be opened on it?
What is a DBMS, query, SQL?
How to Update from select query in sql server?
Explain the truncate command? : SQL Server Architecture
What sql server means?
Why Master database is required?
What is analysis service repository?
Can the “if update (colname)” statement be used in a delete trigger?
What are different replication agents and what's their purpose? : sql server replication
