Friday, March 9, 2012

i need help all programming personels out there

hi everybody am evelyn and am a programming student i need help ASAP before this evening i am trying to use type xml to create a database in ms sql server 2005 i have written the code and executed it but i keep getting this error i have tried everything i know and done all the research online i cant find anything to help me out pls anybody who can help me out before tomorrow i need help ,
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.