Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / kumari

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


Please Help Members By Posting Answers For Below Questions

Explain candidate key, alternate key, and composite key?

1003

what are the core components of SSRS?

129

What is forward - only cursors / read only cursor?

1091

What are commit and rollback in sql?

1134

User wants only to display only pdf as export option in report manager. How to achieve this?

262

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

997

What is inner join in sql server joins?

1043

What is the Main Difference between ACCESS and SQL SERVER?

1142

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5925

What are the indexes in sql server?

1118

What is delete query?

946

What is an index in a database?

983

What is the difference between resultset and resultsetmetadata?

981

What is the difference between row_number and dense_rank?

884

What is a self join in sql server?

1141