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

What is an index. What are the types?

582


How can I tell if sql server is 32 or 64 bit?

497


What are the advantages of user-defined functions over stored procedures in sql server?

457


Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

512


Explain the disadvantages of cursors?

586






How do I open port 1433?

519


What are the differences between web role and worker role?

100


What do you know about normalization and de- normalization?

466


What are the different types of upgrades that can be performed in sql server?

685


Can we call future method from queueable?

590


What is the difference between mysql and mysqli?

581


Does an index slow down updates on indexed columns?

577


What is sleeping status in sql server?

516


What is purpose of normalization?

525


Give me any three differences between Truncate and Delete.

561