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
- 112791 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
List the different types of joins?
How to drop an existing stored procedure in ms sql server?
How to create hyperlink from returned sql query ?
What are partitioned views and distributed partitioned views?
What are the types of resultset?
Explain a differential backup?
What are the properties of sub-query?
How to backup SQL Server Reporting Services ?
Why do you want to join software field as you have done your BE in Electronics?
Which are the third-party tools used in sql server and why would you use them?
How to retrieve error messages using mssql_get_last_message()?
If we delete pack Spec what will be the status of pack Body ?
Do you know what is openxml in sql server?
How to execute function in stored procedure sql server?
Explain about extended stored procedure?
