摘要:Fun with the CRM StringMapEver wonder how (or where) CRM stores the related values for picklists? The answer is in the Stringmap table. Unfortunately, there's not a quick and easy method for looking at and comparing picklist values in CRM - you're pretty much stuck with the In this post, I&# 阅读全文
posted @ 2012-02-01 11:53 孙同海 阅读(342) 评论(0) 推荐(0) 编辑
摘要:1.FOR XML RAW 2.FOR XML AUTO3.FOR XML EXPLICIT4.更改显示Tag为中文5.同表 多层6.异表 多层7.处理数据及日期等的Null值==================数据库Person表中的数据为personName personAge lisi 30 zhangsan 30 1. ----------[ RAW ]---------SELECT [personName], [personAge] FROM [TestDB].[dbo].[person]FOR XML RAW结果:<row personName="lisi &quo 阅读全文
posted @ 2012-02-01 11:51 孙同海 阅读(201) 评论(0) 推荐(0) 编辑