Timesheet数据库变更V1.5.docxVIP

Timesheet数据库变更V1.5 Contact 原字段 现字段 备注 ID ID FirstName FirstName LastName LastName NickName NickName Gender Gender SystemLogin 新增(原先在employee表中) EmailAddress1 EmailAddress1 AddressID 移除(至Employee表) JointDate 新增 Active Active Created Created Updated 新增 相应脚本： alter table Contact add SystemLogin varchar(256) alter table Contact add Updated Datetime alter table Contact add JointDate Datetime --employee的systemlogin迁移到contact declare @id varchar(50) declare @systemlogin varchar(50) declare myCusor cursor for select id,SystemLogin from contact OPEN myCusor fetch NEXT from myCusor into @id,@systemlogi