sql - 如何在 sql server 2008 中声明时在游标中使用 if 条件？

Question

我有如下查询

Declare Cur_1 cursor for 

        if @EmployeeId <> is not null
            begin
                select EmployeeID from tbl_Employee where EEmployeeStatus='Active' and EmployeeID = @EmployeeId
            end
        else
            begin
                select EmployeeID from tbl_Employee where EEmployeeStatus='Active'
            end

Open Cur_1

    Fetch next from Cur_1 into @EmpId   
    While @@FETCH_STATUS=0
    Begin

    end
Close Cur_1
deallocate Cur_1

但它不起作用。它告诉我语法错误。

它在 if 条件下显示语法错误..

请帮帮我......

Answer 1

 if @Feild is not null
      begin
            Declare your_Cursor_Name cursor for     
                    select Feild1 from Your_table where 1=1
        end
    else
        begin
            Declare your_Cursor_Name cursor for     
                    select Feild1 from Your_table where 1=1
         end

    Open your_Cursor_Name 

        Fetch next from your_Cursor_Name into @xyz
        While @@FETCH_STATUS=0
        Begin
             `enter code here
        end
Close your_Cursor_Name