Mention the differences between substr and charindex in sql server.

0 Answers  

---

Explain triggers?

0 Answers  

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

0 Answers   Microsoft,

---

If no size is defined while creating the database, what size will the database have?

0 Answers  

---

How to read 2nd highest sal from EMP table?

5 Answers   IBM, TCS,

---

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

What is user defined stored procedures?

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 delete existing triggers using "drop trigger"?

0 Answers  

---

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,

---

What is clr ddl trigger?

0 Answers  

---

What is collation?

0 Answers  

---