Answer / deepthi

Is a system function that returns the last-inserted
identity value

Can we shrink data file in sql server?

0 Answers  

---

Where are full-text indexes stored?

0 Answers  

---

Explain the categories of stored procedure?

0 Answers  

---

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

---

What is @@error in sql?

0 Answers  

---

---

How do I get to sql server configuration manager?

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  

---

How to recompile stored procedure at run time?

0 Answers  

---

How to retrieve error messages using odbc_errormsg()?

0 Answers  

---

Explain intellisense for query editing

0 Answers  

---

What is a job?

3 Answers  

---

Difference between 2NF &3NF ?

0 Answers   Cap Gemini,

---