Which virtual table does a trigger use?
Answers were Sorted based on User's Feedback
Answer / bharathi
Answer is deleted and inserted
INSERT Trigger populates inserted table
DELETE Trigger populates deleted table
UPDATE Trigger poulates both inserted and deleted tables
| Is This Answer Correct ? | 11 Yes | 0 No |
Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?
wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......
Write a sql query to get zero records from a table having n number of records?
mention different types of relationships in the dbms?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is named query? : sql server analysis services, ssas
what stored procedure would you use to view lock information? : Sql server administration
What are different types of collation sensitivity?
How many types of TRIGGERS are there in MS SQL Server?
8 Answers CarrizalSoft Technologies, TCS, United Healthcare,
What methods do you follow to protect from sql injection attack?
How to use “drop” keyword in sql server and give an example?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)