How to Set Task When You Select Null

Question

0.00/5 (No votes)

See more:

Hi guys, i have a problem here, pseudo code goes like this

IF (SELECT COLUMN FROM TABLENAME WHERE ID=SOMETHING) = NULL THEN
DO THIS

CAN ANYONE GIVE ME A SAMPLE CODE ON STORED PROCEDURES,
I DONT HAVE GOOGLE :)
THANK YOU IN ADVANCE

Posted 12-Jan-14 16:59pm

Goenitz

Add a Solution

2 solutions

Solution 1

Quote:
I DONT HAVE GOOGLE Smile :)

Take it https://www.google.com[^].

And for Stored Procedures - sql + stored procedure[^].

[Update]

Take a look at the below resources.
1. Overview of SQL Server Stored Procedure[^]
2. what is stored procedure in Sql server | what are the advantages of using stored procedures in sql server[^]
3. Stored procedure[^]

Posted 12-Jan-14 17:17pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Updated 12-Jan-14 18:51pm

v2

Comments

Goenitz 13-Jan-14 0:10am

The proxy server is refusing connections :), i just need an example because i dont know the syntax and all i have is code project lol

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Jan-14 0:29am

Okay, no worries. :)

Take a look at the below resources.
1. Overview of SQL Server Stored Procedure[^]
2. what is stored procedure in Sql server | what are the advantages of using stored procedures in sql server[^]
3. Stored procedure[^]

Please accept this answer, if it has helped you in any way.
This will help others to find the answer in one go and you will also be awarded with some points for this action...

Thanks,
Tadit

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)

Goenitz · Accepted Answer · 2014-01-12T19:10:00

Solution 2

this is WORKING :)

<pre lang="sql">
SET @var1 = SELECT COLUMN FROM TABLENAME
SET @var2 = SELECT COLUMN FROM TABLENAME

IF @var1 IS NOT NULL AND @var2 IS NOT NULL
        BEGIN
            DO THIS
            END

Posted 12-Jan-14 19:10pm

Goenitz

Updated 12-Jan-14 19:12pm

v2

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Jan-14 1:23am

Adding an answer is not a problem. But explaining nothing about the question and answer is not a good habit.

Either explain clearly what was the problem and how you resolved it or just check my answer Solution 1, which is answered as per your comments.

Thanks,
Tadit

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 16-Jan-14 4:15am

I guess you rejected my answer after accepting it by mistake. In that case, please accept it again.

Thanks,
Tadit