Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

---

How you can get a list of all the table constraints in a database? : Sql server administration

0 Answers  

---

Is it possible to create trigger on views?

0 Answers  

---

what are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  

---

---

How to create a testing table with test data in ms sql server?

0 Answers  

---

Write a query for primary key constraint with identity key word?

0 Answers   MindCracker,

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

When would you use it?

0 Answers  

---

How to get all stored procedures in sql server?

0 Answers  

---

What does dml stand for?

0 Answers  

---

What is the maximun sixes of .mdf in sql server 2005

1 Answers  

---