sql server 导进数据

 

导出数据教程:https://www.cnblogs.com/sexintercourse/p/10026125.html

 

USE [znaf]
GO
INSERT [dbo].[threemap_point] ([threemap_point_id], [markType], [spaceType], [worldPosition], [worldRotation], [scale], [deviceName], [ENABLE], [threemap_id], [threemap_reserve1], [threemap_reserve2], [threemap_reserve3]) VALUES (N'DianwangNZ001', N'dianWang', N'outside', N'-2.561938_-7.117784_27.13426', N'0_0.9879599_0', N'1_1_1', N'电网1', N'True', N'Main', N'{"markType":"dianWang","spaceType":"outside","id":"DianwangNZ001","worldPosition":{"x":"-2.561938","y":"-7.117784","z":"27.13426"},"worldRotation":{"x":"0","y":"0.9879599","z":"0","w":"-0.1547105"},"scale":{"x":"1","y":"1","z":"1"},"deviceName":"电网1","enable":true,"areaID":"Main"}', N'', N'')
INSERT [dbo].[threemap_point] ([threemap_point_id], [markType], [spaceType], [worldPosition], [worldRotation], [scale], [deviceName], [ENABLE], [threemap_id], [threemap_reserve1], [threemap_reserve2], [threemap_reserve3]) VALUES (N'DianwangNZ002', N'dianWang', N'outside', N'-2.561938_-7.117784_27.13426', N'0_0.9879599_0', N'1_1_1', N'电网2', N'True', N'Main', N'{"markType":"dianWang","spaceType":"outside","id":"DianwangNZ002","worldPosition":{"x":"-2.561938","y":"-7.117784","z":"27.13426"},"worldRotation":{"x":"0","y":"0.9879599","z":"0","w":"-0.1547105"},"scale":{"x":"1","y":"1","z":"1"},"deviceName":"电网2","enable":true,"areaID":"Main"}', N'', N'')
INSERT [dbo].[threemap_point] ([threemap_point_id], [markType], [spaceType], [worldPosition], [worldRotation], [scale], [deviceName], [ENABLE], [threemap_id], [threemap_reserve1], [threemap_reserve2], [threemap_reserve3]) VALUES (N'DianwangNZ003', N'dianWang', N'outside', N'-2.561938_-7.117784_27.13426', N'0_0.9879599_0', N'1_1_1', N'电网3', N'True', N'Main', N'{"markType":"dianWang","spaceType":"outside","id":"DianwangNZ003","worldPosition":{"x":"-2.561938","y":"-7.117784","z":"27.13426"},"worldRotation":{"x":"0","y":"0.9879599","z":"0","w":"-0.1547105"},"scale":{"x":"1","y":"1","z":"1"},"deviceName":"电网3","enable":true,"areaID":"Main"}', N'', N'')
INSERT [dbo].[threemap_point] ([threemap_point_id], [markType], [spaceType], [worldPosition], [worldRotation], [scale], [deviceName], [ENABLE], [threemap_id], [threemap_reserve1], [threemap_reserve2], [threemap_reserve3]) VALUES (N'DianwangNZ004', N'dianWang', N'outside', N'-2.561938_-7.117784_27.13426', N'0_0.9879599_0', N'1_1_1', N'电网4', N'True', N'Main', N'{"markType":"dianWang","spaceType":"outside","id":"DianwangNZ004","worldPosition":{"x":"-2.561938","y":"-7.117784","z":"27.13426"},"worldRotation":{"x":"0","y":"0.9879599","z":"0","w":"-0.1547105"},"scale":{"x":"1","y":"1","z":"1"},"deviceName":"电网4","enable":true,"areaID":"Main"}', N'', N'')
INSERT [dbo].[threemap_point] ([threemap_point_id], [markType], [spaceType], [worldPosition], [worldRotation], [scale], [deviceName], [ENABLE], [threemap_id], [threemap_reserve1], [threemap_reserve2], [threemap_reserve3]) VALUES (N'DianwangNZ005', N'dianWang', N'outside', N'-2.561938_-7.117784_27.13426', N'0_0.9879599_0', N'1_1_1', N'电网5', N'True', N'Main', N'{"markType":"dianWang","spaceType":"outside","id":"DianwangNZ005","worldPosition":{"x":"-2.561938","y":"-7.117784","z":"27.13426"},"worldRotation":{"x":"0","y":"0.9879599","z":"0","w":"-0.1547105"},"scale":{"x":"1","y":"1","z":"1"},"deviceName":"电网5","enable":true,"areaID":"Main"}', N'', N'')
INSERT [dbo].[threemap_point] ([threemap_point_id], [markType], [spaceType], [worldPosition], [worldRotation], [scale], [deviceName], [ENABLE], [threemap_id], [threemap_reserve1], [threemap_reserve2], [threemap_reserve3]) VALUES (N'DianwangNZ006', N'dianWang', N'outside', N'-2.561938_-7.117784_27.13426', N'0_0.9879599_0', N'1_1_1', N'电网6', N'True', N'Main', N'{"markType":"dianWang","spaceType":"outside","id":"DianwangNZ006","worldPosition":{"x":"-2.561938","y":"-7.117784","z":"27.13426"},"worldRotation":{"x":"0","y":"0.9879599","z":"0","w":"-0.1547105"},"scale":{"x":"1","y":"1","z":"1"},"deviceName":"电网6","enable":true,"areaID":"Main"}', N'', N'')
INSERT [dbo].[threemap_point] ([threemap_point_id], [markType], [spaceType], [worldPosition], [worldRotation], [scale], [deviceName], [ENABLE], [threemap_id], [threemap_reserve1], [threemap_reserve2], [threemap_reserve3]) VALUES (N'DianwangNZ007', N'dianWang', N'outside', N'-2.561938_-7.117784_27.13426', N'0_0.9879599_0', N'1_1_1', N'电网7', N'True', N'Main', N'{"markType":"dianWang","spaceType":"outside","id":"DianwangNZ007","worldPosition":{"x":"-2.561938","y":"-7.117784","z":"27.13426"},"worldRotation":{"x":"0","y":"0.9879599","z":"0","w":"-0.1547105"},"scale":{"x":"1","y":"1","z":"1"},"deviceName":"电网7","enable":true,"areaID":"Main"}', N'', N'')
INSERT [dbo].[threemap_point] ([threemap_point_id], [markType], [spaceType], [worldPosition], [worldRotation], [scale], [deviceName], [ENABLE], [threemap_id], [threemap_reserve1], [threemap_reserve2], [threemap_reserve3]) VALUES (N'DianwangNZ008', N'dianWang', N'outside', N'-2.561938_-7.117784_27.13426', N'0_0.9879599_0', N'1_1_1', N'电网8', N'True', N'Main', N'{"markType":"dianWang","spaceType":"outside","id":"DianwangNZ008","worldPosition":{"x":"-2.561938","y":"-7.117784","z":"27.13426"},"worldRotation":{"x":"0","y":"0.9879599","z":"0","w":"-0.1547105"},"scale":{"x":"1","y":"1","z":"1"},"deviceName":"电网8","enable":true,"areaID":"Main"}', N'', N'')

 

©️2020 CSDN 皮肤主题: 创作都市 设计师:CSDN官方博客 返回首页