What are the different types of triggers in SQL SERVER?

0 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

What are SSL and TSL protocols?

0 Answers   Wipro,

---

Can you create a logon trigger in sql server 2005 express edition?

0 Answers  

---

What is Command line parameters in PLSQL.?

0 Answers   MCN Solutions,

---

---

Explain what are commit and rollback in sql?

0 Answers  

---

What is a trace frag? Where do we use it?

0 Answers  

---

Why truncate is ddl?

0 Answers  

---

What does the not null constraint do?

0 Answers  

---

What are differences in between sql server 2012 and sql server 2016?

0 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---