Sunday, November 4, 2007

Beginning SQL Statements

Whenever anybody wants to start learning SQL Server , there are few basic commands which needs to be known,

  • SQL Select Statement -- Select statement is used for selecting any number of rows from a table. You can specify the 'where' clause and retrieve number of rows selectively. Select * from table1 where column1 = 'name' and column2 = 'ID'
  • SQL Insert Statement -- Insert Statement is used for inserting rows in a table . Here also 'where' clause can be specified as required. Insert into table1(column1,column2,column3) Values('value1','value2','value3')
  • SQL Delete Statement -- Delete Statement is for deleting any number of rows based on certain clause. Delete from table1 where column1='value1' and column2='value2'
  • SQL Update Statement -- Update Statement , updates a particular row as required. Update from table1 set column1 = 'value1'

These are the 4 important statements to know for any beginner . We will keep on posting blogs regarding different ways of writting these statements.

No comments: