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 !
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
Post a Comment