if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

What is the disadvantages of index?

3 Answers   TCS,

---

Why SQL Agent is used?

0 Answers   Abacus,

---

do views contain data ?

0 Answers   MCN Solutions,

---

What is the difference between a clustered index and a non-clustered index?

0 Answers  

---

What do you do in data exploration

0 Answers   EXL,

---

what is meant by deafult in sql server?

2 Answers  

---

What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,

---

Give the query of getting last two records from the table in SQL SERVER?

0 Answers   Petranics Solutions,

---

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 function does a database engine serve in the sql server?

0 Answers  

---

Is the order of columns in the set clause important in ms sql server?

0 Answers  

---