Answer Posted / kamal

/* INNER JOIN -- Matched Rows only from Tables */
SELECT NR.RequestId, U.UserId FROM ITWP_NewRequest NR

INNER JOIN ITWP_Users U ON U.UserId = NR.UserId

/* OUTER JOIN -- Matched Rows only from Tables
RIGHT OUTER JOIN -all the rows from Right table and matched
rows from Left Table.

LEFT OUTER JOIN - all the rows from Left table and matched
rows from Right Table.

FULL OUTER JOIN - all the rows from Left table and from
Right Table.
*/
SELECT NR.RequestId, U.UserId FROM ITWP_NewRequest NR

RIGHT OUTER JOIN ITWP_Users U ON U.UserId = NR.UserId

SELECT NR.RequestId, U.UserId FROM ITWP_NewRequest NR

LEFT OUTER JOIN ITWP_Users U ON U.UserId = NR.UserId

SELECT NR.RequestId, U.UserId FROM ITWP_NewRequest NR

FULL OUTER JOIN ITWP_Users U ON U.UserId = NR.UserId

/* A Join without having any condition is known
as Cross Join, in cross join every row in first table is
joins with every row in second table.
*/
SELECT NR.RequestId, U.UserId FROM ITWP_NewRequest NR

CROSS JOIN ITWP_Users U

How to define the name and server for a new dsn?

1193

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

1041

---

How except clause is differs from not in clause?

1004

---

How to disconnect from a sql server using mssql_close()?

1161

---

What is reference section?

1052

---

What is PROJECTION Operation?

1069

---

How use inner join in sql server?

1184

---

What is difference between stored procedure and user defined function?

1164

---

How to set the current database in ms sql server?

1135

---

What is partitioned view?

958

---

What is the main difference between ‘between’ and ‘in’ condition operators?

1268

---

What is the importance of a recovery model?

1090

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1096

---

How do you manipulate data?

946

---

1 01 101 01010

2096

---