Answer Posted / kalyana chakravarthy maddipati

Apart all the joins above there is one more join it is

NO EQUI JOIN ie emp.deptno!= dept.deptno or one can use <> sign instead

What is the use of =,==,=== operators?

1013

---

What are the differences between web role and worker role?

122

---

what is the system function to get current user's user id? : Sql server database administration

1008

---

Does group by or order by come first?

963

---

What is Federation and Federation Member?

92

---

What are the tools available in market as an alternative to sql server reporting services?

131

---

What objects does the fn_my_permissions function reports on? : sql server security

1042

---

How to create a new login name in ms sql server?

1066

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2072

---

What is sql injection? How to protect against sql injection attack?

1001

---

Will count(column) include columns with null values in its count?

1101

---

How to define output parameters in stored procedures?

1029

---

What is the sql case statement used for?

1104

---

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

957

---

role of sql sever 2005 in database rather than any other database

1945

---