Error in using IF EXISTS in SQL Server 2005

Question

This is my query, but I am getting an error. Please help how to do it

declare @spid varchar(20)

if exists ((select @spid = Sponsor_Id  from UserTransaction)  where User_id= 'RL0814')
   insert into UserTransaction(Sponsor_Id, User_Id) 
   values (@spid,'RL4108')

The error is:

Incorrect syntax near '='

marc_s · Accepted Answer · 2014-10-06 11:02:13Z

1

Try this instead:

DECLARE @spid VARCHAR(20)
SET @spid = NULL

SELECT @spid = Sponsor_Id 
FROM dbo.UserTransaction 
WHERE User_id = 'RL0814'

IF @spid IS NOT NULL
   INSERT INTO dbo.UserTransaction(Sponsor_Id, User_Id) 
   VALUES (@spid, 'RL4108')

edited Oct 6, 2014 at 11:02

answered Oct 6, 2014 at 9:31

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

4 Comments

Sumedha Vangury Over a year ago

I need to store the result of the select statement in a variable,@spid, and then insert

marc_s Over a year ago

@sumedha: OK, changed my response to meet your needs - in that case, just SELECT that value, and if it's NULL, then it doesn't exist, so you cannot insert. If it's NOT NULL, you can insert

Sumedha Vangury Over a year ago

Thanks,but is there no way I can use if exists..doing the same?

marc_s Over a year ago

@sumedha: no, if you need to actually get the value, you cannot use IF EXISTS

Collectives™ on Stack Overflow

Error in using IF EXISTS in SQL Server 2005

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related