SQL query IF statement in stored procedure

Question

What is the proper and efficient way of making the condition in the given query?

Yes it's working, but I want the query to be more efficient, example what if there's a lot of strings to be validated with @CORP.

ALTER PROCEDURE [dbo].[sp_EditProfile]
    @CORP AS VARCHAR(100)
AS
BEGIN
    IF((@CORP = 'something') OR (@CORP = 'somethingElse')) //CONDITION
    BEGIN
    END
END

krivtom · Accepted Answer · 2016-04-21 03:51:21Z

2

You can use IN statement, that will save you some characters of typing:

IF @CORP IN ('something', 'somethingElse')
BEGIN
    -- your code
END

answered Apr 21, 2016 at 3:51

krivtom

25k10 gold badges53 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

JC Borlagdan Over a year ago

oh, i thought this only works on where clause. Thanks!

Webeng Over a year ago

I'm new to most of sql, and would love to know what the '@' character is used for. Is it like the $ variable in php to create a variable (hence making @CORP a variable in SQL) or is it something completely different?

krivtom Over a year ago

@Webeng Yes, it is variable, and in SQL Server variables first character must be @. See technet.microsoft.com/en-us/library/ms187953(v=sql.105).aspx

Collectives™ on Stack Overflow

SQL query IF statement in stored procedure

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related