Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sarakumar
Posting Yak Master
108 Posts |
 Posted - 2006-08-21 : 05:22:13
|
| Hai, i havent used triggers yet. but in one of the interview i was asked what is row based trigger and what is statment based trigger.can someone clarify me.Thanks. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-21 : 05:25:15
|
| Where they talking about SQL Server 2005?Then you have both DDL triggers (which fires if a change of the DDL/Table layout is done) or normal trigger (row-based) that fires when a change to the present data is made.If you are using SQL Server 2000 or previous, then you only got the normal trigger.Peter LarssonHelsingborg, Sweden |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-21 : 06:09:26
|
| I think they mean a trigger that only copes with single rows (row based) and one that copes with multiple rows (statement based).If they were talking about sql server it is probably a company you should stay away from unless you are controlling development.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Doubt in Triggers