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
- 112941 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / sanjeev bhardwaj
Function:
Function must have a return type.
Function output can be set to the DMLstatement.
User Defined Functions (UDFs) can run an executable file
from SQL SELECT or an action query
Stored Procedure:
Stored Procedure may or may not have a return type.
Stored Procedure output can not st to any DML Statement.
Stored Procedure can run uder Execute command
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the use of RDBMS?
What is ms sql server service broker?
What is query processing?
What is a result set object returned by odbc_exec()?
What is a Join and explain its types?
Create and insert into temp table in sql server?
What is the difference between NOROW and LOCKROW?
What is log cache in sql server?
Delete duplicate rows without using rowid.
What is attribute relationships, why we need it? : sql server analysis services, ssas
What is the default server name for sql server?
How would you use user_constraints table in DB?
What objects does the fn_my_permissions function reports on? : sql server security
How to how to convert numeric expression data types using the convert() function??
How can you insert null values in a column while inserting the data?
