What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / vampire007
1. Functions can be used inline with a select statement
while sprocs can't.
2. EXEC command can't be used inside a Function where it
can be used inside an sproc.
Is This Answer Correct ? | 75 Yes | 23 No |
Post New Answer View All Answers
What is a trigger what are the advantages of trigger?
how many type of indexing in database?
What is the cartesian product of table?
What is a unique key constraint?
How to delete all rows with truncate table statement in ms sql server?
What are the advantages of using cte?
How do you debug a procedure in sql server?
What is the difference between DATETIME2 and DATETIME?
Would you store your query in a ssrs report or a database server? State the reason why?
How do you set a trace flag in sql server?
How to update multiple rows with one update statement in ms sql server?
How to join two tables in a single query in ms sql server?
What is the difference between upgrade and migration in sql server?
What is an expensive query?
How many categories of functions based their return modes?