摘要：
select 'drop table '+name+';' from sys.tables declare c cursor forselect NAME from sysobjects where xtype='U' order by NAMEdeclare @t varchar(200)open 阅读全文
摘要：
--创建一个游标 DECLARE my_cursor CURSOR FOR SELECT id, Bran_number, Bran_taxis FROM dbo.Base_Branch; --打开游标 OPEN my_cursor; DECLARE @id INT; DECLARE @Bran_t 阅读全文