Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE ReceiveChat
- @Sender INT,
- @Receiver INT,
- @ChatID INT,
- @SenderMessage NVARCHAR(80)
- AS
- BEGIN
- SELECT [dbo].[Chats].*
- FROM [dbo].[Chats]
- WHERE ([Sender] = @Sender) AND ([Receiver] = @Receiver)
- AND ([Chat_ID] = @ChatID)
- INSERT INTO [dbo].[Chats] (Chat)
- VALUES (@SenderMessage)
- END
- EXEC ReceiveChat 1, 2, 8, 'hello my friend'
- Chat_ID - Sender -Receiver -Chat_Time - Chat :
- 9 - 1 - 2 - 2018-07-20 15:58 - hello my friend ?
Add Comment
Please, Sign In to add comment