How to write a script for upate the data in prod , i have
50000 row are there
- 2 Answers
- 4532 Views
- TCS, I also Faced
- E-Mail Answers
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
Your table has a large character field there are queries that use this field in their search clause what should you do?
How do we know if any query is retrieving a large amount of data or very little data?
What is use of except clause? How it differs from not in clause?
What are the different acid properties?
What Are the Main Features of SQL Azure?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is coalesce and check constraint in sql server?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What guidelines should be followed to help minimize deadlocks?
What is replication with database mirroring? : sql server database administration
Explain Reporting Life Cycle?
How use inner join in sql server?
What are the grouping functions?
What are the requirements to use odbc connections in php scripts?
What is sql or structured query language?
