USP_COUNTRY_GETLABELS
Return countries with their customizable address labels.
Definition
Copy
create procedure dbo.USP_COUNTRY_GETLABELS
as begin
set nocount on;
begin try
select
COUNTRYID as ID,
ADDRESSLABEL as ADDRESSCAPTION,
CITYLABEL as CITYCAPTION,
REGIONLABEL as STATECAPTION,
POSTCODELABEL as POSTCODECAPTION,
DPCLABEL as DPCCAPTION,
CARTLABEL as CARTCAPTION,
LOTLABEL as LOTCAPTION,
COUNTYLABEL as COUNTYCAPTION,
CONGRESSIONALDISTRICTLABEL as CONGRESSIONALDISTRICTCAPTION,
STATEHOUSEDISTRICTLABEL as STATEHOUSEDISTRICTCAPTION,
STATESENATEDISTRICTLABEL as STATESENATEDISTRICTCAPTION,
LOCALPRECINCTLABEL as LOCALPRECINCTCAPTION
from dbo.COUNTRYADDRESSLABEL;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;
end