Answer / kunal sain

the said user will be eligible to grant the privilege to
other user.

Answer / soni

the user to whom we give privilege by with grant
option,he/she will also have authority to give privilege
to others.

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

Diffrences between sql server 2000 vs 2008

0 Answers   TCS,

---

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

0 Answers  

---

How can you ensure that the database and sql server based application perform well?

0 Answers  

---

What is tablesample?

0 Answers  

---

Get Current System Date Time

2 Answers  

---

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

---

What does null mean?

0 Answers  

---

What is difference between views and tables?

0 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

How can I create a table from another table without copying any values from the old table?

3 Answers  

---

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,

---