declare @website varchar(30)
declare @nokta int
declare @domainuzunluk int
declare @site varchar(30)
declare @uzanti varchar(10)

set @website='example.com'


set @nokta= (SELECT CHARINDEX ('.',@website,0))
set @domainuzunluk= (Select LEN (@website))

set @site= (select LEFT(@website,@nokta-1))
set @uzanti= (select RIGHT(@website,@domainuzunluk-@nokta))

select @site as 'site', @uzanti as 'uzanti'