|
---- Define the rule for use in the database
CREATE RULE dbo.positive_value22
AS
@value >= 0
GO
---- Bind the rule to a specific column in a table
EXEC sp_bindrule
'dbo.positive_value',
'myTable.myColumn'
GO
---- to Unbind the rule from the column
EXEC sp_unbindrule
'myTable.myColumn'
GO
|