UFN_MKTLIST_CODEISUNIQUE
Returns whether or not a code is unique among all lists.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CODE | nvarchar(10) | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTLIST_CODEISUNIQUE]
(
@CODE nvarchar(10)
)
returns bit
as
begin
if isnull(@CODE,'') = ''
return 1;
return (select case when exists(select top 1 1 from dbo.[MKTLIST] where [CODE] = @CODE) then 0 else 1 end);
end