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 data source object?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What is sql or structured query language?
How use inner join in sql server?
How to include date and time values in sql statements?
What is built-in function?
How can we rewrite sub-queries into simple select statements or with joins?
What are the different types of indexes?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
Explain can you implement data mining in ssrs?
How can you start sql server in different modes?
what is a sub-report?
Explain the difference between delete,drop and truncate in SQL Server?
How do I start sql server 2017?
What is isolation levels?