Click here to Skip to main content
11,805,316 members (66,278 online)
Rate this: bad
Please Sign up or sign in to vote.
i have two table one for country and one for state

in country table

contryid-contry name

in state table


how it posiible plz give me insert query in state table
Posted 9-Jul-13 22:35pm
kesav prakash at 10-Jul-13 4:39am
hav u tried any code??
chimcham at 10-Jul-13 4:40am
I don't understand what's your question. Can you please explain it further and the details of your problem.
timmit18 at 10-Jul-13 4:41am
Raja Sekhar S at 10-Jul-13 5:35am
What exactly do u want to insert..? Use the Improve Question Widget....
N Haque at 11-Jul-13 7:00am
If you have stateid--statename and countryid then no need to join any where to insert your data. Just write insert statement. If you don't have countryid but have country_name then you need select query to select countryid. Please clarify you question.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 3,265
1 Maciej Los 1,990
2 KrunalRohit 1,907
3 CPallini 1,855
4 Richard MacCutchan 1,227

Advertise | Privacy | Mobile
Web03 | 2.8.151002.1 | Last Updated 10 Jul 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100