Hi,
I seem unable to create a check constraint that tires to perform an EXISTS against a subquery.
It seems MS SQL doesn't allow sub-queries in check constraints.
I have seen a few threads that say the way round this it to create s UDF and use that in the check constraint.
Is this the only way?
Thanks,
1DMF
"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."
"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music
I seem unable to create a check constraint that tires to perform an EXISTS against a subquery.
It seems MS SQL doesn't allow sub-queries in check constraints.
I have seen a few threads that say the way round this it to create s UDF and use that in the check constraint.
Is this the only way?
Thanks,
1DMF
"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."
"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music
