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 / bhaskar

Answers were Sorted based on User's Feedback



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

Answer / ashis

update <tablename> set <columnname>=<value>
where <condition>

Is This Answer Correct ?    0 Yes 0 No

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

Answer / 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

More SQL Server Interview Questions

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

Mention the differences between sql server and mysql.

0 Answers  

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  

What is shared lock?

0 Answers  

What does ss stand for sexually?

0 Answers  

What is dynamic cursor in SQL SERVER?

0 Answers  

What do you mean by an execution plan? How would you view it?

0 Answers  

What are the properties of the transactions?

0 Answers  

how you can get the list of largest tables in a database? : Sql server administration

0 Answers  

Tell me the difference between clustered and non-clustered index?

0 Answers  

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

What is the purpose of a table?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories