Assigning A Variable A Number Value

[FontanaS]

I have a variable called @TimesRan that is defined as a Int.
Inside the stored procedure I want to assign that variable the value of 1


like:
@TimesRan = 1

but i keep getting errors.
what is the correct syntax?

thanks

 

[foxdev]

Either of the following:

[tt]set @TimesRan = 1
select @TimesRan = 1[/tt] Robert Bradley
Support operation moo!
Visit the OpCow page

http://www.agrainofhope.org/opcow.shtml

to help in this cause