this is the code
CREATE XML SCHEMA COLLECTION telemart as '
'
but am creating two tables at the same time here is the other code
CREATE XML SCHEMA COLLECTION telemart AS N'
'
and here is the error message i keep getting for both
Msg 9441, Level 16, State 1, Line 1
XML parsing: line 1, character 14, incorrect xml declaration syntax
and here is the rest
create table customers
(customerID char(5) primary key,customersdetails xml(faculty))
and here is the error i get for this one i know its because the schema collection is not working that is why i keep getting this message but i need help
Msg 6314, Level 16, State 1, Line 1
Collection specified does not exist in metadata : 'faculty'
pls somebody help me
this is my email address
samuelleevelynnanayaaarthur@yahoo.com
thank you very much.
No comments:
Post a Comment