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
Pana la ex 8, inclusiv
ms sql update,insert
Turn comma-separated numbers in string into rows
Miglior film animato
Using Variables
base de datos dbfloreria
Except Insert missing
How to find 2nd highest salary
customers table
Employee database