What are the types of constraints?

1 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

What are the differences between stored procedure and view in sql server?

0 Answers  

---

How to restore performance issues and how to check?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

Explain what is log shipping?

0 Answers  

---

What is difference between standardization and normalization?

0 Answers  

---

Which database stores information about replication?

0 Answers  

---

How to modify an existing stored procedure in ms sql server?

0 Answers  

---

What are the four main query statements?

7 Answers   Wipro,

---

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

---

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  

---