FIGURA5.1
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
|
|
|