UFN_LOADSPECLOG_SPECHASBEENLOADED
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SPECID | uniqueidentifier | IN | |
| @SOURCENAME | nvarchar(255) | IN | |
| @ITEMNAME | nvarchar(255) | IN |
Definition
Copy
create function dbo.UFN_LOADSPECLOG_SPECHASBEENLOADED
(
@SPECID uniqueidentifier,
@SOURCENAME nvarchar(255),
@ITEMNAME nvarchar(255)
)
returns bit
as
begin
declare @b bit;
if exists
(select 1 from dbo.LOADSPECLOG where SPECID=@SPECID and LOADSOURCENAME=@SOURCENAME and LOADITEMNAME =@ITEMNAME)
set @b=1;
else
set @b=0;
return @b;
end