Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION [dbo].[Fn_GetTable]
- (@ID AS NVARCHAR(MAX))
- RETURNS
- @Tbl TABLE (ID NVARCHAR(MAX))
- AS
- BEGIN
- DECLARE @str AS NVARCHAR(MAX)
- SET @str = 'SELECT * FROM support WHERE support IN ('+@ID+')'
- INSERT INTO @Tbl (ID)
- EXEC sp_executesql @str
- RETURN
- END
- Create FUNCTION [dbo].[Fn_GetTable] (
- @ID as nvarchar(MAX)
- )
- RETURNS
- @Tbl TABLE (
- ID nvarchar(MAX)
- ) AS
- BEGIN
- INSERT INTO @Tbl (ID)
- select *
- from support
- where support in (@ID)
- RETURN
- END
- CREATE TYPE dbo.UDT_IDS AS TABLE (ID NVARCHAR(MAX)) ;
- CREATE FUNCTION [dbo].[Fn_GetTable] (
- @IDS as dbo.UDT_IDS READONLY
- )
- RETURNS
- @Tbl TABLE (
- ID NVARCHAR(MAX)
- ) AS
- BEGIN
- INSERT INTO @Tbl (ID)
- SELECT support
- FROM support
- WHERE support in (SELECT ID FROM @IDS)
- RETURN
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement