UFN_SELECTIONHELPER_BUILDIDSELECTSQL
Return
| Return Type |
|---|
| nvarchar(max) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SELECTIONID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_SELECTIONHELPER_BUILDIDSELECTSQL]
(
@SELECTIONID uniqueidentifier
)
returns nvarchar(max)
as
begin
declare @DBOBJECTNAME nvarchar(255);
declare @SQL nvarchar(max);
select
@DBOBJECTNAME = quotename([DBOBJECTNAME]) + (case [OBJECTTYPE] when 1 then '()' when 2 then '(''' + convert(nvarchar(36), [ID]) + ''')' else '' end)
from dbo.[IDSETREGISTER]
where [ID] = @SELECTIONID;
if @DBOBJECTNAME is not null
set @SQL = 'select [SELECTION].[ID] from dbo.' + @DBOBJECTNAME + ' as [SELECTION]';
return @SQL;
end