/* Data Manipulation Language (DML) 1) INSERT 2) UPDATE 3) DELETE */ USE MyDB; GO UPDATE [State] SET [LocalName]='Selangor Darul Ehsan', [Population]=8000000 WHERE [ID]=1; DELETE FROM [State] WHERE [Country]='my'; SELECT * FROM [State]; --To empty the table DELETE FROM [State]; TRUNCATE TABLE [State]; --Faster and will reset the auto-numbers INSERT INTO State (Country,Name,LocalName,Population) VALUES('my','Selangor', 'Selangor', 7063200); --SELECT INTO SELECT [ID],[Country],[Name],[LocalName] INTO [JapanState] FROM [State] WHERE [Country]='jp'; SELECT * FROM [JapanState]; DROP TABLE IF EXISTS [JapanState];