use pubs
set nocount on

--create a table with a derived column
create table junk (i int primary key, derivedCol as i+1)
go
insert junk (i) values (1)
select * from junk

go
--create a table with a nullable foreign key
create table junk2 (rowid int identity(1,1), i int null references junk(i))
go
insert junk2 (i) values (null)
insert junk2 (i) values (1)
go

select i, derivedCol, derivedCol-i as derivedResultSetColumn from junk
select rowid, i from junk2
go
drop table junk2
drop table junk