您好，我有下表数据需要在SQlServer中转换为Xml。有什么想法吗？提前致谢来自Party_IdHomePhoneNumberWorkPhoneNumber623566314993578623566314590922623566313795488到631499357863145909226313795488 最佳答案 将空值转换为NULL。这些NULL值将从XML中排除。Declare@YourTabletable(Party_Idint,HomePhoneNumbervarchar(25),WorkPhoneNumbervar