I use the following code to make a rule and use it for my PHONE column:
CREATE RULE phone_rule AS
@phone LIKE '([0-9][0-9][0-9]) [0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]'The problem is :
When I run this code nothing add to my "Data Type" drop down box to set my PHONE column data type to my created rule (phone_rule).
What is the solution?
I don't know too much about Rule Objects but did you run
sp_bindrule to bind the rule to the your coluum.
Yeah I did it, but I got this error:
The data type or table column 'teacher.phone' does not exist or you do not have permission.
And of course the columns exists and I set the appropriate permission to it.
Im sure you are just missing something in the syntax,
unfortunately I have never used this object and since it is being deprecated by Micorsoft in future releases I doubt I ever will.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.