拼SQL时少写了几个单引号。declare @phonenum varchar(20),@exec varchar(200) set @phonenum = '13721448041' select userid,content,reqtime,bizcode,bizid from openquery(my140,'select feeusermsisdn as userid,content,reqtime,spcode as bizcode, productid as bizid from molog where userid =''' +@phonenum + '''')
bugchen888(臭虫) :不对,改成这样也还是同样的错误 '+' 附近有语法错误。
declare @phonenum varchar(20),@exec varchar(200) set @phonenum = '13721448041' select userid,content,reqtime,bizcode,bizid from openquery(my140,'select feeusermsisdn as userid,content,reqtime,spcode as bizcode, productid as bizid from molog where userid ='' +@phonenum + ''')
看看帮助啊,说得很清楚 Res OPENQUERY does not accept variables for its arguments.
set @phonenum = '13721448041'
select userid,content,reqtime,bizcode,bizid from
openquery(my140,'select feeusermsisdn as userid,content,reqtime,spcode as bizcode,
productid as bizid from molog where userid =''' +@phonenum + '''')
'+' 附近有语法错误。
set @phonenum = '13721448041'
select userid,content,reqtime,bizcode,bizid from
openquery(my140,'select feeusermsisdn as userid,content,reqtime,spcode as bizcode,
productid as bizid from molog where userid ='' +@phonenum + ''')
Res
OPENQUERY does not accept variables for its arguments.