· 6 years ago · Apr 01, 2019, 03:32 AM
1IF NOT EXISTS (
2 select * from sysobjects where name='ref_SalesPerson' and xtype='U'
3) CREATE TABLE ref_SalesPerson (
4 [SalesPersonId] NVARCHAR(5),
5 [SalesPersonName] NVARCHAR(8),
6 [SalesPersonTelp] INT,
7 [SalesPersonFax] NVARCHAR(7)
8);
9INSERT INTO ref_SalesPerson VALUES
10 (N'SP001',N'Andi',823232320812,N'445-661'),
11 (N'SP002',N'Budi',823232320813,N'445-662'),
12 (N'SP003',N'Citra',823232320814,N'445-663'),
13 (N'SP004',N'Dino',823232320815,N'445-664'),
14 (N'SP005',N'Eka',823232320816,N'445-665'),
15 (N'SP006',N'Fitri',823232320817,N'445-666'),
16 (N'SP007',N'Ghani',823232320818,N'445-667'),
17 (N'SP008',N'Heru',823232320819,N'445-668'),
18 (N'SP009',N'Indah',823232320820,N'445-669'),
19 (N'SP010',N'Kristine',823232320821,N'445-670'),
20 (N'SP011',N'Juna',823232320822,N'445-671'),
21 (N'SP012',N'Luna',823232320823,N'445-672'),
22 (N'SP013',N'Miftahul',823232320824,N'445-673'),
23 (N'SP014',N'Nia',823232320825,N'445-674'),
24 (N'SP015',N'Ozi',823232320826,N'445-675'),
25 (N'SP016',N'Rendi',823232320827,N'445-676'),
26 (N'SP017',N'Siska',823232320828,N'445-677');