www.pg1g.com

业务场景合作平台方需要对接业务数据库，新建用户设置相关权限。--创建用户。使用有管理员权限的用户创建一个新的用户： Create User MLSJPD Identified By Ue4lqau7; --连接权限: Grant Connect To MLSJPD ; --创建同义词权限: Grant Create Synonym To MLSJPD; --登录权限 Grant Create Se

- 阅读全文 -

create table #tt ( name nvarchar(50), rows char(50), reserved varchar(50), data varchar(50), index_size varchar(50), unused varchar(50) ) go --排序所有的表，按行数 insert #tt exec sp_msforeachtable 'exec sp_sp

- 阅读全文 -

rem auther:www.yumi-info.com rem date:20171222 rem ******MySQL backup start******** @echo off forfiles /p "D:\phpStudy\backup" /m backup_*.sql -d -30 /c "cmd /c del /f @path" set &

- 阅读全文 -

set rq=%date:~0,10% rem exp dlsjzs/dlsjzs@orcl file=d:\dbbak\dlsjzs%date:~0,4%%date:~5,2%%date:~8,2%.dmp expdp dlsjzs/dlsjzs@orcl logfile=log.log directory=expdp_dmp dumpfile

- 阅读全文 -

生成数据库快照declare @query varchar(1000) declare @DatabaseName varchar(128) declare @snapshotName varchar(128) declare @snapDataName varchar(128) declare @snapFileName varchar(128) declare @snapFilePath va

- 阅读全文 -