adspace


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

Answer Posted / ashis

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Disadvantages of the indexes?

1230


What is a view in sql?

1046


What is clustered index

1093


What is in place upgrade in sql server?

1137


What are the properties of the transaction?

1079


What is self contained sub query?

1147


How to provide default values to function parameters?

1272


what is the difference between openrowset and openquery?

1207


Can one drop a column from a table?

1098


Why we use the openxml clause?

1088


How do I find the sql server version?

1114


What is acid mean in sql server?

1257


Can we shrink data file in sql server?

1135


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1303


Why should you use or avoid select * statements?

1120