hi..

i'm new in this environment. need ur help guys.
can we use parameter to declare the select statement as below? i tried to run this but syntax error appear..

declare @countRecord int

set @countRecord = select count(*) from address_c,address_tmp where town=town_old

update address_tmp set count_new=@countRecord

thanks..