priyanka


{ City }
< Country > india
* Profession *
User No # 22945
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 4
Users Marked my Answers as Wrong # 1
Questions / { priyanka }
Questions Answers Category Views Company eMail




Answers / { priyanka }

Question { TCS, 4723 }

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


Answer

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

Question { 5111 }

i need some interview questions on sql server developer plz
any onee send some links.


Answer

www.allinterview.com

http://blog.sqlauthority.com

Is This Answer Correct ?    4 Yes 0 No