Answer / ramesh tankala

Trigeer is like stored procedure which executes
automatically .

Trigger is User defined data integrity

Answer / piyush

Triggers are those procedures written in PL/SQL that fire whenever one of the following operation occur, DML statements on a particular schema object, DDL statements issued within a schema or database, user log on or log off events, server errors, database startup, or instance shutdown.

Answer / indu bala

trigger is any event which is raised automatically by
database server after any instruction like
update,delete,insert is performed

Answer / kalyana chakravarthy maddipati

A trigger is a stored procedure fires implicitly when ever a DML(Insert, update & Delete) occurs. It is stored at server side. Its compiled and no need to compile and execute always.

Answer / ramya

Trigger is a server-side progrm used for events(user
actions-click,key press etc..)

Answer / guest

its an willow

Answer / abdulla

Trigger is Limited form stored procedure associated with tables.

What is de-normalization in sql database administration? Give examples?

0 Answers  

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

Why do we partition data?

0 Answers  

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

How to return the second 5 rows in ms sql server?

0 Answers  

Can we move Resource database from one path to another? If yes,How can we?

1 Answers   Wipro,

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

Explain how many types of relationship?

0 Answers  

Explain system scalar functions?

0 Answers  

what is the query and condition to delete datas in sql server.

2 Answers  

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,

Are semicolons required at the end of sql statements in sql server 2005?

0 Answers