USP_ZIPCITYSTATE_DELETERECORDS

Deletes records from the ZIPCITYSTATE table.

Parameters

Parameter	Parameter Type	Mode	Description
@COUNTRYID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_ZIPCITYSTATE_DELETERECORDS
            (
                @COUNTRYID uniqueidentifier = null
            )
            as
                set nocount on;

                if @COUNTRYID is null
                    delete from dbo.ZIPCITYSTATE;
                else
                    delete from dbo.ZIPCITYSTATE where COUNTRYID = @COUNTRYID;

                return 0;