动态游标！！！！！！

Question

DECLARE AddIdColumns_Cursor INSENSITIVE CURSOR                                              
            
    FOR SELECT Id                                              
            
        FROM PDL_ProcGroup (nolock)                                              
            
    OPEN AddIdColumns_Cursor                                              
            
    BEGIN                                              
            
      FETCH NEXT FROM AddIdColumns_Cursor INTO @Id                                              
            
      WHILE @@FETCH_STATUS = 0                                              
            
      BEGIN                                              
            
           exec('ALTER TABLE #tmpWIP add ' + '[AA' + @Id + ']  int NOT NULL DEFAULT(0)')                                              
            
           FETCH NEXT FROM AddIdColumns_Cursor INTO @Id                                              
            
      END                                              
            
    END                                              
            
    CLOSE AddIdColumns_Cursor                                              
            
    DEALLOCATE AddIdColumns_Cursor

Answer 1

在function中是不是不允许 使用exec

Answer 2

create proc test
  ...
as 
begin
   set 列=case 变量 when 条件 then ... else ... end,
            ...
         case 变量 when 条件 then ... else ... end    declare cursor_test cursor for
     select 列  from 表
...
end