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

What Is Rdbms?

1081

What are the advantages of paper records?

907

What is Sqlpaging in SqlServer 2005 ?

1012

How to convert character strings into numeric values?

1032

What is the difference between dataadapter and datareader?

940

How ssrs maintain security?

1015

What is ms sql server index?

1023

What is the need for indexing?

886

What does executeupdate return?

926

What programming language would you use to create embedded functions in ssrs?

172

what is the system function to get current user's user id? : Sql server database administration

948

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

943

What is logon trigger?

1027

What is pivot and unpivot?

974

Why olap is used?

918