Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sanjay kumar dinda
Trigger is a procedure which is invoked automatically when
any DML operation occured on a table.
At the time of DML operation , inside trigger SQL provide
the dummy table ( inderted , deleted) , which stores the
errected rows....
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you understand by integration services in sql server?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
what is database replication? : Sql server database administration
Does index slows down insert statements?
What is difference between equi join and inner join?
How to write a query with an inner join in ms sql server?
How to provide default values to stored procedure parameters?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is the sql case statement used for? Explain with an example?
What is msdb database? : SQL Server Architecture
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What are the advantages of sql azure?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
