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'

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

---

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---

What are the advantages of using stored procedures?

0 Answers  

---

What is the most common type of join?

0 Answers  

---

How would we use distinct statement? What is its use?

0 Answers  

---

What is the default value of an integer data type in sql server 2005?

0 Answers  

---

What is the most common trace flags used with sql server?

0 Answers  

---

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---

Distinguish between commit and rollback?

0 Answers  

---

Explain syntax for viewing, dropping and disabling triggers?

0 Answers  

---