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
- 111996 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / chandu
17) Difference between stored procedure and functions?
Stored Procedures
I) Stored procedure takes input and output parameters.
II) Stored procedure contain all DML operations with
permanent table
III) Return statement can return single numeric value.
Functions:
I) functions takes only input parameters
II) function contains only select statement to perform
operation with permanent table
III) It returns single value or set of rows.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What are the properties of primary key?
What is difference between materialized view and view?
Name few of the dcl commands in sql?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What is collation sensitivity?
How to round a numeric value to a specific precision?
What is cte (common table expression)?
Explain partitioned view?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is the difference between coalesce() & isnull()?
where the connection string store in the database
Mention the 3 ways to get a count of the number of records in a table.
Explain foreign key in sql server?
What is the beast way to write CTE in SQL Server ?
Why would you call update statistics?
