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

How efficient you are in oracle and SQL server?

1130

Which are the important points to note when multilanguage data is stored in a table?

973

How can we get count of the number of records in a table?

940

How do I find the port number for sql server?

955

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

953

Can multiple columns be used in sql group by clause in ms sql server?

1029

What do you understand by check constraint in sql server?

929

How will you hide an attribute? : sql server analysis services, ssas

936

Explain the difference between cross join and full outer join?

966

where the connection string store in the database

2051

What is store procedure? How do they work?

985

What are views used for?

996

What are partitioned views and distributed partitioned views?

1008

Can we install sql server 2016 on windows 7?

1115

What are trace files?

936