select state from cityMaster where city='CITYNAME' --or you can use id to retrieve state select state from cityMaster where ID='ID'
create procedure spGetCityDetails as begin select * from cityMaster end
create procedue GetCitiesBasedOnState (@state varchar(55)) as begin select * from cityMaster where [state] = @state end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)