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
How do I find the default sql server instance?
What are the two modes of authentication in sql server?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is the syntax to execute the sys.dm_db_missing_index_details?
How to encrypt data between dialogs?
How to define and use table alias names in ms sql server?
Characterize join and name diverse sorts of joins?
Why union all is faster than union?
How to list all login names on the ms sql server?
What are page splits?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Can you explain about buffer cash and log cache in sql server?
Define candidate key, alternate key, and composite key.
Explain contrast amongst grouped and non-bunched records?
How many types of attribute relationships are there? : sql server analysis services, ssas