Interested to Buy Any Domain ? << Click Here >> for more details...
when inserting to a table how many rows will be effected
using triggers
- 2 Answers
- 4995 Views
- I also Faced
- E-Mail Answers
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 sqlservr.exe - process - sql server (sqlex?press)?
What are scheduled tasks in sql server?
How to execute a sql statement using odbc_exec()?
Explain “@@rowcount” and “@@error” in sql server?
What is b tree index?
What are the type of joins? When do we use Outer and Self joins?
What is scrollable cursor?
How to download and install microsoft sql server management studio express?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Explain how to integrate the ssrs reports in application?
Explain what are the authentication modes in sql server?
How many full-text indexes can a table have?
-
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)
