I need a simple, efficient, safe sequence generator. Will this work? With no transaction?

Code:
...
Declare @foo as int

update seq set @foo=seq_val, seq_val=seq_val+1
  where seq_name = 'yowza'

select @foo
...
thanks