What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 106176 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 "scheduled jobs" or "scheduled tasks"?
How to filter out duplications in the returning rows in ms sql server?
What is the command used to check locks in microsoft sql server?
What is default port number for sql server 2000?
Can we use having clause without group by?
What do you mean by acid?
What is the Disadvantage of indexed sequential file.
Tell me what do you understand by a view? What does the with check option clause for a view do?
How to create prepared statements using odbc_prepare()?
What is BCNF? How is it better than 2NF & 3NF?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is a fill factor?
Write a SQL query to make a column as unique?
Mention a few common trace flags used with sql server?
What is equi join with example?
