what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---

What do you mean by an execution plan?

0 Answers  

---

What is page-level compression?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

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 is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

What are the tables in sql?

0 Answers  

---

What command is used to delete a table from the database in the sql server and how?

0 Answers  

---

Explain log shipping?

0 Answers  

---

What is a collation in ms sql server?

0 Answers  

---

What are the differences between substr and charindex in sql server.

0 Answers  

---

How do indexes help, types?

0 Answers  

---