how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,

---

whate is advantages of sql server 2000

0 Answers  

---

What are trace flags and mention a few common trace flags used with sql server?

0 Answers  

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

---

What is referential integrity? What are the advantages of it?

4 Answers   Descon, Digital Domain,

---

What is the importance of concurrency control?

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  

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  

---

can a table be moved to different filegroup? : Sql server administration

0 Answers  

---