id为此使用合并:http ://msdn.microsoft.com/zh- cn/library/ms190349.aspx
update Person
set Car = coalesce(@Car, Car), HairColour = coalesce(@HairColour, HairColour)
SQL:仅当该列值为null时,如何才能更新该列上的值?
id为此使用合并:http ://msdn.microsoft.com/zh- cn/library/ms190349.aspx
update Person
set Car = coalesce(@Car, Car), HairColour = coalesce(@HairColour, HairColour)