-- ********** create database ********** -- -- ********** Begin ********** -- CREATE DATABASE website; -- ********** End ********** -- go use website go -- ********** create table ********** -- -- ********** Begin ********** -- CREATE TABLE shopping ( ID int IDENTITY(1,1) NOT NULL, Name varchar(20) NOT NULL, address varchar(30) NOT NULL ); -- ********** End ********** -- go SET NOCOUNT ON insert into shopping (Name, address) values ('eBay', 'www.ebay.com') go SET NOCOUNT ON -- ********** insert ********** -- -- ********** Begin ********** -- insert into shopping (Name, address) values ('amazon', 'www.amazon.com'); -- ********** End ********** -- go SET NOCOUNT ON -- ********** delete ********** -- -- ********** Begin ********** -- DELETE FROM shopping WHERE Name = 'eBay'; -- ********** End ********** -- go