ASP.NET Programmer

INSERT, UPDATE & DELETE : Basic Sql Syntax

I’m always experiencing a brain freeze when it comes to the simple stuff. Case in point, SQL Statements. Outside of the SELECT statement, the format of the update, insert, delete never seem to fall into place like I want them to. So here is a few examples to always keep me straight:

>> UPDATE Statement UPDATE Persons SET Address=’123 Main St’, City=’Portland’ WHERE LastName=’Programmer’ AND FirstName=’Joe’

>> INSERT Statement INSERT INTO Persons VALUES (4,’Programmer’, ‘Joe’, ’123 Main St’, ‘Portland’)

>> DELETE Statement DELETE FROM Persons WHERE LastName=’Programmer’ AND FirstName=’Joe’