use Master
go
If exists 
	(Select [name] 
	  from sys.Databases
	  Where [name]='XmlResources')
Begin
Drop Database XmlResources
end
Else
Begin
Create Database XmlResources
End
go
Use XmlResources
Go
Create Table Resource
(
	ResourceID int identity(1,1) primary key,
	Title nvarchar(255),
	Description nvarchar(max),
	link nvarchar(255)
)
Go
Insert into Resource (Title, Description, Link)
Values ( 'Wikepedia XML',
'Wikipedias entry on xml, covers the history
and basics of the xml standard',
'http://en.wikipedia.org/wiki/xml')

Insert into Resource (Title, Description, Link)
Values ( 'W3 Schools',
'Contains articles and tutorials on a variety of
xml topics and standards',
'http://www.w3schools.com/xml/default.asp')

Insert into Resource (Title, Description, Link)
Values ( 'The World Wide Web Consortium',
'The source itself. Contains the standard and links to many resources including tutorials and examples',
'http://www.w3.org/XML')	

Insert into Resource (Title, Description, Link)
Values ( 'XML.org',
'A portal for resources related to XML and XML recommendations',
'http://www.xml.org')