What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

How will you hide an attribute? : sql server analysis services, ssas

0 Answers  

---

Difference between primary key and clustered index?

0 Answers  

---

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

Why we are using the sql language?. What is the purpose of using this?

2 Answers  

---

Why are views required in the sql server or in any other database?

0 Answers  

---

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

---

What is faster join or union?

0 Answers  

---

Is there any difference between the primary key and unique key?

0 Answers  

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

What is the difference between getdate and sysdatetime?

0 Answers  

---