You can check the code below:
ALTER TABLE your_table
ADD CONSTRAINT chk_email CHECK(CHARINDEX('@', YourEmailColumn) > 0 OR YourEmailColumnIS NULL)
--OR you can use this one
ALTER TABLE your_table
ADD CONSTRAINT chk_email CHECK(YourEmailColumn LIKE '%_@__%.__%')
