Using SQL Server Validate Email ID OR Email Address

Different kind of input validation at SQL server level:

Check For Valid Email Id in SQL Server:

Declare @Email NVARCHAR(MAX) = 'yogesh.upreti14@yahoo.co.in'
IF @Email LIKE '%_@__%.__%' AND PATINDEX('%[^a-z,0-9,@,.,_,\-]%', @Email) = 0
BEGIN
----- Execute you Data manipulation operation here.
END