Answer / naresh

USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECDsystem tables
contain information on privileges gran...

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

Which trace flags are enabled in sql server?

0 Answers  

---

What are the database objects? : SQL Server Architecture

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

What is the difference between coalesce() & isnull()?

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  

---

how many types of store procedre in sqlserver 2000?

2 Answers   ATI,

---

Explain what is public role in sql server?

0 Answers  

---

does physical index sort data

1 Answers  

---

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

---

What is a transaction and what are ACID properties?

3 Answers  

---

Do you know hot add cpu in sql server 2008?

0 Answers  

---