By using Update statement. For example Update table_name set column

How to update existing rows in a table?

Question Posted / priyanka rani

Answer Posted / priyanka rani

By using Update statement. For example Update table_name set column_name='value' where column_name='your condition'
if required use where condition

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

explain different types of backups avaialabe in sql server? : Sql server database administration

752

What is primary key and example?

700

What is policy based management (pbm)? : sql server database administration

739

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

667

What do you understand by recursive stored procedures?

745

Explain the different types of backups available in sql server? : sql server database administration

678

How to drop an existing table?

726

Explain view in sql server?

820

Do you think BCNF is better than 2NF & 3NF? Why?

999

Can you explain what is the use of custom fields in report?

788

How to recreate an existing index in ms sql server?

713

Describe triggers features and limitations?

679

what is normalization? : Sql server database administration

741

what are the different ways to return the rowcount of a table?

745

What are various ways to enhance the ssrs report?

721