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
- 113666 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
Explain about SQL server 2005?
If we delete pack Spec what will be the status of pack Body ?
Which are the olap features?
How do you debug a procedure in sql server?
What is bookmark link in ssrs?
How many types of the database links?
Explain table valued parameters in sql server? Why tvp used?
Can sub report data source be different from that of the parent report?
What is the command dbcc checkdb used for?
What is spatial and temporal data?
Tell me what is difference between clustered and non clustered index?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Which tools are available to manage SQL Azure databases and servers?
How to create a store procedure with encryption?
What are pages and extents? : SQL Server Architecture
