Tasks

SQL Server Administration
1

  1. 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
    1. Create a stored procedure which will show name, address, number for given key
2

Soooooooo.... What's your question?

3

Homework?

4

Ya think?
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.