commerce_dropdb.sql

来自「电子商务事例」· SQL 代码 · 共 34 行

-- ===============================================
-- CONFIG ASP.NET Commerce STARTER KIT DATABASE
-- Drop Database Script
-- 
-- Version:	1.2 - 10/02 (mho)
--
-- ===============================================

USE [master]

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Commerce')
BEGIN
	DECLARE @spid smallint
	DECLARE @sql varchar(4000)

	DECLARE crsr CURSOR FAST_FORWARD FOR
		SELECT spid FROM sysprocesses p INNER JOIN sysdatabases d ON d.[name] = 'Commerce' AND p.dbid = d.dbid

	OPEN crsr
	FETCH NEXT FROM crsr INTO @spid

	WHILE @@FETCH_STATUS != -1
	BEGIN
		SET @sql = 'KILL ' + CAST(@spid AS varchar)
		EXEC(@sql) 
		FETCH NEXT FROM crsr INTO @spid
	END

	CLOSE crsr
	DEALLOCATE crsr

	DROP DATABASE [Commerce]
END
GO