create view getNewID as select newid() as new_id;
go