在Sqlserver 2005中合并字符串 [英] Concatnate the string in Sqlserver 2005
本文介绍了在Sqlserver 2005中合并字符串的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您好,以下所有代码都可以正常工作.
Hi to all following code work fine.
SELECT *
FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=E:\backup\my.xls'', ''select * from [Sheet1$] where area is not null'')
但是其中有一些修改.它给出一个错误.参见代码:
But some modification in it. it give a error. see the code :
ALTER procedure [dbo].[getdata]
(
@DataFeed varchar(20)=''my.xls''
)
as
SELECT *
FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=E:\backup\'' + @DataFeed + '''', ''select * from [Sheet1$] where area is not null'')
错误是:'+'附近的语法不正确.
The error is : Incorrect syntax near ''+''.
推荐答案
其中的区域不为空'')
where area is not null'')
但是其中有一些修改.它给出一个错误.参见代码:
But some modification in it. it give a error. see the code :
ALTER procedure [dbo].[getdata]
(
@DataFeed varchar(20)=''my.xls''
)
as
SELECT *
FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=E:\backup\'' + @DataFeed + '''', ''select * from [Sheet1
where area is not null'')
where area is not null'')
错误是:"+"附近的语法不正确.
The error is : Incorrect syntax near ''+''.
更改此:
@DataFeed + '''', ''select * from [Sheet1
这篇关于在Sqlserver 2005中合并字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文