http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FXML%2FXML_column SQL Server/T-SQL/XML/XML column - История изменений 2026-04-06T12:10:19Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=SQL_Server/T-SQL/XML/XML_column&diff=5738&oldid=prev в 13:46, 26 мая 2010 2010-05-26T13:46:06Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:46, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table> http://sqle.ru/index.php?title=SQL_Server/T-SQL/XML/XML_column&diff=5739&oldid=prev Admin: 1 версия 2010-05-26T10:20:15Z <p>1 версия</p> <p><b>Новая страница</b></p><div>==Declare XML type variable and use it in insert statement==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> 3&gt;<br /> 4&gt;<br /> 5&gt; CREATE TABLE dbo.Book(<br /> 6&gt; BookID int IDENTITY(1,1) PRIMARY KEY,<br /> 7&gt; ISBN char(10) NOT NULL,<br /> 8&gt; BookName varchar(250) NOT NULL,<br /> 9&gt; AuthorID int NOT NULL,<br /> 10&gt; ChapterDESC XML NULL)<br /> 11&gt; GO<br /> 1&gt; CREATE PROCEDURE dbo.usp_INS_Book<br /> 2&gt; @ISBN char(10),<br /> 3&gt; @BookName varchar(250),<br /> 4&gt; @AuthorID int,<br /> 5&gt; @ChapterDESC xml<br /> 6&gt; AS<br /> 7&gt; INSERT dbo.Book<br /> 8&gt; (ISBN, BookName, AuthorID, ChapterDESC)<br /> 9&gt; VALUES (@ISBN, @BookName, @AuthorID, @ChapterDESC)<br /> 10&gt; GO<br /> 1&gt; DECLARE @Book XML<br /> 2&gt; SET @Book =<br /> 3&gt; CAST(&quot;&lt;Book name=&quot;SQL Server&quot;&gt;<br /> 4~ &lt;Chapters&gt;<br /> 5~ &lt;Chapter id=&quot;1&quot;&gt; chapter 1 &lt;/Chapter&gt;<br /> 6~ &lt;Chapter id=&quot;2&quot;&gt; chapter 2 &lt;/Chapter&gt;<br /> 7~ &lt;Chapter id=&quot;3&quot;&gt; chapter 3 &lt;/Chapter&gt;<br /> 8~ &lt;Chapter id=&quot;4&quot;&gt; chapter 4 &lt;/Chapter&gt;<br /> 9~ &lt;/Chapters&gt;<br /> 10~ &lt;/Book&gt;&quot; as XML)<br /> 11&gt;<br /> 12&gt; INSERT dbo.Book<br /> 13&gt; (ISBN, BookName, AuthorID, ChapterDESC)<br /> 14&gt; VALUES (&quot;1111111&quot;,&quot;SQL Server&quot;,55,@Book)<br /> 15&gt; GO<br /> (1 rows affected)<br /> 1&gt; select * from dbo.book<br /> 2&gt; GO<br /> BookID ISBN BookName<br /> AuthorID ChapterDESC<br /> <br /> ----------- ---------- -------------------------------------------------------------------------------------------------<br /> ------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------- ----------- --------------------------------------------------------------------------<br /> ------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------<br /> 1 1111111 SQL Server<br /> 55 &lt;Book name=&quot;SQL Server&quot;&gt;&lt;Chapters&gt;&lt;Chapter id=&quot;1&quot;&gt; chapter 1 &lt;/Chapter&gt;&lt;Ch<br /> apter id=&quot;2&quot;&gt; chapter 2 &lt;/Chapter&gt;&lt;Chapter id=&quot;3&quot;&gt; chapter 3 &lt;/Chapter&gt;&lt;Chapter id=&quot;4&quot;&gt; chapter 4 &lt;/Chapter&gt;&lt;/Chapters&gt;&lt;<br /> /Book&gt;<br /> (1 rows affected)<br /> 1&gt;<br /> 2&gt; drop table dbo.book<br /> 3&gt; GO<br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==XML type column==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> <br /> 3&gt; Create table dbo.Eq2(<br /> 4&gt; EqId int,<br /> 5&gt; EqCompList xml)<br /> 6&gt; GO<br /> 1&gt;<br /> 2&gt;<br /> 3&gt; drop table dbo.Eq2 ;<br /> 4&gt; GO<br /> 1&gt;<br /> 2&gt;<br /> 3&gt;<br /> &lt;/source&gt;</div> Admin