please provide india districts List in ms SQl server 2008r2

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');

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dharmraj Thakur8y ago
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');
0
Amit Kumar8y ago
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
0