please provide india districts List in ms SQl server 2008r2

Question

india districts List in ms SQl server 2008r2

Dharmraj Thakur · Answer

Run this query... CREATE TABLE dbo.States ( ID int primary key identity(1,1), StateName varchar (50), Remarks nvarchar( max ), ); insert into States (StateName) values ( 'West Bengal' ); insert into States (StateName) values ( 'Uttarakhand' ); insert into States (StateName) values ( 'Uttar Pradesh' ); insert into States (StateName) values ( 'Tripura' ); insert into States (StateName) values ( 'Telangana' ); insert into States (StateName) values ( 'Tamil Nadu' ); insert into States (StateName) values ( 'Sikkim' ); insert into States (StateName) values ( 'Rajasthan' ); insert into States (StateName) values ( 'Punjab' ); insert into States (StateName) values ( 'Puducherry' ); insert into States (StateName) values ( 'Odisha' ); insert into States (StateName) values ( 'NCT Delhi' ); insert into States (StateName) values ( 'Nagaland' ); insert into States (StateName) values ( 'Mizoram' ); insert into States (StateName) values ( 'Meghalaya' ); insert into States (StateName) values ( 'Manipur' ); insert into States (StateName) values ( 'Maharashtra' ); insert into States (StateName) values ( 'Madhya Pradesh' ); insert into States (StateName) values ( 'Lakshadweep ' ); insert into States (StateName) values ( 'Kerala' ); insert into States (StateName) values ( 'Karnataka' ); insert into States (StateName) values ( 'Jharkhand' ); insert into States (StateName) values ( 'Jammu and Kashmir' ); insert into States (StateName) values ( 'Himachal Pradesh' ); insert into States (StateName) values ( 'Haryana' ); insert into States (StateName) values ( 'Gujarat' ); insert into States (StateName) values ( 'Goa' ); insert into States (StateName) values ( 'Daman and Diu' ); insert into States (StateName) values ( 'Dadra and Nagar Haveli' ); insert into States (StateName) values ( 'Chhattisgarh' ); insert into States (StateName) values ( 'Chandigarh' ); insert into States (StateName) values ( 'Bihar' ); insert into States (StateName) values ( 'Assam' ); insert into States (StateName) values ( 'Arunachal Pradesh' ); insert into States (StateName) values ( 'Andhra Pradesh' ); insert into States (StateName) values ( 'Andaman and Nicobar' ); insert into States (StateName) values ( 'Total' );

Amit Kumar · Answer

Hi, Please download from bleow links. http://mkj.co.in/wp-content/uploads/2012/12/indian-districts-database.zip http://www.programmingwall.com/technology/india-state-city-district-database/ http://dolr.nic.in/hyperlink/distlistnew.htm http://www.informationhubindia.com/total-state-in-india/1144_total-districts-in-india.html Regards, Amit