?? createmessageforprivatemessageemail.sql
字號:
delete [dbo].[Community_Messages] where [Message_Name] = 'Private Message'
go
delete [dbo].[Community_SampleMessages] where [Message_Name] = 'Private Message'
go
DECLARE @c_id int
DECLARE CommunityCursor CURSOR FOR Select community_id from Community_Communities
OPEN CommunityCursor
FETCH NEXT FROM CommunityCursor INTO @c_id
WHILE (@@FETCH_STATUS = 0)
BEGIN
INSERT INTO [dbo].[Community_Messages]
(
[Message_CommunityID],
[Message_Name],
[Message_Title],
[Message_Description],
[Message_Body]
)
VALUES
(
@c_id,
'Private Message',
'<ContentSubject>',
'Template for messages sent from one user to another',
'Dear <RecipientFullName>,
<SenderUserName> from <CommunityName> has sent you the following Private Message:
-----------------------------
<BodyText>
-----------------------------
You may reply to <SenderUserName> with a Private Message at:
<ReplyLink>
If you would like to disable future messages, uncheck the "Enable Private Messages" option on your profile at:
<EditProfileLink>'
)
FETCH NEXT FROM CommunityCursor INTO @c_id
END
CLOSE CommunityCursor
DEALLOCATE CommunityCursor
go
INSERT INTO [dbo].[Community_SampleMessages]
(
[Message_CommunityID],
[Message_Name],
[Message_Title],
[Message_Description],
[Message_Body]
)
VALUES
(
74,
'Private Message',
'<ContentSubject>',
'Template for messages sent from one user to another',
'Dear <RecipientFullName>,
<SenderUserName> from <CommunityName> has sent you the following Private Message:
-----------------------------
<BodyText>
-----------------------------
You may reply to <SenderUserName> with a Private Message at:
<ReplyLink>
If you would like to disable future messages, uncheck the "Enable Private Messages" option on your profile at:
<EditProfileLink>'
)
go
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -