How to write a script for upate the data in prod , i have
50000 row are there
Answer Posted / kumari
--table name = production
--coloum name = description(one column name)
--categoryname is another column name
update dbo.production
set
discription='xxxxxxxxxxx'
where [check condition]
categoryname='vitamins'
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain candidate key, alternate key, and composite key?
what are the core components of SSRS?
What is forward - only cursors / read only cursor?
What are commit and rollback in sql?
User wants only to display only pdf as export option in report manager. How to achieve this?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is inner join in sql server joins?
What is the Main Difference between ACCESS and SQL SERVER?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What are the indexes in sql server?
What is delete query?
What is an index in a database?
What is the difference between resultset and resultsetmetadata?
What is the difference between row_number and dense_rank?
What is a self join in sql server?