/* -- USer defined data type 3 step : 1- USER DATA TYPE oluştur, 2- eğer default olacak ise DEFAULT oluştur, 3- RULE OLUŞTUR 4- Sonra DEFAULT BIND BIND et 5- Sonra RULE BIND et */ -- 1- TYPE DROP TYPE [dbo].[Phone] GO CREATE TYPE [dbo].[Phone] FROM [nvarchar](17) NULL GO -- 2- DEFAULT DROP DEFAULT [dbo].[Default_Phone] GO CREATE DEFAULT Default_Phone AS 'UnknownNumber' GO -- 3- RULE DROP RULE [dbo].[rule_Phone] GO CREATE RULE rule_Phone AS (@phone='UnknownNumber') OR (LEN(@phone)=17 AND SUBSTRING(@phone,1,1)='+' AND SUBSTRING(@phone,4,1)='-' AND SUBSTRING(@phone,8,1)='-' AND SUBSTRING(@phone,12,1)='-' AND SUBSTRING(@phone,15,1)='-') GO -- 4- BIND DEFAULT EXEC sp_bindefault 'Default_Phone', 'Phone' GO -- 5- BIND RULE EXEC sp_bindrule 'rule_Phone','Phone' CREATE TABLE Phone ( PhoneID INT PRIMARY KEY IDENTITY, CellPhone Phone, HomePhone Phone, WorkPhone Phone ) GO INSERT INTO Phone VALUES('+90-533-646-12-04',NULL,NULL) INSERT INTO Phone VALUES('+90-543-854-15-60',NULL,NULL) INSERT INTO Phone VALUES('+90-212-661-12-04',NULL,NULL) INSERT INTO Phone VALUES('+90-532-247-40-80',NULL,NULL) INSERT INTO Phone VALUES('+90-551-455-21-21',NULL,NULL) GO
