From 1a1c8e71fcd14858f595029f089b2d4a00202b32 Mon Sep 17 00:00:00 2001
From: ogi <Administrator@S-OGI-PC>
Date: Fri, 05 Dec 2025 09:24:16 +0900
Subject: [PATCH] プロジェクトファイルを追加。
---
HotelPms.Share/Data/Script/MsSql/SP_CloseDBConnect.sql | 46 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 46 insertions(+), 0 deletions(-)
diff --git a/HotelPms.Share/Data/Script/MsSql/SP_CloseDBConnect.sql b/HotelPms.Share/Data/Script/MsSql/SP_CloseDBConnect.sql
new file mode 100644
index 0000000..15bba3f
--- /dev/null
+++ b/HotelPms.Share/Data/Script/MsSql/SP_CloseDBConnect.sql
@@ -0,0 +1,46 @@
+CREATE PROCEDURE SP_CloseDBConnect
+ @Dname varchar(50)
+AS
+BEGIN
+ DECLARE @name varchar(50), @s varchar(1000)
+
+ IF (@Dname = '')
+ BEGIN
+ DECLARE DataName CURSOR FOR SELECT name FROM sys.databases WHERE name not in ('master');
+
+ OPEN DataName
+ FETCH NEXT FROM DataName INTO @name
+ WHILE (@@FETCH_STATUS = 0)
+ BEGIN
+ DECLARE tb CURSOR local FOR SELECT N'kill '+CAST(spid AS varchar) FROM master..sysprocesses WHERE dbid=db_id(@name)
+
+ OPEN tb
+ FETCH next FROM tb INTO @s
+ WHILE @@FETCH_STATUS=0
+ BEGIN
+ EXEC(@s)
+ FETCH NEXT FROM tb INTO @s
+ END
+ CLOSE tb
+ DEALLOCATE tb
+
+ FETCH NEXT FROM DataName INTO @name
+ END
+ CLOSE DataName
+ DEALLOCATE DataName
+ END
+ ELSE
+ BEGIN
+ DECLARE tb CURSOR local FOR SELECT N'kill '+CAST(spid AS varchar) FROM master..sysprocesses WHERE dbid=db_id(@Dname)
+
+ OPEN tb
+ FETCH next FROM tb INTO @s
+ WHILE @@FETCH_STATUS=0
+ BEGIN
+ EXEC(@s)
+ FETCH NEXT FROM tb INTO @s
+ END
+ CLOSE tb
+ DEALLOCATE tb
+ END
+END
--
Gitblit v1.10.0