Guest User

Untitled

a guest
Jun 22nd, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. SET ANSI_NULLS ON;
  2. DECLARE @1 INT;
  3. DECLARE @2 INT;
  4. DECLARE @3 INT;
  5. DECLARE @4 INT;
  6.  
  7. SET @1 = 1;
  8. SET @2 = NULL;
  9. SET @3 = 3;
  10. SET @4 = 3;
  11.  
  12. IF ((@1 <> @2) OR (@3 <> @4))
  13. BEGIN
  14. SELECT 1;
  15. END
  16. ELSE
  17. BEGIN
  18. SELECT 2;
  19. END
  20. SELECT @1, @2, @3, @4
  21.  
  22. 2
  23.  
  24. 1, NULL, 3, 3
  25.  
  26. 1
  27.  
  28. 1, NULL, 3, 3
  29.  
  30. IF ((ISNULL(@1, -1) <> ISNULL(@2, -1)) OR (ISNULL(@3, -1) <> ISNULL(@4, -1)))
  31. BEGIN
  32. SELECT 1;
  33. END
  34. ELSE
  35. BEGIN
  36. SELECT 2;
  37. END
  38.  
  39. IF ((@1 <> @2)
  40. OR (@1 is NULL AND @1 IS NOT NULL)
  41. OR (@1 is NOT NULL AND @1 IS NULL)
  42. OR (@3 <> @4)
  43. OR (@3 is NULL AND @4 IS NOT NULL)
  44. OR (@3 is NOT NULL AND @4 IS NULL))
  45.  
  46. IF ((IsNull(@1,-1) <> IsNull(@2,-1)
  47. OR (IsNull(@3,-1) <> IsNull(@4,-1))
  48.  
  49. SET @1 = IsNull(@1,-1);
  50.  
  51. IF (@1 IS NULL AND @2 IS NULL) OR (@1 = @2)
  52. BEGIN
  53. IF (@3 IS NULL AND @4 IS NULL) OR (@3 = @4)
  54. BEGIN
  55. SELECT 2
  56. END
  57. ELSE
  58. BEGIN
  59. SELECT 1
  60. END
  61. END
  62. ELSE
  63. BEGIN
  64. SELECT 1
  65. END
  66.  
  67. SET ANSI_NULLS ON;
  68. DECLARE @1 INT;
  69. DECLARE @2 INT;
  70. DECLARE @3 INT;
  71. DECLARE @4 INT;
  72. SET @1 = 1;
  73. SET @2 = NULL;
  74. SET @3 = 3;
  75. SET @4 = 3;
  76. IF ((@1 = @2) AND (@3 = @4))
  77. BEGIN SELECT 1;
  78. ENDELSE
  79. BEGIN SELECT 2;
  80. END
  81. SELECT @1, @2, @3, @4
Add Comment
Please, Sign In to add comment