1.添加外键
Alert table 表一 add constraint 外键名 foreign key(表一的列名)
references 表二(表二的列明)
on update cascade
on delete cascade;
2.更新字段的部分内容
update dbo.Knowledge set linkurl= replace(linkurl,'http:///knowlege/Article/2008-12-24/','http://.com/BK/WordInfo/') from dbo.Knowledge