恢复被使用数据库

use master
go
exec Sp_KillAllProcessInDB 'guagua_goods_config'
go

---以下为恢复备份时， 通过脚本生成的内容

RESTORE DATABASE [guagua_goods_config] FROM  DISK = N'C:\guaguagoods备份\guagua_goods_config_backup_2013_10_06_030006_6311039.bak' WITH  FILE = 1,  MOVE N'guagua_goods_config' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\guagua_goods_config.mdf',  MOVE N'guagua_goods_config_log' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\guagua_goods_config.ldf',  NOUNLOAD,  REPLACE,  STATS = 10
GO

 

快速插入大批量数据，格式如下：

declare @user_id bigint
set @user_id=40000000
while (@user_id<=40000200)
begin
insert into t_user_money values(
@user_id,100000000,0)
set @user_id=@user_id+1
end

 

命令删除批量数据库，格式如下：

select 'drop database '+name from sys.databases
where name like 'guagua_monitor_2%'