Click here to Skip to main content
13,093,184 members (80,673 online)
Rate this:
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 10-Jul-13 4:39am
hav u tried any code??
chimcham 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 10-Jul-13 4:41am
Raja Sekhar S 10-Jul-13 5:35am
What exactly do u want to insert..? Use the Improve Question Widget....
N Haque 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
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.170813.1 | Last Updated 10 Jul 2013
Copyright © CodeProject, 1999-2017
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