This should return a result set with all the books we've inserted.
INSERT INTO Books (BookID, Title, Author, PublishYear) VALUES (1, 'To Kill a Mockingbird', 'Harper Lee', 1960), (2, '1984', 'George Orwell', 1949), (3, 'The Great Gatsby', 'F. Scott Fitzgerald', 1925); sql management studio 2005
If you want to delete the table (be careful with this, as it will erase all data in the table): This should return a result set with all