You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 

23 lines
798 B

INSERT INTO dbo.OTB_SYS_SystemSetting
( OrganizationID ,
SettingItem ,
SettingDescription ,
SettingValue ,
Memo ,
Effective ,
CreateUser ,
CreateDate ,
ModifyUser ,
ModifyDate
)
VALUES ( 'AA' , -- OrganizationID - varchar(50)
N'CloseImgCount' , -- SettingItem - nvarchar(50)
N'上傳圖片顯示數量' , -- SettingDescription - nvarchar(100)
N'30' , -- SettingValue - nvarchar(400)
'上傳圖片顯示數量' , -- Memo - text
'Y' , -- Effective - char(1)
'APADMIN' , -- CreateUser - varchar(50)
GETDATE() , -- CreateDate - datetime
'APADMIN' , -- ModifyUser - varchar(50)
GETDATE() -- ModifyDate - datetime
)