What is precedence constraint?

0 Answers  

---

What is the difference between implicit and explicit transaction?

0 Answers  

---

Can binary strings be used in arithmetical operations?

0 Answers  

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno 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's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

What do you mean by recursive stored procedure?

0 Answers  

---

Do you know what are various aggregate functions that are available?

0 Answers  

---

How to create a new table in a given schema?

0 Answers  

---

What are the instances when triggers are appropriate?

0 Answers  

---

Explain in brief how sql server enhances scalability of the database system?

0 Answers  

---

What program is used to store the data source file?

0 Answers  

---