What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 106177 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / sathishraj
*The DML statements INSERT, UPDATE, and DELETE cannot be
used on base tables
*SQL functions that return non-deterministic values are not
allowed to be called from inside User Defined Functions.
GETDATE is an example of a non-deterministic function.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use linked server?
What is the optimization being performed in oracle and SQL Server?
What is the difference between for trigger and after trigger?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What are the built in functions in sql server?
How to retrieve error messages using mssql_get_last_message()?
What is data modeling and Reterminal integrity?
Explain the purpose of indexes?
How to display a past time in days, hours and minutes?
What is field with example?
Tell me what do we need queues in sql service broker?
What is the difference between migration and upgradation in sql server?
When you use @@error and try-catch?
What are the differences between local and global temporary tables?
How to create indexed view?
