SSMSE problem to create manually XML data in a XML field


hi,
i have problem using sql server management studio express.
when browse query/table xml type column cannot create manualy xml field.
is possible using built-in xml editor ?

i make following steps:
1. use adventureworks example database
2. create new query on person.contact table
------------------------------------------------------------------
select     contactid, title, firstname, additionalcontactinfo
from         person.contact
------------------------------------------------------------------
3. execute query
4. then  : first 10 records contain xml data  in additionalcontactinfo field
5. cannot insert manualy new xml data record 11,12 e.t.c

i thing possible built-in xml editor,  how ?

is possible change such field using ms access version 2002 ?

thanks in advance !



SQL Server  >  SQL Server Tools



Comments

Popular posts from this blog

Motherboard replacement

Cannot create Full Text Search catalog after upgrading to V12 - Database is not fully started up or it is not in an ONLINE state

Remote Desktop App - Error 0x207 or 0x607