stored procedure for delete country and according to it delete cities

Question

1.00/5 (2 votes)

See more:

Hello,
Provide me stored procedure for when i delete country then its associated city will be deleted.
Please provide me stored procedure completely.

Posted 19-May-11 23:53pm

Member 7894537

Updated 20-May-11 0:16am

Tarun.K.S

v4

Add a Solution

Comments

Rob Branaghan 20-May-11 6:08am

What is the structure of your table?
Are Countries in a seperate table to City?
Try and explain to us as if we have never heard of the project you are working on.... Because we havent.

Are you really sure you want to delete them as well, surely flagging as deleted is a little less final!

To get assistance here you need to give us more information than that.

[no name] 20-May-11 6:23am

Please provide the specific information about your table design, then only we can help on this.

Member 7894537 20-May-11 7:01am

let there are three table one for country , one for state and one for city .
admin has facility to add country state and city.
ok let admin add country india . and by another form add state Madhya pradesh, maharasht and others.
if admin delete country(parentroot) india then state(childroot) Madhya pradesh, maharasht and others also be deleted.
provide me stored procedure for it.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Ramalinga Koushik · Answer 1 · 2011-05-20T00:22:00

Solution 1

We are here to guide you not to do your Homewrok.

Hope this[^] might help you. Based on that please write your stored procedure as per your requirement.

Posted 20-May-11 0:22am

Ramalinga Koushik