Answer / Sayed Mohd Nadeem

A Left Outer Join (also known as a Left Join) in SQL Server returns all rows from the left table (table on the left side of the join clause), with matched rows from the right table (table on the right side of the join clause). If there is no match, then NULL values are used for unmatched right table columns.

What are the pros and cons of creating extended stored procedures?

1 Answers  

---

What is mean by dml?

1 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

What is difference between clustered and non clustered index?

1 Answers  

---

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

what operator performs pattern matching?

2 Answers  

---

How data can be copied from one table to another table?

1 Answers  

---

What is a SQL Server Temporary Table?

1 Answers   Wipro,

---

What is an example of a primary key?

1 Answers  

---

How do you implement session management in SQL Server mode?

1 Answers   Cap Gemini,

---