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
- 112954 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
What is save transaction and save point?
Explain what is meant by replication of database?
what is the difference between delete table and truncate table commands? : Sql server database administration
What are key constraints?
What happens to a trigger with multiple affected rows?
How to execute function in stored procedure sql server?
How to send email from database?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is a non-clustered index?
What is snapshot parameter in ssrs?
How to add a new dsn with the odbc driver for sql server?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Distinguish between commit and rollback?
How to delete a login name in ms sql server?
