Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
 Posted - 2012-09-14 : 15:20:31
|
| What is the first column type? what is it call? i need to do a research adn find out more about it.looks like a xml data type. but it has extra stuffs.CREATE TABLE [dbo].table( [Site] [xml](CONTENT [dbo].[SiteSchema]) NULL, [IsOnline] [bit] NULL, [IsPrivate] [bit] NULL) |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-09-14 : 15:27:29
|
| It is a typed XML Column. -Chad |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-16 : 01:28:33
|
| SQL Server Books Online has some good information - about handling the XML data typeJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-16 : 12:27:35
|
| [dbo].[SiteSchema] will represent schema definition for Site xml column------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
column data type