How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

How can change procedure in sql server?

0 Answers  

---

How do you clear a log file?

0 Answers  

---

Explain transaction server auto commit?

0 Answers  

---

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

What is the maximum length of an alert name?

0 Answers  

---

How do I list the available tables in a database I'm querying?

4 Answers  

---

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  

---

What are the differences between stored procedure and view in sql server?

0 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  

---

What is a derived table?

0 Answers  

---