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
- 112810 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 types of normalization?
How to backup SQL Server Reporting Services ?
Explain the relational database management system (rdbms)?
What is a sql join?
What is the process of normalising?
How to create a dml trigger using create trigger statements?
Explain cross join or cartesian product in sql?
Disadvantages of the indexes?
Will the writetext statement activate a trigger?
Explain what are partitioned views and distributed partitioned views?
what is isolation level at dead lock?
What are the two modes of authentication in sql server?
What is an indexed view?
Can you explain various data region available in ssrs with their use?
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
