Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

FIGURA5.1

--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 

    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'))
            select * from Tablacincouno
 run  | edit  | history  | help 0