可用以下方法:(先建一表#t)declare @LB CHAR(8) DECLARE ck_cursor CURSOR LOCAL SCROLL_LOCKS FOR SELECT LB from CK open ck_cursor fetch from ck_cursor into @LB WHILE (@@FETCH_STATUS=0) BEGIN select @sql=' alter table #t add '+ @LB+ ' money null ' execute (@sql) fetch from ck_cursor into @LB END
可用以下方法:(先建一表#t)declare @LB CHAR(8)
DECLARE ck_cursor CURSOR LOCAL SCROLL_LOCKS FOR SELECT LB from CK
open ck_cursor
fetch from ck_cursor into @LB
WHILE (@@FETCH_STATUS=0)
BEGIN
select @sql=' alter table #t add '+ @LB+ ' money null '
execute (@sql) fetch from ck_cursor into @LB
END