create table Contacts (
FirstName nvarchar(30),
LastName nvarchar(30),
EmailAddress nvarchar(30) CHECK
(dbo.RegExMatch('[a-zA-Z0-9_\-]+@([a-zA-Z0-9_\-]+\.)
+(com|org|edu|nz)',
EmailAddress)=1),
USPhoneNo nvarchar(30) CHECK
(dbo.RegExMatch('\([1-9][0-9][0-9]\) [0-9][0-9][0-9]
\-[0-9][0-9][0-9][0-9]',
UsPhoneNo)=1))
INSERT INTO [talend].[dbo].[Contacts]
([FirstName]
, [LastName]
, [EmailAddress]
, [USPhoneNo])
VALUES
('Hallam'
, 'Amine'
, 'mhallam@talend.com'
, '0129-2090-1092')
, ( 'encoremoi'
, 'nimportequoi'
, 'amine@zichji.org'
, '(122) 190-9090')
GO