SQL基础问题 在线等抢分题
1。
declare cr cursor for kindno,kindname from basicdata..tbkind typeno='cypeno'and kindno in (select cuust from #cust)open cr fetch next from cr into @housecode,@housename
set@housecode=@housecode+';'+@housecodefetch next from cr into @housecode,@housename
select @monthd=max(monthdate)+1 from basicdate..tbmonthhead select @housecodes,@housenames,@monthd,getdate(),@employeecodes,@employeenames