Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
FIGURA5.2
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' CREATE TABLE [dbo].[Tablacincouno]( [EMP_NUM] [nvarchar](255) Primary Key NOT NULL, [EMP_LNAME] [nvarchar](255) NULL, [EMP_FNAME] [nvarchar](255) NULL, [EMP_INITIAL] [nvarchar](255) NULL, [EMP_LICENSE] [nvarchar](255) NULL, [EMP_RATINGS] [nvarchar](255) NULL, [EMP_MED_TYPE] [nvarchar](255) NULL, [EMP_HIRE_DATE]datetime, ) GO CREATE TABLE [dbo].[DEPENDENT]( [EMP_NUM] [nvarchar](255) Primary Key NOT NULL, [DPNT_NUM] [nvarchar](255) NULL, [DPNT_LNAME] [nvarchar](255) NULL, [DPNT_FNAM] [nvarchar](255) NULL, [DPTN_RELATION] [nvarchar](255) NULL, ) GO CREATE TABLE [dbo].[PILOT]( [EMP_NUM] [nvarchar](255) Primary Key NOT NULL, [PIL_LICENSE] [nvarchar](255) NULL, [PIL_RATINGS] [nvarchar](255) NULL, [PIL_MED_TYPE] [nvarchar](255) NULL ) GO CREATE TABLE [dbo].[MECHANIC]( [EMP_NUM] [nvarchar](255) Primary Key NOT NULL, [MEC_TITLE] [nvarchar](255) NULL, [MEC_CERT] [nvarchar](255) NULL ) GO CREATE TABLE [dbo].[ACOUNTTANT]( [EMP_NUM] [nvarchar](255) Primary Key NOT NULL, [ACT_TITLE] [nvarchar](255) NULL, [ACT_CPA_DATE] [nvarchar](255) NULL ) GO INSERT INTO [dbo].[Tablacincouno] VALUES(100, 'Kolmycz','Xavier','T',' ',' ', ' ', TRY_CONVERT (TIME,'7:40:10.1104000')), (101, 'Lewis','Marcos',' ','ATP', 'SEL/MEL/Instr/CFII',1, TRY_CONVERT (TIME,'12:05:10.4000000')), (102, 'Vandam','Jean','',' ',' ', ' ', TRY_CONVERT (TIME,'12:20:10.0000000')), (103, 'Jones','Victoria','R',' ',' ', ' ', TRY_CONVERT (TIME,'14:22:10.0000000')), (104, 'Lange','Edith',' ','ATP','SEL/MEL/Instr',1, TRY_CONVERT (TIME,'17:35:10.0000000')), (105, 'Wiliams','Gabriel','U','COM','SEL/MEL/Instr/CFI', 2, TRY_CONVERT (TIME,'19:50:10.0000000')), (106, 'Duzak','Mario',' ','COM','SEL/MEL/Instr', 2, TRY_CONVERT (TIME,'20:36:10.0000000')), (107, 'Diante','Venite','L',' ',' ', 2, TRY_CONVERT (TIME,'11:06:10.0000000')), (108, 'Wiesenbach','Joni',' ',' ',' ', ' ', TRY_CONVERT (TIME,'17:05:50.0000000')), (109, 'Travis','Brett','T','COM','SEL/MEL/Instr/CFI',1, TRY_CONVERT (TIME,'12:05:10.0000000')), (110, 'Genkazi','Stan',' ',' ',' ', ' ', TRY_CONVERT (TIME,'10:05:10.0000000')) INSERT INTO [dbo].[DEPENDENT] VALUES (100, 15, 'Kolmycz','Xavier',' '), (101, 23,'Lewis','Marcos', ' '), (102, 04,'Vandam','Jean', ' '), (103, 15,'Jones','Victoria', ' '), (104, 02,'Lange','Edith',' '), (105, 06, 'Wiliams','Gabriel',' '), (106, 23, 'Duzak','Mario', ' '), (107, 02, 'Diante','Venite', ' '), (108, 06, 'Wiesenbach','Joni',' '), (109, 04, 'Travis','Brett', ' '), (110, 15, 'Genkazi','Stan', ' '); INSERT INTO [dbo].[PILOT] VALUES (100, ' ',' ',' '), (101, ' ',' ', ' '), (102, ' ',' ', ' '), (103, ' ',' ', ' '), (104, ' ',' ',' '), (105, ' ',' ',' '), (106, ' ',' ', ' '), (107, ' ',' ', ' '), (108, ' ',' ',' '), (109, ' ',' ', ' '), (110, ' ',' ', ' '); INSERT INTO [dbo].[MECHANIC] VALUES (100, ' ',' '), (101, ' ', ' '), (102, ' ', ' '), (103, ' ', ' '), (104, ' ',' '), (105, ' ',' '), (106, ' ', ' '), (107, ' ', ' '), (108, ' ',' '), (109, ' ', ' '), (110, ' ', ' '); INSERT INTO [dbo].[ACOUNTTANT] VALUES (100, ' ',' '), (101, ' ', ' '), (102, ' ', ' '), (103, ' ', ' '), (104, ' ',' '), (105, ' ',' '), (106, ' ', ' '), (107, ' ', ' '), (108, ' ',' '), (109, ' ', ' '), (110, ' ', ' '); select * from Tablacincouno select * from DEPENDENT select * from PILOT select * from MECHANIC select * from ACOUNTTANT
run
|
edit
|
history
|
help
0
TEST
Consecutive publisher publish more than 2 books for 3 days
Data row generator (good performance, w/o recursive CTE)
Stuff code in sql
Caronas
EXP 8 q2
create table employees as e. No, e. Name., e. Phone no, e. Salary
SI 1
program2
QLDT DB