UFN_STATE_GETID
Returns the ID of a state given it's description.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @COUNTRYID | uniqueidentifier | IN | |
| @DESCRIPTION | nvarchar(100) | IN | |
| @USEABBREVIATION | bit | IN |
Definition
Copy
create function dbo.UFN_STATE_GETID(@COUNTRYID uniqueidentifier, @DESCRIPTION nvarchar(100), @USEABBREVIATION bit)
returns uniqueidentifier
with execute as caller
as begin
declare @r uniqueidentifier
if @USEABBREVIATION=0
select @r=ID from dbo.STATE where (COUNTRYID = @COUNTRYID) and (DESCRIPTION = @DESCRIPTION)
else
select @r=ID from dbo.STATE where (COUNTRYID = @COUNTRYID) and (ABBREVIATION = @DESCRIPTION)
return @r
end