sql的问题。。帮我看看哦
来源:百度知道 编辑:UC知道 时间:2024/05/17 20:58:16
CREATE DATABASE Business
ON
PRIMARY(NAME=Biz_1
,
FILENAME='d:\sqlserver\数据\MSSQL\Data\Biz1dt.mdf',
SIZE=20,
MAXSIZE=50,
FILEGROWTH=15%),
(NAME=Biz2_dat,
FILENAME='d:\sqlserver\数据\MSSQL\Data\Biz2dat.ndf',
SIZE=10,
MAXSIZE=50,
FILEGROWTH=15%),
FILEGROUP BizGroup1
(NAME=Grp1Biz1_dat,
FILENAME='d:\sqlserver\数据\MSSQL\Data\G1Biz1dt.ndf',
SIZE=10,
MAXSIZE=50,
FILEGROWTH=5),
(NAME=Grp1Biz2_dat,
FILENAME='d:\sqlserver\数据\MSSQL\Data\G1Biz2dt.ndf',
SIZE=10,
MAXSIZE=50,
FILEGROWTH=5),
FILEGROUP BizGroup2
(NAME=Grp2Biz1_dat,
FILENAME='d:\sqlserver\数据\MSSQL\Data\G2Biz1dt.ndf',
ON
PRIMARY(NAME=Biz_1
,
FILENAME='d:\sqlserver\数据\MSSQL\Data\Biz1dt.mdf',
SIZE=20,
MAXSIZE=50,
FILEGROWTH=15%),
(NAME=Biz2_dat,
FILENAME='d:\sqlserver\数据\MSSQL\Data\Biz2dat.ndf',
SIZE=10,
MAXSIZE=50,
FILEGROWTH=15%),
FILEGROUP BizGroup1
(NAME=Grp1Biz1_dat,
FILENAME='d:\sqlserver\数据\MSSQL\Data\G1Biz1dt.ndf',
SIZE=10,
MAXSIZE=50,
FILEGROWTH=5),
(NAME=Grp1Biz2_dat,
FILENAME='d:\sqlserver\数据\MSSQL\Data\G1Biz2dt.ndf',
SIZE=10,
MAXSIZE=50,
FILEGROWTH=5),
FILEGROUP BizGroup2
(NAME=Grp2Biz1_dat,
FILENAME='d:\sqlserver\数据\MSSQL\Data\G2Biz1dt.ndf',
在查询分析器中运行如下代码:
declare @sql varchar(100)
while 1=1
begin
select top 1 @sql = 'kill '+cast(spid as varchar(3))
from master..sysprocesses
where spid > 50 and spid <> @@spid
if @@rowcount = 0
break
exec(@sql)
end
sql怎么问这里了