what is table? : Sql dba

0 Answers  

---

write a query to find 4th max salary

7 Answers  

---

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

---

What is spool?

0 Answers  

---

What is write ahead logging in sql server?

0 Answers  

---

---

How packaged procedures and functions are called from the following?

2 Answers  

---

what are aggregate and scalar functions? : Sql dba

0 Answers  

---

what is the syntax used for partition in tsql? : Transact sql

0 Answers  

---

Can we write dml inside a function in sql server?

0 Answers  

---

real time applications of nullif?

3 Answers  

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---