Coder Baba
前往频道在 Telegram
Everything about programming for beginners. 1 and only official telegram channel of CODERBABA India. Content: .NET Developer, Programming (ASP. NET, VB. NET, C#, SQL Server), & Projects follow me https://linktr.ee/coderbaba *Programming *Coding *Note
显示更多2 183
订阅者
-124 小时
-87 天
-1730 天
帖子存档
2 183
Create Table tblCountry
(
CountryId Int Primary Key,
County Varchar(30)
)
Create Table tblcountryState
(
StateId Int Primary Key,
CountryId Int Foreign Key References tblCountry(CountryId),
State Varchar(30)
)
Create Table tblstateCity
(
CityId Int,
StateId Int Foreign Key References tblcountryState(StateId),
City Varchar(30)
)
-------------------------------
Insert Into tblCountry Values(101,'India')
Insert Into tblCountry Values(102,'USA')
Insert Into tblCountry Values(103,'Pakistan')
Insert Into tblcountryState Values(1001,101,'U.P')
Insert Into tblcountryState Values(1002,101,'Kerala')
Insert Into tblcountryState Values(1003,101,'Kasmir')
Insert Into tblcountryState Values(2001,102,'Colorado')
Insert Into tblcountryState Values(2002,102,'Delaware')
Insert Into tblcountryState Values(2003,102,'Georgia')
Insert Into tblcountryState Values(3001,103,'Punjap')
Insert Into tblcountryState Values(3002,103,'Baluchistan')
Insert Into tblcountryState Values(3003,103,'Sind')
Insert Into tblstateCity Values(11,1001,'Kanpur')
Insert Into tblstateCity Values(12,1001,'Varanasi')
Insert Into tblstateCity Values(21,1002,'Kochi')
Insert Into tblstateCity Values(22,1002,' Thiruvananthapuram ')
Insert Into tblstateCity Values(31,1003,'Jammu')
Insert Into tblstateCity Values(32,1003,'Manali')
Insert Into tblstateCity Values(41,2001,'Alabama')
Insert Into tblstateCity Values(42,2001,'Arizona')
Insert Into tblstateCity Values(51,2002,'Bellefonte')
Insert Into tblstateCity Values(52,2002,'Felton')
Insert Into tblstateCity Values(61,2003,'Rustavi')
Insert Into tblstateCity Values(62,2003,'Kobulati')
Insert Into tblstateCity Values(71,3001,'Lahore')
Insert Into tblstateCity Values(72,3001,'Faisalabad')
Insert Into tblstateCity Values(81,3002,'Quetta')
Insert Into tblstateCity Values(82,3002,'Nasirabad')
Insert Into tblstateCity Values(91,3003,'Krachi')
Insert Into tblstateCity Values(92,3003,'Mirpur khas')
select * from tblCountry
select * from tblcountryState
select * from tblstateCity
