2020-02-16 标签:sqlserver,自动,备份,数据库,sql,实现,代码,如下,use,master,declare,dbname,varchar,60,backsql,1000,mycursor,cursor,select,n

实现代码如下：use master declare @DbName varchar(60) declare @BackSql varchar(1000) declare myCursor cursor for SELECT [name] FROM SYSDATABASES where [name]

2020-02-16 标签:批处理,动态,sql,declare,type,ref,cursor,v,mycursor,id,list,table,integer,n,ame,varchar,30,tabid,tabname

１. DECLARE TYPE ref_cursor_type IS ref CURSOR; v_mycursor ref_cursor_type; TYPE id_list IS TABLE OF integer; TYPE name_list IS TABLE OF varchar2(30);