UFN_COUNTRY_GETVALIDATEAS
Returns the validation country code for the country with the given id.
Return
| Return Type |
|---|
| smallint |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @COUNTRYID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_COUNTRY_GETVALIDATEAS(@COUNTRYID As uniqueidentifier)
returns smallint
as begin
declare @r smallint
select @r=VALIDATIONCOUNTRYCODE from dbo.COUNTRYVALIDATIONINFO where ID = @COUNTRYID
if @r is null
select @r = 0
return @r
end