what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

What is the function of sql server agent windows service?

0 Answers  

---

Why we use the openxml clause?

0 Answers  

---

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  

---

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

---

What is the partitioning method?

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 happens if the update subquery returns no rows in ms sql server?

0 Answers  

---

What is the need for indexing?

0 Answers  

---

What you can do to delete a table without the delete trigger firing?

0 Answers  

---

How do you open a cluster administrator?

0 Answers  

---

i want table name basis on column name.

5 Answers  

---