• Home
  • Tutorials
  • Interviews
  • Info Seed
  • Forums
  • Projects
  • Links
  • Contact Us
SQL Server
HOW TO START...??
CREATING DATABASE
CREATING TABLE
INSERTION
SELECTION
USING DISTINCT
WHERE CLAUSE
AS IN SQL
OPERATORS
DELETE
UPDATE WITH WHERE CLAUSE
UPDATE WITHOUT WHERE CLAUSE
LIKE OPERATOR AND WILDCARDS
BETWEEN OPERATORS
IN CLAUSE
ORDER BY
JOINS
UNION
INTERSECT
ALL/ANY
SQL CONSTRAINT
INDEX
DROP
Alter
FUNCTIONS
GROUP BY
HAVING CLAUSE
VIEWS

Update

  • The ‘Update’ keyword is used to edit or change the records in the table.

Syntax

Update table_name set column1=value1, .......,column=valuen where column_name=some_value_already_in_records

  • The where clause plays a very important role here, it tells which record(s) is to be updated. If it is not used than all the columns gets updated for all the rows or records.

Example-21

        After Updating:

+ Compare example-21 with example-22  to understand better.

 

 

 

 

 

previous next
 
Lorem: Lorum | Ipsum | Dolar | Sic Amet | Consectetur | Lorum | Ipsum | Dolar | Sic Amet | Consectetur