Assigning a variable in T-SQL

Question

At the end of my function, I have a statement:

RETURN @Result

I want to do something like this:

IF (@Result = '')
BEGIN
@Result = 'Unknown'
END

RETURN @Result

The above doesn't work.

0

Xaisoft May 14 '09 at 23:08

6 answers

IF (@Result = '')
BEGIN
    SELECT @Result = 'Unknown'
END

RETURN @Result

Note that the assignment method in T-SQL is operator SELECT

. You can also use the operator SET

, although this is not recommended.

+2

yfeldblum May 14 '09 at 11:12 pm

change this line

@Result = 'Unknown'

to

set @Result = 'Unknown'

+2

Christian Hagelid May 14 '09 at 11:13 pm

I think you need to check if @result is NULL because NULL is not the same as ''

IF (ISNULL(@Result, '') = '')
BEGIN
    SET @Result = 'Unknown'
END

RETURN @Result

+1

Jon Erickson May 14 '09 at 11:25 pm

IF (@Result = '')

TO BEGIN

SET @Result = 'Unknown'

END

RETURN @Result

0

ManishVats 16 Aug 11 at 10:46

SET @Result = 'Unknown'

@Justice: According to Microsoft - MSDN SELECT @Result = 'Unknown'

is not recommended at all

0

Pellared Aug 31. 11 at 18:50

Robert Koritnik · Accepted Answer · 2009-05-14T23:11:44+0000

SET @Result = 'Unknown'

;)