O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Conditions

When you define a WHERE clause for a DML statement, you restrict the set of rows being operated upon. Put in different terms, you set a condition for the DML statement that defines the set of rows that meet your specific inclusion criteria. Within the Policy-Based Management framework, conditions are the equivalent of a WHERE clause that defines the criteria needing to be checked.

Facets define the object to be checked and the properties of a facet are used by conditions to define the rules that you want to enforce. Just like a WHERE clause, a condition can be defined by one or more facet properties and a single facet property can be checked for multiple criteria. The comparison operators that can be used are restricted by the data type ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required