Re: IF THEN

[Tom]

I'm using conditional statements in a batch file in a cron job, the if..then..end if example I asked about was a simplified version of what I'm trying to achieve, which is more like if @a <> @b then do something (insert rows whatever) else do something else (delete rows whatever).

Kind of related: how do you achieve a check for rows in a table? In T-SQL this would be
IF EXISTS(SELECT * FROM TableA)
/* do something to the data */
ELSE
/* insert or something */