select 'defncopy -U'+u.name+' -P123456 -SSERVER16 out '+o.name+'.sql JXC_TEST '+o.name
from sysobjects o,sysusers u
where o.uid=u.uid
and o.type='P'
提取SYBASE数据库某库的存储过程内容,并保存到本地。
dump database BJ to 'D:/BJ.dump'
备份数据库
select 'defncopy -U'+u.name+' -P123456 -SSERVER16 out '+o.name+'.sql JXC_TEST '+o.name
from sysobjects o,sysusers u
where o.uid=u.uid
and o.type='P'
提取SYBASE数据库某库的存储过程内容,并保存到本地。
dump database BJ to 'D:/BJ.dump'
备份数据库