Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE USERS (
- ID INT IDENTITY (1,1) PRIMARY KEY NOT NULL ,
- USERNAME VARCHAR(50) NOT NULL ,
- PASSWORD VARCHAR(50) NOT NULL
- );
- INSERT INTO USERS(USERNAME, PASSWORD)
- VALUES
- ('haipb', 'haipb'),
- ('kietpp', 'kietpp')
- CREATE TABLE EMPLOYEES (
- ID INT IDENTITY (1,1) PRIMARY KEY NOT NULL ,
- FULLNAME NVARCHAR(50) NOT NULL ,
- ADDRESS NVARCHAR(50) NOT NULL ,
- EMAIL VARCHAR(50) NOT NULL ,
- PHONE VARCHAR(11) NOT NULL,
- SALARY MONEY NOT NULL
- );
- INSERT INTO EMPLOYEES(FULLNAME, ADDRESS, EMAIL, PHONE, SALARY)
- VALUES
- (N'Phan Bá Hải', 'TP.HCM', 'haipb@gmail.com', '0983748372', '7000000'),
- (N'Phan Phú Kiệt', 'TP.HCM', 'kietpp@gmail.com', '0986758493', '7000000'),
- (N'Trần Anh Kiệt', 'Bình Dương', 'kietta@gmail.com', '0968746352', '6500000'),
- (N'Trương Huy', 'Long An', 'huyt@gmail.com', '0973748574', '6500000'),
- (N'Phùng Văn Na Rích', 'Tây Ninh', 'richpvn@gmail.com', '0933847584', '6500000')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement