Advertisement
Guest User

Untitled

a guest
Jul 29th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. CREATE FUNCTION [dbo].[Fn_GetTable]
  2. (@ID AS NVARCHAR(MAX))
  3. RETURNS
  4. @Tbl TABLE (ID NVARCHAR(MAX))
  5. AS
  6. BEGIN
  7. DECLARE @str AS NVARCHAR(MAX)
  8.  
  9. SET @str = 'SELECT * FROM support WHERE support IN ('+@ID+')'
  10.  
  11. INSERT INTO @Tbl (ID)
  12. EXEC sp_executesql @str
  13.  
  14. RETURN
  15. END
  16.  
  17. Create FUNCTION [dbo].[Fn_GetTable] (
  18. @ID as nvarchar(MAX)
  19. )
  20. RETURNS
  21. @Tbl TABLE (
  22. ID nvarchar(MAX)
  23. ) AS
  24. BEGIN
  25.  
  26. INSERT INTO @Tbl (ID)
  27. select *
  28. from support
  29. where support in (@ID)
  30.  
  31. RETURN
  32. END
  33.  
  34. CREATE TYPE dbo.UDT_IDS AS TABLE (ID NVARCHAR(MAX)) ;
  35.  
  36. CREATE FUNCTION [dbo].[Fn_GetTable] (
  37. @IDS as dbo.UDT_IDS READONLY
  38. )
  39. RETURNS
  40. @Tbl TABLE (
  41. ID NVARCHAR(MAX)
  42. ) AS
  43. BEGIN
  44.  
  45. INSERT INTO @Tbl (ID)
  46. SELECT support
  47. FROM support
  48. WHERE support in (SELECT ID FROM @IDS)
  49.  
  50. RETURN
  51. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement