問題描述
我有一個關(guān)于 SQL Server 的 SQLXML 的問題.
I have a question in regards to the SQLXML for SQL Server.
我的任務(wù)是轉(zhuǎn)換一個 XSD 文件，使其神奇地成為"SQL Server 數(shù)據(jù)庫中的表.我到處環(huán)顧四周，在我可能找到的所有鏈接上，但沒有點擊.一切都像是我需要實現(xiàn)的半步.
My assignment is to convert an XSD file so that it magically "becomes" tables in the SQL Server database. I've looked around everywhere, on all the links I could possibly find, but nothing clicks. Everything is like a half-step of what I need to achieve.
我對 Visual Studio 不太熟悉，除了運行數(shù)據(jù)庫查詢和人們喜歡在 SQL Server 數(shù)據(jù)庫中做的所有事情之外，我沒有做太多其他事情.除了 XML.
I am not too familiar with Visual Studio, haven't done much else than running database queries and all the stuff one likes to do in a SQL Server database. Except for XML.
我認為 Microsoft 的 MSDN 中的 SQLXML 將是一個很好的工具(而且我相信它已經(jīng)安裝了).
I figured that SQLXML from Microsoft's MSDN would be a good tool to have (and I believe it's already installed).
任何提示或解決方案?
謝謝.
推薦答案
沒有魔法，因為它是家庭作業(yè)/學(xué)習(xí)，我不會詳細說明如何自己做，但是如果您將研究轉(zhuǎn)向 SQL 的批量加載功能它似乎正是您所需要的.
There's no magic involved, and as it's homework/study I won't detail how to do it myself, but if you direct your research towards SQL's Bulk Load functionality it would seem to be what you need.
閱讀此文章 以獲取簡要的操作方法"指南.
Read this article for a brief "how to" guide.
或者這篇文章如何使用它的詳細說明.
Or this article for a detailed description of how to use it.
這篇關(guān)于XSD 到 SQL Server 的轉(zhuǎn)換的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！