HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

What do these statements mean in the MS β exam 70-461 "skills measured" list?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
skillsthesethewhatstatementsmeanexam461measuredlist

Problem

I have registered for the upcoming beta exam 70-461 entitled Querying Microsoft SQL Server 2012.

I've been reading through the exam overview and found a bunch of descriptions I'm not exactly sure what some of the items mean:

  • Create and alter DML triggers.



  • This objective may include but is not limited to: inserted and deleted tables; nested triggers; types of triggers; update functions; handle multiple rows in a session; performance implications of triggers



  • Query data by using SELECT statements.



  • This objective may include but is not limited to: use the ranking


function to select top(X) rows for multiple categories in a single
query; write and perform queries efficiently using the new code items
such as synonyms and joins (except, intersect); implement logic which
uses dynamic SQL and system metadata; write efficient, technically
complex SQL queries, including all types of joins versus the use of
derived tables; determine what code may or may not execute based on
the tables provided; given a table with constraints, determine which
statement set would load a table; use and understand different data
access technologies; CASE versus ISNULL versus COALESCE

The problem here I think is with the wording, which I think I'm not able to fully understand.

If someone could clarify these I'd be most grateful.

To put it as an actual question:

What is Microsoft talking about on the above highlighted statements?

Solution


  • DML - refers to data manipulation (update, insert, delete). A DML trigger is a trigger created to happen on update, insert or delete of table data.



The update function is the part of a DML trigger where you test if a required update has occured.

For Example:

CREATE TRIGGER myupdate_trigger
ON mytable
FOR UPDATE AS
if UPDATE(column_1)
BEGIN
-- Do something
END


This will trigger a further action every time column column_1 is updated in table mytable. The update function is UPDATE(column_1).

Code Snippets

CREATE TRIGGER myupdate_trigger
ON mytable
FOR UPDATE AS
if UPDATE(column_1)
BEGIN
-- Do something
END

Context

StackExchange Database Administrators Q#15887, answer score: 4

Revisions (0)

No revisions yet.