Answer / ashis

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

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'

How to join two tables in a single query in ms sql server?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---

Ms sql server index?

0 Answers  

---

What is the use of for clause?

0 Answers  

---

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

---

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  

---

Do you know what is rank function?

0 Answers  

---

How to search for a string in all stored procedure in sql server?

0 Answers  

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

0 Answers  

---