when inserting to a table how many rows will be effected
using triggers
Answers were Sorted based on User's Feedback
Answer / sharjeel
All Rows Check and effects.
When ever condition must true/false then it breaks and show
the result
| Is This Answer Correct ? | 2 Yes | 1 No |
Before commit in the database,data will get store in the
INSERTED table in trigger. From the table we can come to
know how many records are affected in the table.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the difference between a Local temporary table and a Global temporary table? How is each one used?
How network traffic be reduced by using the stored procedure?
How many primary keys are possible in a table?
How can we check the sql server version?
How many partitions a clustered index has by default in sql server 2012?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Define model database?
What is 2nf example?
Explain indexed views?
Explain what are the basic functions for master, msdb, model, tempdb databases?
Tell me what is the stuff and how does it differ from the replace function?
Explain encryption of entire databases without the need for application changes in sql server 2008?
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)