How to write a script for upate the data in prod , i have
50000 row are there
- 2 Answers
- 5606 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
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is the primary use of the model database?
How to provide default values to function parameters?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is a scheduled job or what is a scheduled task?
Explain system functions or built-in functions? What are different types of system functions?
What is self contained sub query?
What is acid mean in sql server?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is temporary table in sql server? Why we use temp table?
What are the different subsets of sql?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is normalization and what are the advantages of it?
Can we do dml on views?
How to remove duplicate rows from table except one?
