第三食堂

建表orders: create table orders (OrderID INT,CustomerID NCHAR(5))    insert into orders values(1,'aaaa')         insert into orders values(2,'bbbb') 复制一个数据进orders2表中 select * into orders2 from

alter proc demo_proc  as begin declare updateCursor cursor for  select jhlsh from jgpj_khjh_jbxx where qyzt='1' and qsyf is not null open updateCursor  declare @jhlsh varchar(64) fetch next f