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
- 113699 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
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 msdb database? : SQL Server Architecture
How to use transact-sql statements to access the database engine?
How to convert binary strings into integers in ms sql server?
What does this statement do @@rowcount?
How do I create a partition table in sql server?
What do you understand by a view?
What is sql view?
What is the recursive stored procedure in sql server?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Can we use having clause without group by?
How do I start and stop sql server?
What is difference between getdate and sysdatetime in sql server 2008?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Differentiate between mongodb vs. Sql server?
When we should use @@error?
