In the primary key have a multiple field or not?

8 Answers   TCS,

---

What is table-valued sub query?

0 Answers  

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

0 Answers  

---

what are batch in sql server?

2 Answers   Satyam,

---

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

Explain the rules for designing files and file groups in sql server?

0 Answers  

---

What is the difference between a stored procedure and a user defined function?

0 Answers  

---

What is difference between rownum and row_number?

0 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

---