Advertisement
Guest User

Untitled

a guest
Dec 12th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.15 KB | None | 0 0
  1. CREATE PROCEDURE ConversatieInsertion
  2. AS
  3. BEGIN
  4. SET NOCOUNT ON;
  5. declare @nume VARCHAR(50);
  6. declare @id INT;
  7. SET @id = (SELECT TOP 1 MAX(Conversatie.Cid) FROM Conversatie);
  8. SET @nume = CONCAT('Conversatia', (SELECT CAST(@id as varchar(50))));
  9. if @id is NULL
  10. set @id = 0;
  11. INSERT INTO Conversatie(Cid, NumeConversatie)
  12. VALUES(@id+1, @nume);
  13. END
  14.  
  15. ALTER PROCEDURE ChatInsertion
  16. AS
  17. BEGIN
  18. SET NOCOUNT ON;
  19. declare @Cid int;
  20. declare @Uid int;
  21. declare @NumarMesaje int;
  22. SET @Cid = (SELECT TOP 1 MAX(dbo.Conversatie.Cid) FROM
  23. Conversatie);
  24. SET @Uid = (SELECT TOP 1 MAX (dbo.Utilizator.Uid) FROM
  25. Utilizator);
  26. SET @NumarMesaje = (SELECT RAND()*100);
  27. INSERT INTO Chat(Cid, Uid, NumarMesaje) VALUES
  28. (@Cid+1, @Uid+1, @NumarMesaje);
  29. END
  30.  
  31. ALTER PROCEDURE PozaInsertion
  32. AS
  33. BEGIN
  34. SET NOCOUNT ON;
  35. declare @pid INT;
  36. SET @pid = (SELECT TOP 1 MAX(Poza.Pid) FROM Poza);
  37. declare @dataPoza DATE;
  38. SET @dataPoza = '2019-10-10';
  39. declare @NumarLike INT;
  40. declare @NumarLove INT;
  41. declare @NumarAngry INT;
  42. declare @NumarHaha INT;
  43. declare @NumarSad INT;
  44. declare @Uid INT;
  45. SET @NumarLike= (SELECT RAND()*100);
  46. SET @NumarLove= (SELECT RAND()*100);
  47. SET @NumarAngry= (SELECT RAND()*100);
  48. SET @NumarHaha= (SELECT RAND()*100);
  49. SET @NumarSad= (SELECT RAND()*100);
  50. SET @Uid = (SELECT TOP 1 MAX (dbo.Utilizator.Uid) FROM
  51. Utilizator);
  52. INSERT INTO Poza(Pid, DataPoza, NumarLike, NumarLove,
  53. NumarAngry, NumarHaha, NumarSad, Uid) VALUES
  54. (@pid, @dataPoza, @NumarLike, @NumarLove, @NumarAngry,
  55. @NumarHaha, @NumarSad, @Uid);
  56.  
  57. END
  58.  
  59. CREATE PROCEDURE ConversatieDelete
  60. AS
  61. BEGIN
  62. SET NOCOUNT ON;
  63. DELETE from Conversatie;
  64. END
  65.  
  66. CREATE PROCEDURE ChatDelete
  67. AS
  68. BEGIN
  69. SET NOCOUNT ON;
  70. EXEC ConversatieDelete;
  71. Delete from Utilizator;
  72. Delete from Chat;
  73. END
  74.  
  75. CREATE PROCEDURE PozaDelete
  76. AS
  77. BEGIN
  78. SET NOCOUNT ON;
  79. Delete from Utilizator;
  80. Delete from Poza;
  81. END
  82.  
  83. select * from Tables
  84. select * from TestTables
  85. select * from Tests
  86. select * from Views
  87. DROP PROCEDURE ConversatieInsertion
  88. DROP PROCEDURE ChatInsertion
  89. DROP PROCEDURE PozaInsertion
  90. DROP PROCEDURE ConversatieDelete
  91. DROP PROCEDURE ChatDelete
  92. DROP PROCEDURE PozaDelete
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement