PRINT '--' PRINT '-- Show data in makes table' PRINT '--' PRINT ' ' SELECT * FROM [ACTIVE].[MAKES]; go PRINT '--' PRINT '-- Insert a new record' PRINT '--' PRINT ' ' INSERT INTO [ACTIVE].[MAKES] ([MAKER_NM], [START_YR], [END_YR]) VALUES ('Plymouth', 1928, 2001); go PRINT '--' PRINT '-- Update a existing record' PRINT '--' PRINT ' ' UPDATE [ACTIVE].[MAKES] SET [MAKER_NM] = 'Henry Ford' WHERE [MAKER_ID] = 3 go PRINT '--' PRINT '-- Show data in makes table' PRINT '--' PRINT ' ' SELECT * FROM [ACTIVE].[MAKES]; go PRINT '--' PRINT '-- Update a existing record' PRINT '--' PRINT ' ' UPDATE [ACTIVE].[MAKES] SET [MAKER_NM] = 'Ford' WHERE [MAKER_ID] = 3 go PRINT '--' PRINT '-- Delete the new record' PRINT '--' PRINT ' ' DELETE FROM [ACTIVE].[MAKES] WHERE [MAKER_NM] = 'Plymouth' go PRINT '--' PRINT '-- Show data in makes table' PRINT '--' PRINT ' ' SELECT * FROM [ACTIVE].[MAKES]; go