Adi Cohn-120898 (7/8/2013)

---

Hi all

Pleas check out the code bellow:

declare @tbl table (i int)

declare @i int

insert into @tbl (i) values (1)

update @tbl

set @i = i, i = 2

select @i as varible, i from @tbl

This code stores the column's old value in a variable and then modifies the column's value. I know that code like that has been working for years, but I don't know if it is something that could be modified in the future. If an application has this kind of code, could it break with the next service pack or next SQL Server version or is this kind of code something that should always work?

Adi