SQL Server 中的 OPENQUERY 显示错误

Question

我在查询下方使用链接服务器，但它显示错误。我错过了任何引号吗？有人可以帮助我吗？

DECLARE @fromdt DATETIME = '2018-04-07';
DECLARE @EndDate1 DATETIME = '2018-04-07';
SELECT * 
FROM OPENQUERY(TIMEV,
               'SELECT REPLACE(LTRIM(REPLACE(badgenumber,"0"," "))," ","0") badgenumber, checktime as dt
                FROM checkinout a 
                JOIN USERINFO c ON c.userid = a.userid  
                WHERE checktime >= '''''+CONVERT(CHAR(10), @fromdt, 120)+'''''  AND ''''' + CONVERT(CHAR(10), @EndDate1, 120) + ''''' ')

Answer 1

我想你想要更多这样的东西：

Select * 
from openquery(TIMEV, '
SELECT REPLACE(LTRIM(REPLACE(badgenumber, ''0'', '' '')), '' '', ''0'') badgenumber,checktime as dt
FROM checkinout a JOIN
     USERINFO c 
     ON c.userid = a.userid  
WHERE checktime >= CAST(''' + @fromdt + ''' as date)  AND CAST(''' + @EndDate1 + ''' as date)
';