createmessageforprivatemessageemail.sql

ASP开发网站的 关于网站的设计和说明 还有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