code_junkie

SQL friend function

Nov 13th, 2011
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. CREATE TABLE (friend_id_a, friend_id_b, accepted)
  2.  
  3. INSERT
  4. INTO friend_friend(friend_id_a, friend_id_b)
  5. VALUES (LEAST(@id1, @id2), GREATEST(@id1, @id2))
  6.  
  7. SELECT friend_id_b
  8. FROM friend_friend
  9. WHERE friend_id_a = @id
  10. AND accepted
  11. UNION ALL
  12. SELECT friend_id_a
  13. FROM friend_friend
  14. WHERE friend_id_b = @id
  15. AND accepted
  16.  
  17. [dbo].[Users]{
  18. User_ID int,
  19. UserName VarChar,
  20. Password ...
  21. }
  22.  
  23. [dbo].[Friends]{
  24. User1_ID int,
  25. User2_ID int,
  26. Accepted bit
  27. }
Add Comment
Please, Sign In to add comment