If/else

[pscassidy]

hi,

I get:

Incorrect syntax near 'then'

when i run the following:

Alter Procedure intranet_property_list

@orderby1 varchar(20),
@orderby1_direction varchar(4),
@orderby2 varchar(20),
@orderby2_direction varchar(4)

As
declare @sql varchar(100)
if @orderby1=@orderby2 then @sql="test"
select ref,county,estate_agent,short_description,price_punt,feature,no_bedrooms,category,address1
from properties
order by ref desc
return

 

[Cagliostro]

when i run the following:

Alter Procedure intranet_property_list

@orderby1 varchar(20),
@orderby1_direction varchar(4),
@orderby2 varchar(20),
@orderby2_direction varchar(4)

As
declare @sql varchar(100)
if @orderby1=@orderby2 then set @sql="test"
select ref,county,estate_agent,short_description,price_punt,feature,no_bedrooms,category,address1
from properties
order by ref desc
return

Ion Filipski

filipski@excite.com

 

[tlbroadbent]

You can omit "THEN" in T-SQL. If you want to execute multiple statements when the IF condition is true, you need to use BEGIN... END to create a block of statements as illustrated below.

IF @var=1
Begin
Update table1 set col1='DONE' WHERE ID=@ID
Exec CreateInventoryTransaction @ID, @Part, @Stat
End
Else
Begin
Print 'No Transactions to process'
End Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.