Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Gatoactual
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' Create table [dbo].[Gato]( [Atributo1] nvarchar(5), [Atributo2] Nvarchar(5), [Atributo3] Nvarchar(5), ) Create table [dbo].[Catalogo]( [Simbolo_J1] Varchar(5), [Simbolo_J2] varchar(5), ) Create Table [dbo].[Movimientos]( [Movimineto1] Varchar(5), [Fecha_y_hora1] datetime, [Movimineto2] Varchar(5), [Fecha_y_hora2] datetime, [Movimineto3] Varchar(5), [Fecha_y_hora3] datetime, [Movimineto4] Varchar(5), [Fecha_y_hora4] datetime, [Movimineto5] Varchar(5), [Fecha_y_hora5] datetime, ) go Create Table [dbo].[Movimientosgato]( [Jugador] Varchar(15), [Posicion] Varchar(15) ) Insert into [dbo].[Movimientosgato] Values ('X','ESD'), ('O','CM'), ('X','CD'), ('O','CI'), ('X','EID'), ('O','CI') Insert into [dbo].[Gato] Values ('O','','X'), ('O','X',''), ('X','',''); SELECT * FROM [dbo].[Gato]; Insert into [dbo].[Catalogo] Values ('X', 'O'); SELECT * FROM [dbo].[Catalogo]; Insert into [dbo].[Movimientos] Values ('X','2020-04-21 13:00','O','2020-04-21 13:05','X','2020-04-21 13:07','O','2020-04-21 13:10','X','2020-04-21 13:13'); Select * from [dbo].[Movimientos] SELECT * FROM [dbo].[Movimientosgato];
run
|
edit
|
history
|
help
0
TRANHOANGLONG
Window Functions - ROW_NUMBER()
join ans
SQL Server Mistique!?
SQl_QUEST_2_PRESENTATION_IMG_COUNT
Libros
Task_3_Final
TRY_SQL
performance on update using subquery versus correlated update
2 лаба