If else query SQL

Question

I want to load some tables into my application but the only tables I want are the tables that have been updated.

I got in some of the databases I got an table called "Updated" but I don't have this table in every database in other databases I use the last 100 from the field ID.

What I want to do is an if/else statement where something like this happens:

IF EXISTS SELECT * FROM table1 WHERE column1 = updated 
ELSE SELECT TOP 100 table1 FROM column1 ORDER BY column1 DESC

I hope I made myself clear and hope you guys can help me.

Anant Dabhi · Accepted Answer · 2014-04-07 08:36:43Z

1

you cant start else condition into second line if you not use begin and and

IF EXISTS SELECT * FROM table1 WHERE column1 = updated 
BEGIN
-- logic
END


ELSE 
BEGIN
SELECT TOP 100 table1 FROM column1 ORDER BY column1 DESC    
END

for your above quety you can write direcly

IF NOT EXISTS SELECT * FROM table1 WHERE column1 = updated 
      SELECT TOP 100 table1 FROM column1 ORDER BY column1 DESC

edited Apr 7, 2014 at 8:36

answered Apr 7, 2014 at 8:30

Anant Dabhi

11.2k3 gold badges33 silver badges51 bronze badges

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

Comments

Indian · Accepted Answer · 2014-04-07 08:29:52Z

1

Your Sql-query is not correct. You should use somethine like this:

IF EXISTS (SELECT * FROM table1 WHERE column1 = updated)
SELECT * FROM table1 WHERE column1 = updated 
ELSE SELECT TOP 100 table1 FROM column1 ORDER BY column1 DESC

answered Apr 7, 2014 at 8:29

Indian

5432 gold badges12 silver badges25 bronze badges

Collectives™ on Stack Overflow

If else query SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related