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
- 112955 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 does COMMIT command do?
How to get the definition of a user defined function back?
Define tool Manage Statistics in SQL Server 2000 query ?
How can we get count of the number of records in a table?
What is sql server agent and what are the two modes of authentication in sql server?
What is raid and what are different types of raid levels?
What is optimization and its types?
What function does a database engine serve in the sql server?
Give an example of SQL injection attack ?
How many null values we can have in a unique key field in sql server?
What is the size of transaction log file?
What is application role in sql server database security? : sql server security
How to recreate an existing index in ms sql server?
Why I can not enter 0.001 second in date and time literals in ms sql server?
Do you have any idea about the tcl commands?
