Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

---

Can we move Resource database from one path to another? If yes,How can we?

1 Answers   Wipro,

---

What is difference between createstatement and preparedstatement?

0 Answers  

---

How to change the system date and time from SQL Plus Terminal ?

0 Answers   MCN Solutions,

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

0 Answers  

---

What is the recommended total size of your memory optimized tables?

0 Answers  

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

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  

---

Differentiate between delete and truncate.

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

---