Control_DB_Railway/SQL_Scripts/dbo.Stations.data.sql



SET IDENTITY_INSERT [dbo].[Stations] ON

INSERT INTO [dbo].[Stations] ([stationID], [typeStationID], [nameStation], [image], [overheadTransition], [location])
SELECT 1, 1, N'АБАГУС-ЛЕСНОЙ', BulkColumn, 0, N'Кемеровская'
FROM OPENROWSET (BULK 'D:\ППК СГТУ\4 курс\Учебная практика (1 семестр)\Control_DB_Railway\Images\station_kemero.jpg', Single_Blob) as ImageKemeroStation

INSERT INTO [dbo].[Stations] ([stationID], [typeStationID], [nameStation], [image], [overheadTransition], [location]) 
SELECT 3, 2, N'АБДУЛИНО', BulkColumn, 0, N'Оренбургская обл.'
FROM OPENROWSET (BULK 'D:\ППК СГТУ\4 курс\Учебная практика (1 семестр)\Control_DB_Railway\Images\station_orenb.jpg', Single_Blob) as ImageOrenbStation

INSERT INTO [dbo].[Stations] ([stationID], [typeStationID], [nameStation], [image], [overheadTransition], [location])
SELECT 4, 1, N'АБАЛАКОВО', BulkColumn, 1, N'Краснодарский край'
FROM OPENROWSET (BULK 'D:\ППК СГТУ\4 курс\Учебная практика (1 семестр)\Control_DB_Railway\Images\station_krasno.jpg', Single_Blob) as ImageKrasnoStation

INSERT INTO [dbo].[Stations] ([stationID], [typeStationID], [nameStation], [image], [overheadTransition], [location])
SELECT 1009, 4, N'АВРОРА', BulkColumn, 1, N'Республика Казахстан'
FROM OPENROWSET (BULK 'D:\ППК СГТУ\4 курс\Учебная практика (1 семестр)\Control_DB_Railway\Images\station_kazah.png', Single_Blob) as ImageKazahStation

INSERT INTO [dbo].[Stations] ([stationID], [typeStationID], [nameStation], [image], [overheadTransition], [location]) 
SELECT 1010, 2, N'АДНИКАН', BulkColumn, 1, N'Хабаровский край'
FROM OPENROWSET (BULK 'D:\ППК СГТУ\4 курс\Учебная практика (1 семестр)\Control_DB_Railway\Images\station_habar.jpg', Single_Blob) as ImageHabarStation

INSERT INTO [dbo].[Stations] ([stationID], [typeStationID], [nameStation], [image], [overheadTransition], [location]) VALUES (1011, 2, N'БИЙСК', null, 0, N'Алтайский край')
INSERT INTO [dbo].[Stations] ([stationID], [typeStationID], [nameStation], [image], [overheadTransition], [location]) VALUES (1012, 1, N'БУРБИН', null, 1, N'Витебская обл.')


SET IDENTITY_INSERT [dbo].[Stations] OFF