摘要：
So you want to spit out some XML from SQL Server into a file, how can you do that? There are a couple of ways, I will show you how you can do it with SSIS. In the SSIS package you need an Execute SQL Task and a Script Task.Let's get startedFirst create and populate these two tables in your datab 阅读全文
摘要：
Declare @xmlDoc xmlSET @xmlDoc = (SELECT * FROM USERS AS UserTable For XML AUTO, ELEMENTS, ROOT('Root'))SELECT @xmlDocResult as below : 1 Admin admin 49CE5FB6D05148ACB66A Administrator 0 1 2013-07-10T13:40:48.470 2 cshsvc cshsvc 54C0FCD2B54CCE8BE6AD Administrator 0 1 2013-07-10T13:38:2... 阅读全文