Create a table with two columns, first as primary key, second as XML
2) create a stored procedure which will take four input parameters, Key, Name, Address, Number and depending on value of key either add
or update existing record. i.e. if key is zero then add else update record for specified key, values should be stored in XML format in XML column
- Create a stored procedure which will show name, address, number for given key
Soooooooo.... What's your question?
In general, I think most people at this site would be willing to assist with a homework assignment but you need to show that you have made some type of effort. Show us what you've come up with so far and where you are having difficulty and, perhaps, we can help you to find and, more importantly, understand a solution.