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
- 111959 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
Why do we partition data?
What are differences in between sql server 2012 and sql server 2016?
How to generate create view script on an existing view?
do you know how to configure db2 side of the application? : Sql server database administration
What is normalization of database?
How do I start sql server?
Can a rule be bound to any column of any data type?
Where the sql logs gets stored?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Does partitioning improve performance?
How to execute a sql statement using odbc_exec()?
What are the different types of collation sensitivity in sql server?
Do you know the policy based administration feature of sql server 2008?
What is simple indexing method?
What are the differences between triggers and stored procedures?
