try:
DECLARE @strSQL NVARCHAR(1000)
DECLARE @strPointName NVARCHAR(256)
DECLARE @CountPartNum INT
set @strPointName ='RAILWAY_POINT'
set @CountPartNum=100000
set @strSQL=' Insert into RailPoint(PartID,PointID,X,Y)
select PartRecordID + '+ cast(@CountPartNum as varchar)+',PointID,PadfX,PadfY from
OpenRowset(''MSDASQL.1'',''Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=e:\dbf\;User ID=Admin;Password=;Extensions=csv;'',''select * from "'+@strPointName+'.csv"'')'
exec(@strSQL)
解决方案 »
- 如何对表默认排序
- 图文混排的内容,需要存入数据库再取出来,最后写word,怎么做
- SQL server
- 请教现在的论坛一般用什么数据库比较多一些
- 怎样看已安装的sqlserver是个人版,还是企业版,或者是标准版?谢谢
- 请问一下,有没有可能在用IN的同时使用模糊查询,内祥。
- Must declare the scalar variable "@Columns".
- DTS导出操作如何用代码实现?
- 写不进数据,怎么回事?
- 安装sqlserver莫名其妙推出怎么办?
- 在select 语句中,列名含有转换等函数,太长了,就as 新列名,结果后面where 条件中还是不能用新列名,,,help!!
- 如何在不删除表中记录的情况下重置identity列?
DECLARE @strSQL NVARCHAR(1000)
DECLARE @strPointName NVARCHAR(256)
DECLARE @CountPartNum INT
set @strPointName ='RAILWAY_POINT'
set @CountPartNum=100000
set @strSQL=' Insert into RailPoint(PartID,PointID,X,Y)
select PartRecordID + '+ cast(@CountPartNum as varchar)+',PointID,PadfX,PadfY from
OpenRowset(''MSDASQL.1''
,''Driver={Microsoft Text Driver(*.txt; *.csv)};DefaultDir=e:\dbf\
;User ID=Admin;Password=;Extensions=csv;''
,''select * from '+@strPointName+'.csv'') T'
exec(@strSQL)
'select PartRecordID+'+ cast(@CountPartNum as varchar)+',PointID,PadfX,PadfY from ........................
DECLARE @strSQL NVARCHAR(256);
DECLARE @strPointName NVARCHAR(256);
DECLARE @CountPartNum INT;
set @strPointName ='RAILWAY_POINT';
set @CountPartNum=100000;
set @strSQL = 'Insert into RailPoint(PartID,PointID,X,Y) select PartRecordID+'+ cast(@CountPartNum as varchar)+',PointID,PadfX,PadfY from OpenRowset(''MSDASQL.1'', ''Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=e:\dbf\;User ID=Admin;Password=;Extensions=csv;'',''select * from "'+@strPointName+'.csv"'')'
exec(@strSQL)服务器: 消息 105,级别 15,状态 1,行 1
字符串 'select * from "RAILWAY_POIN' 之前有未闭合的引号。
服务器: 消息 170,级别 15,状态 1,行 1
第 1 行: 'select * from "RAILWAY_POIN' 附近有语法错误。
DECLARE @strPointName NVARCHAR(256);
DECLARE @CountPartNum INT;
set @strPointName ='RAILWAY_POINT';
set @CountPartNum=100000;
set @strSQL = 'Insert into RailPoint(PartID,PointID,X,Y) select PartRecordID+'+ cast(@CountPartNum as varchar)+',PointID,PadfX,PadfY from OpenRowset(''MSDASQL.1'', ''Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=e:\dbf\;User ID=Admin;Password=;Extensions=csv;'',''select * from "'+@strPointName+'.csv"'')'
exec(@strSQL)