update AppLocation set SerializedString=(select cast(MemberID as varchar(40))+'|'+isnull(Address,'')+'|'+isnull(MapUrl,'')+'|'+isnull(Phone,'')+'|'+
isnull(FromTime,'')+'|'+isnull(ToTime,'')+'|'+cast(isnull(HavePark,'') as varchar(1))+'|'+isnull(Equipment,'')+
'|'+isnull(Remark,'')+'|'+cast(isnull(IsShared,'') as varchar(1)) +'|'+cast(isnull(CreateDate,'') as varchar(50))
from MemLocation where MemLocationID=@memLocationID
这里是把MemLocation 表中符合条件的数据放到一个字段中去。
同时这个主要cast函数的使用。格式:cast('字段名/数据' as type(数据类型)),这个函数是把对数据进行数据类型转换