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] プロジェクトファイルを追加。

---
 Document/Sql/列設定追加.sql |   26 ++++++++++++++++++++++++++
 1 files changed, 26 insertions(+), 0 deletions(-)

diff --git "a/Document/Sql/\345\210\227\350\250\255\345\256\232\350\277\275\345\212\240.sql" "b/Document/Sql/\345\210\227\350\250\255\345\256\232\350\277\275\345\212\240.sql"
new file mode 100644
index 0000000..e1f0961
--- /dev/null
+++ "b/Document/Sql/\345\210\227\350\250\255\345\256\232\350\277\275\345\212\240.sql"
@@ -0,0 +1,26 @@
+--INSERT INTO S_ReportCol
+--SELECT 10001,name,'' FROM HotelPms.sys.columns WHERE object_id = OBJECT_ID('HotelPms.dbo.M_Building')
+
+DELETE FROM S_ReportCol WHERE ReportID = 10000;
+
+INSERT INTO S_ReportCol
+SELECT 10000,A.column_id, A.name, CASE WHEN b.value IS NULL THEN A.name ELSE CAST(b.value AS NVARCHAR) END,GETDATE(),0,'',0 FROM HotelPms.sys.columns A
+LEFT JOIN HotelPms.sys.extended_properties B ON A.object_id = B.major_id AND A.column_id = B.minor_id AND B.name='MS_Description'
+WHERE object_id = OBJECT_ID('HotelPms.dbo.M_Demo')
+
+
+DELETE FROM S_ReportCol WHERE ReportID = 10001;
+
+INSERT INTO S_ReportCol
+SELECT 10001,A.column_id, A.name, CASE WHEN b.value IS NULL THEN A.name ELSE CAST(b.value AS NVARCHAR) END,GETDATE(),0,'',0 FROM HotelPms.sys.columns A
+LEFT JOIN HotelPms.sys.extended_properties B ON A.object_id = B.major_id AND A.column_id = B.minor_id AND B.name='MS_Description'
+WHERE object_id = OBJECT_ID('HotelPms.dbo.M_Building')
+
+DELETE FROM S_ReportCol WHERE ReportID = 10002;
+
+INSERT INTO S_ReportCol
+SELECT 10002,A.column_id, A.name, CASE WHEN b.value IS NULL THEN A.name ELSE CAST(b.value AS NVARCHAR) END,GETDATE(),0,'',0 FROM HotelPms.sys.columns A
+LEFT JOIN HotelPms.sys.extended_properties B ON A.object_id = B.major_id AND A.column_id = B.minor_id AND B.name='MS_Description'
+WHERE object_id = OBJECT_ID('HotelPms.dbo.M_RoomStatus')
+
+--EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'����' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'M_Building', @level2type=N'COLUMN',@level2name=N'Name'
\ No newline at end of file

--
Gitblit v1.10.0