USE BookShopDB

DROP TABLE Test1

-- Create demo table
CREATE TABLE Test1
      (
      RowID INT IDENTITY(1,1) NOT NULL,
      Title VARCHAR(80) NOT NULL,
      Type CHAR(12) NOT NULL DEFAULT ('Unknown'),
      City VARCHAR(50) NULL,
      Cost MONEY NULL
      )

--Insert values to row
INSERT INTO Test1 (Title, Type, Cost)
VALUES ('Test Title', 'business', 27.00)

select * from test1

--Copy values into table from Titles table database
INSERT INTO Test1 (Title, Type, Cost)
      SELECT Title, Type, Price
      FROM Pubs.dbo.Titles

SELECT * FROM Test1

--Double the values in the cost columns for all 'business' rows
UPDATE Test1
SET Cost = Cost * 2,
    Title = 'B:' + Title
WHERE Type = 'business'

--Delete some rows
DELETE Test1
WHERE Title = 'Test Title'

--Delete all rows
DELETE Test1

--Delete table
DROP TABLE Test1