populating variables from IF EXISTS statement

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

populating variables from IF EXISTS statement

Author

Topic

mike123
Master Smack Fu Yak Hacker

1462 Posts

Posted - 2008-11-15 : 17:36:59

Hi,

I'm running an IF EXISTS statement at the beginning of my query. I'm having errors and wondering if its just a syntax error ? I am declaring these variables for use in my code later..

Error:Incorrect syntax near '='.

any help appreciated!

thx again!
mike123

DECLARE @domainID int
DECLARE @partnerID int

IF EXISTS(SELECT @partnerID = partnerID, @domainID = domainID FROM [tblLinkSwap_TrackingDomains] WHERE domain = @referDomain)

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-16 : 04:39:50

Either

IF EXISTS(SELECT * FROM tblLinkSwap_TrackingDomains WHERE domain = @referDomain)
SELECT @partnerID = partnerID, @domainID = domainID FROM [tblLinkSwap_TrackingDomains WHERE domain = @referDomain

SELECT @partnerID = partnerID, @domainID = domainID FROM tblLinkSwap_TrackingDomains WHERE domain = @referDomain

IF @partnerID IS NULL 
...
ELSE
...

E 12°55'05.63"
N 56°04'39.26"

mike123
Master Smack Fu Yak Hacker

1462 Posts

Posted - 2008-11-17 : 03:45:50

perfect, thank you peso! :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources