检查此代码哪里有错误 [英] check this code where are mistak

问题描述

DECLARE @previousstatus nvarchar(50)
DECLARE @presentstatus nvarchar(50)

Select @previousstatus = statu FROM ssse where ID = (Select max(id) From ssse)

IF Enddateparameter < cast(getdate() as date) then @presentstatus = 'Inactive'

IF @previousstatus = 'Inactive'
BEGIN
    Insert INTO ssse(startdate,enddate,status) VALUES(startdateparameter,enddateparameter,@presentstatus)
END

$ b



错误给出关键字附近的语法不正确'然后'。

error given "Incorrect syntax near the keyword 'then'."

推荐答案

将语法更改为：

Change your syntax to this:

DECLARE @previousstatus nvarchar(50)
DECLARE @presentstatus nvarchar(50)
 
Select @previousstatus = statu FROM ssse where ID = (Select max(id) From ssse)
 
IF Enddateparameter < cast(getdate() as date) 
Begin
    Set @presentstatus = 'Inactive'
End
 
IF @previousstatus = 'Inactive'
BEGIN
    Insert INTO ssse(startdate,enddate,status) VALUES(startdateparameter,enddateparameter,@presentstatus)
END

这篇关于检查此代码哪里有错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！