在Sql Service中当Sql语句当成参数时，查询条件报错怎么弄

[Zhang_Jia_Hao1]

select COUNT(*) from OPENQUERY(LinkName3, 'select bill_id from ILIMS_Customs.dbo.store_in_head where create_date>="2017-01-01 00:00:00.000" and status=5')

[Zhang_Jia_Hao1]

这个语句，执行查询时 会报这样的一个错误，就是获取不到2017-01-01 00:00:00.000这个值作为参数

[二月十六]

SELECT
    COUNT(*)
FROM
    OPENQUERY
        (LinkName3,
         'select bill_id from ILIMS_Customs.dbo.store_in_head where create_date>=''2017-01-01 00:00:00.000'' and status=5'
        );

[卖水果的net]

select COUNT(*) from OPENQUERY(LinkName3, 'select bill_id from ILIMS_Customs.dbo.store_in_head where create_date>="2017-01-01 00:00:00.000" and status=5') 楼主好像输入的是一个双引号， 应该换成两个单引号， 两个。

[Zhang_Jia_Hao1]

引用 2 楼 sinat_28984567 的回复:

SELECT
    COUNT(*)
FROM
    OPENQUERY
        (LinkName3,
         'select bill_id from ILIMS_Customs.dbo.store_in_head where create_date>=''2017-01-01 00:00:00.000'' and status=5'
        );

感谢大佬

[Zhang_Jia_Hao1]

引用 3 楼 wmxcn2000 的回复:

select COUNT(*) from OPENQUERY(LinkName3, 'select bill_id from ILIMS_Customs.dbo.store_in_head where create_date>="2017-01-01 00:00:00.000" and status=5') 楼主好像输入的是一个双引号， 应该换成两个单引号， 两个。

感谢大佬