Guest User

Untitled

a guest
Jul 21st, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. CREATE PROCEDURE ReceiveChat
  2. @Sender INT,
  3. @Receiver INT,
  4. @ChatID INT,
  5. @SenderMessage NVARCHAR(80)
  6. AS
  7. BEGIN
  8. SELECT [dbo].[Chats].*
  9. FROM [dbo].[Chats]
  10. WHERE ([Sender] = @Sender) AND ([Receiver] = @Receiver)
  11. AND ([Chat_ID] = @ChatID)
  12.  
  13. INSERT INTO [dbo].[Chats] (Chat)
  14. VALUES (@SenderMessage)
  15. END
  16.  
  17. EXEC ReceiveChat 1, 2, 8, 'hello my friend'
  18.  
  19. Chat_ID - Sender -Receiver -Chat_Time - Chat :
  20. 9 - 1 - 2 - 2018-07-20 15:58 - hello my friend ?
Add Comment
Please, Sign In to add comment