在Sqlserver 2005中合并字符串 [英] Concatnate the string in 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屋！