Hello Friends,
Can you tell me if I can make a rule as follow or not :
CREATE RULE rul_name AS
@date1 <= GETDATE();
Will it work???

Gaurav

__________________
Gaurav

Yes. You can
See below:

CREATE RULE rul_name AS
@date1 <= 10
go
CREATE TABLE [t2] (c1 int)
go
sp_bindrule rul_name, '[t2].c1'
go
INSERT INTO [t2] select 10
INSERT INTO [t2] select 12

It will work.

Note that the CREATE RULE statement is deprecated, and CHECK CONSTRAINT should be used instead.

I did find that while trying to execute the CREATE RULE statement in QA, that it did not like the trailing ";", despite the fact that BOL indicates that the terminator is optional. Strange.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

But the thing that I want to do cannot be checked by a CHECK constraint. I want to ckeck whether the entered date in a table is <= today's date. I have two options : RULE and TRIGGER. Now can you tell me which one is better to use(Which is faster and which one should prefer to use).

Gaurav

Why do you think you cannot construct a CHECK CONSTRAINT on a table column using GetDate()?
will create such a constraint.

I doubt there is any performance difference between a RULE and a CONSTRAINT. There is nothing preventing you from using a RULE, it's just that the CONSTRAINT syntax is SQL Standard and the RULE is not.



Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thank you again. I will use CHECK for it.
Please tell me that among trigger and rule, which is faster and which is better performance-wise.

Gaurav Jain.