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
- 112139 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 the difference between grant and with grant while giving permissions to the user?
What is analysis service repository?
How to find out what is the default collation in a database?
What are drilldown reports?
What is recompile sql server?
How can we migrate from SQL server to SQL Azure?
How except clause is differs from not in clause?
What are the steps you must follow to hide sql server instances?
What are the types of user defined functions in sql server?
explain different types of backups avaialabe in sql server? : Sql server database administration
How to recompile stored procedure at run time?
define and explain the differences between clustered and non-clustered indexes.
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Which are the important points to note when multilanguage data is stored in a table?
What is your recommendation for a query running very slow? : sql server database administration
