How to write an inner join with the where clause in ms sql server?

0 Answers  

---

what is the output for this query select * from employee where 1=1;

4 Answers  

---

What are the differences between stored procedure and view in sql server?

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  

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

What happens if an integer is too big for int date type?

0 Answers  

---

What is bulkcopy in sql?

0 Answers  

---

Benefits of Stored Procedures?

0 Answers   Wipro,

---

difference between sql server2000 and sql server2005

1 Answers   KPMG,

---

What are the advantages of log shipping?

0 Answers  

---

One table how may column and Primary key

3 Answers  

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---