Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
You want to disable the existing trigger named Sales.Order_Count that applies to the Sales table. You might need to re-enable this trigger in the future.
Which of the following Transact-SQL statements can you use to accomplish this goal?
on 11/30/2012 | Category:
Sql Server Interview questions
| Views: 3345 |
Select from following answers:
DISABLE TRIGGER Sales.Order_Count ON Sales
ALTER TRIGGER Sales.Order_Count ON Sales
ENABLE TRIGGER Sales.Order_Count ON Sales
This statement used to disable the trigger that applies to the Sales table.
You should not use the ENABLE TRIGGER statement. This statement enables the trigger rather than disabling it.
ALTER TRIGGER statement modifies the trigger, but it cannot be used to disable the trigger.
Show Correct Answer
Measureup.com | |
< Previous :
Write a SQL Query to find the second maximum salar ...
Next > :
You are developing some Transact-SQL code. You wan ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
You are developing some Transact-SQL code. You want to ensure that you ...
You want to generate a list of integers that includes the integer rais ...
Your subordinate created a view named dbo.vSalesAustralia that was sup ...
You are creating a trigger that will report the number of rows in the ...
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 ...
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?