You have to validate an email address using regular expressions and some sophisticated logic, What is the best solution?
A.
Create a user defined function in CLR assembly
B.
Create a stored procedure
C.
Create a trigger
D.
use email datatype
Explanation:
http://msdn.microsoft.com/en-us/library/ms186755.aspxhttp://www.mssqltips.com/tip.asp?tip=1672
http://msdn.microsoft.com/en-us/magazine/cc163473.aspx