Hi,

Remember SEAT for testing.

Table A

(

Column1 varchar(4),

Column2 int

)

Setup

Select a row of data to be updated.

eg

Select Column1, Column2 from A where Column1 Is Null

Evaluate

Run the test/code

Insert into A_Changes

Select Column1, Column2 from A where Column1 Is Null

go

Update A Set Column1 = 'TEST' where Column1 Is Null

Assert

Select *

from A

inner join A_Changes

on Column2 = Column2

Tear down (Clean up)

Drop table A_Changes

Cheers

Jamie