What are the differences between stored procedure and
functions in SQL Server 2000?
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
Can we call stored procedure in trigger?
What is the usage of the sign function?
What is the report builder?
Explain how to use linked server?
how can u get last observation in an unknown dataset ?
How to read data in a table with "select" statements?
What is the data type of time?
Which joins are sql server default?
What is a recursive stored procedure in sql server?
What is difference between sql and sql server?
What is the command dbcc checkdb used for?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Can you explain the disadvantages/limitation of the cursor?
How to download and install sql server 2005 books online?
What command would you use to add a column to a table in sql server?