2> CREATE TABLE dbo.Contacts
3> (
4> contactid INT NOT NULL PRIMARY KEY,
5> contactname NVARCHAR(50) NOT NULL,
6> I18N BIT NOT NULL,
7> otherattributes XML NOT NULL
8> );
9> GO
1>
2>
2> INSERT INTO dbo.Contacts VALUES(1, 'Mike', 1, N'<I18N xmlns="I18N"><ID>1</ID><FL>S</FL></I18N>');
3> INSERT INTO dbo.Contacts VALUES(2, 'Her', 0, N'<Foreigns xmlns="Foreign"><NL>German</NL><ENG>1</ENG></Foreigns>');
4> INSERT INTO dbo.Contacts VALUES(3, N'Richard', 1, N'<I18N xmlns="I18N"><ID>2</ID><FL>German</FL></I18N>');
5> INSERT INTO dbo.Contacts VALUES(4, N'Gianluca', 0, N'<Foreigns xmlns="Foreign"><NL>Italian</NL><ENG>1</ENG></Foreigns>');
6> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
1>
2> drop table dbo.Contacts;
3> GO
|