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
What is raid? : SQL Server Architecture
What are the commands used in DCL?
How many null values we can have in a unique key field in sql server?
how you can move data or databases between servers and databases in sql server? : Sql server administration
Explain comment on transactions?
What is join query?
What is deploy, process and build? : sql server analysis services, ssas
What are the advantages of using cte?
What is instead of dml trigger?
What are filegroups in sql server?
What is the use of tempdb? What values does it hold?
How to update values in a table with update statements in ms sql server?
Comment,Datatypes are unlimited
After removing a table from database, what other related objects have to be dropped explicitly?
What is server-level principal?