Stored Procedure Nested If else

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hi Frnds,
I have three tables with city,State,Country.In one Stored Procedure i need to insert,update ,select three table values.For that i need nested if Stored Procedure Flow.
for eg.: i am passing all my values from C# pages to stored procedure...
id,name,type(city,state,country),process(insert,select,update)
if i pass value as City.First i need to check whether that city name is already exist or not.after that if not exist i need to save,other wise i need to pass value to C# page as "Already Exist"...Same thing have to be do for State,Country

Posted 3-Dec-12 3:27am

itsureshuk

Add a Solution

Comments

Patel Shailendra 3-Dec-12 10:51am

how many columns in your table id and name or more what's the purpose of city,state,country if is cascading then use separate table for city,state and country

or

you have to store in this table your client info then also create three table and make cascading relationship between them and store id of city,state,country in user table

itsureshuk 4-Dec-12 0:06am

i have three tables(city state country)...I need one stored procedure ,if i am going to insert city details, i have to check, whether same city name is already exist, if not exist have to insert,otherwise if exist have to return a value 10 or anything...so that i can show message as already exist in User form

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)

sisir patro · Answer 1 · 2012-12-12T08:24:00

HI,

Tou can try like this.

SQL

IF EXISTS(select * from city where Name = 'abc')
{
     return "already exists";
}
ELSE
{
    IF(status = "update")
    { //write your update code here...}
    ELSE IF(status = "insert")
    {  //Write your insert query here...}
    ELSE
    { //select query...}

}

Thanks