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',

在查询分析器中运行如下代码:
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怎么问这里了