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 happens when converting big values to integers?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What do you mean by a Composite primary key?
What is database mirroring?
What are the different types of normalization?
How do I get to sql server configuration manager?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Explain full-text indexing?
How to delete the duplicate rows from a table in SQL Server ??
What are character string data types in ms sql server?
Explain about local stored procedure?
What is de-normalization in sql database administration? Give examples?