Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
You are creating a trigger that will report the number of rows in the Inserted table during its operation.
Which of the following statements would you include when defining this trigger to accomplish this goal?
on 11/30/2012 | Category:
Sql Server Interview questions
| Views: 3530 |
Select from following answers:
SELECT COUNT(*) FROM Inserted
SELECT * FROM Inserted
SELECT COUNT(*) FROM Deleted
You can use the SELECT COUNT(*) FROM Inserted statement in a trigger to determine the number of rows that have been inserted.
You should not use the SELECT * FROM Inserted statement. This statement selects all content in the Inserted table, but it does not count the rows. You are interested in the number of rows in the Inserted table.
Show Correct Answer
Microsoft Press book | |
< Previous :
Your subordinate created a view named dbo.vSalesAu ...
Next > :
Which of the following Transact-SQL statements wou ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
Which of the following Transact-SQL statements would you use when crea ...
You want to query the table OrderDetail to generate a list of product ...
You have created a new table named Maintenance in the Hovercraft Renta ...
You want to change the definition of a DML trigger. Which of the fo ...
Which of the following statements would you use to mark the start poin ...
Which of the following mathematical functions would you use to calcula ...
You want to generate a ranked list of pay rates for employees who are ...
There are several very large tables in the Hovercraft database. You wa ...
Latest Interview Questions
You have a Transaction table which is very important table because it ...
Write a C# sharp Program to check wheather the given string is Palindr ...
Which namespace will you use to get the value of connection string def ...
Write a C# program that prints the Prime numbers between 1 and 100 and ...
There is a PDF file which contains "GuideLines" in particul ...
Write a program in C# using Linq that prints count of leap years in 20 ...
Explain how do you differentiate between design pattern and framework ...
What is a design Pattern?