How to write this stored procedure which has two sql statement

See more:

SQL-Server

Hi,

In this SQL statement:

insert Messages
(MessageAddress,MessageContent,UserID)
values
('Hello','How are you',1)

there are column MessageID which will be enter automatically:

MessageID int Primary key identity(1,1) not null

I have this stored procedure :

CREATE PROCEDURE dbo.uspPostnewMessage
	@ReceivedUserID nvarchar(50),
	@SendUserID int,
	@MessageAddress nvarchar(255),
	@MessageContent ntext
AS
insert Messages
(MessageAddress,MessageContent,UserID)
values 
(@MessageAddress,@MessageContent,@SendUserID)
insert ReceivedMessages
(MessageID,UserID)
values 
(@MessageID,@ReceivedUserID)
GO

The value of MessageID in the second SQL statement is the value which inserted
automatically in the first SQL statement,

then, how to know this value?

i hope you understand me.....

thanks