语法附近不正确 [英] Incorrect syntax near time

问题描述

大家好，

我用动态查询写了sp如下：

Hi everybody,
I wrote sp using dynamic query as follows:

BEGIN
                        SELECT @SQL=N'SELECT Imei_Id,Device_status,Device_DateTime,Fuel,Analog_data,Serial_data FROM dbo.'+@tablename +
                        ' WHERE Device_DateTime BETWEEN ' +@fromDateTime+ 'AND ' +@toDateTime

                        EXEC sp_executesql @SQL
                    END

执行时，

While executing,

USE [Fleet_Management]
GO

DECLARE @return_value int

EXEC    @return_value = [dbo].[Usp_GetImeiTable]
        @imeiNumber = N'355255040985708',
        @fromDateTime = N'2014-03-21 14:28:27.000',
        @toDateTime = N'2014-03-21 14:28:36.000'

SELECT  'Return Value' = @return_value

GO

'14'附近的语法不正确 - >错误

Incorrect syntax near'14'--> Error

推荐答案

您的日期需要引号。

You need quotation marks around your dates.

BEGIN
    SELECT @SQL=N'SELECT Imei_Id,Device_status,Device_DateTime,Fuel,Analog_data,Serial_data FROM dbo.'+@tablename +
    ' WHERE Device_DateTime BETWEEN '' +@fromDateTime+ '' AND '' +@toDateTime + ''

    EXEC sp_executesql @SQL
END

这篇关于语法附近不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！