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
- 113016 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 ems sql management studio? : sql server management studio
What is left outer join in sql server joins?
How to truncate the log in sql server 2012? : sql server database administration
Explain microsoft sql server functions?
How you can find out if an index is useful to the optimizer?
Define outer join?
How do I view a stored procedure in sql server?
What are sql servers used for?
Tell me what are cursors and when they are useful?
What is Dependency Injection and provide example?
what's the information that can be stored inside a bit column? : Sql server database administration
Difference between primary key and clustered index?
What are the types of containers in ssis?
Explain raiserror in sql server?
What is data set in report?
