Answers were Sorted based on User's Feedback
Answer / koti-khammam
Trigger is a special type of stored procedure that will
fire automatically when ever data modifications like
INSERTIONS,UPDATIONS or DELETIONS occurs on the table.
|Is This Answer Correct ?||11 Yes||0 No|
Answer / kaushik chatterjee
A trigger is some what simillar to stored procedure. It is
written to perform a set of predefined actions when a
perticular database objecy such as tables,views are
Triggers are implicitly called and are NOT instactiated by
the user. Once written, it will be called automatically by
the DBMS engine when a UPDATE/DELETE/INSERT operation is
performed on the database object for which the trigger is
intended or written.
Triggers can be written for any one of the 3 operations
written above or all of them.
|Is This Answer Correct ?||6 Yes||0 No|
Answer / pawan378
above answers are correct.
let me add some thing.
(Pre - Trigger) is a dynamic Rule that should be done before
Data modification Happens.
(Post - Trigger) is a Consequent step that should be taken
as soon as the Data Happens.
|Is This Answer Correct ?||5 Yes||0 No|
how can u select the Distinct values in the table, table having 20 columns , i want all columns
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?
Wht is Stuff in sql ser
What is difference beteen Migration and Upgrdation?
Without Using Cursors , How to Select the Selected row??
What is the difference between SSAS 2000 and SSAS 2005?
Can we passed multiple recordset(set of records) using a Stored Procedure
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h
internal language used in sql server 2000?
How to list all tables having unique constraints in any of the columns in a database.
Is index a datbase objects in sql server?