Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. CREATE FUNCTION dbo.test5(@i int)
  2. RETURNS INT
  3. AS
  4. BEGIN
  5. RETURN(
  6. SELECT TOP 1
  7. CASE
  8. WHEN @i = 1 THEN 1
  9. WHEN @i = 2 THEN 2
  10. WHEN @i = 3 THEN dbo.test5(1) + dbo.test5(2)
  11. END
  12. );
  13.  
  14. SELECT dbo.test5(3);
  15.  
  16. (No column name)
  17. 3
  18.  
  19. CREATE FUNCTION dbo.test6(@i int)
  20. RETURNS INT
  21. AS
  22. BEGIN
  23. RETURN(
  24. SELECT TOP 1
  25. CASE
  26. WHEN @i = 1 THEN 1
  27. WHEN @i = 2 THEN 2
  28. WHEN @i = 3 THEN (SELECT dbo.test6(1) + dbo.test6(2))
  29. END
  30. )END;
  31.  
  32. SELECT dbo.test6(3);
  33.  
  34. SELECT dbo.test6(2);
  35.  
  36. <ColumnReference Column="Expr1002" />
  37. <ScalarOperator ScalarString="CASE WHEN [@i]=(1) THEN (1) ELSE CASE WHEN [@i]=(2) THEN (2) ELSE CASE WHEN [@i]=(3) THEN [Expr1000] ELSE NULL END END END">
  38.  
  39. <ColumnReference Column="Expr1000" />
  40. <ScalarOperator ScalarString="[dbo].[test6]((1))+[dbo].[test6]((2))">
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement