Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005
i have two table one for country and one for state
 
in country table
 
contryid-contry name
 
in state table
 
stateid--statename--countryid...
 
how it posiible plz give me insert query in state table
Posted 9-Jul-13 23:35pm
Comments
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
   
:D
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 295
1 DamithSL 265
2 CPallini 235
3 Maciej Los 190
4 Sergey Alexandrovich Kryukov 174
0 OriginalGriff 5,415
1 DamithSL 4,422
2 Maciej Los 3,820
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,911


Advertise | Privacy | Mobile
Web02 | 2.8.141216.1 | Last Updated 10 Jul 2013
Copyright © CodeProject, 1999-2014
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