update <tablename> set <columnname>=<value> where <co

How to write a script for upate the data in prod , i have
50000 row are there

Question Posted / ashis

Answer Posted / ashis

update <tablename> set <columnname>=<value>
where <condition>

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to delete existing rows in a table?

1158

Can we perform backup restore operation on tempdb? : sql server database administration

998

How we create SQL Server 2005 Reporting Services ? Give me Sample

1991

Create and insert into temp table in sql server?

1031

Explain some stored procedure creating best practices or guidelines?

936

Tell me what is the stuff and how does it differ from the replace function?

981

Are null values the same as that of zero or a blank space?

1038

Define full outer join?

955

How to remove duplicate rows from table except one?

1007

What is difference between index and primary key?

1100

If a stored procedure is taking a table data type, how it looks?

6448

What does the on update no action do?

1028

What is collation?

1140

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

883

How to start and end transact-sql statements?

1028