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'1S');
3> INSERT INTO dbo.Contacts VALUES(2, 'Her', 0, N'German1');
4> INSERT INTO dbo.Contacts VALUES(3, N'Richard', 1, N'2German');
5> INSERT INTO dbo.Contacts VALUES(4, N'Gianluca', 0, N'Italian1');
6> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
(1 rows affected)
1>
2> drop table dbo.Contacts;
3> GO