UFN_OLAPDATASOURCE_DATAMART_IS_REGISTERED
Returns 1 if the given OLAPDATASOURCEID is registered in the dbo.OLAPDATASOURCE table.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @OLAPDATASOURCEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_OLAPDATASOURCE_DATAMART_IS_REGISTERED(@OLAPDATASOURCEID uniqueidentifier)
returns bit
/*
Returns 1 if the given OLAPDATASOURCEID is registered in the dbo.OLAPDATASOURCE table.
*/
as begin
IF OBJECT_ID(N'dbo.OLAPDATASOURCE', N'U') IS NULL
return 0;
declare @b bit;
set @b=0;
select @b = 1 from dbo.OLAPDATASOURCE WHERE ID = @OLAPDATASOURCEID;
return @b;
end