Thursday, April 10, 2008

SQL Data Statements

Select Statements

Select fieldname , fieldname From table name

example: Select DistributorID , DistributorName From DistributorTable


Update Statements

UPDATE table name
Set fieldname = value

example:

Update Customers
Set Name = 'Jerry'


Delete Statements

Delete From tablename

example:

Delete From Customers

No comments: