Answer / Shashi Ranjan Dwivedi

To query multiple tables jointly in SQL Server, you can use JOIN statements. Here's an example:n`SELECT Table1.column1, Table2.column2 FROM Table1 INNER JOIN Table2 ON Table1.commonColumn = Table2.commonColumn;`

What is role playing dimension with two examples? : sql server analysis services, ssas

1 Answers  

---

How to create function with parameter in sql server?

1 Answers  

---

Tell me the phases a transaction has to undergo?

1 Answers  

---

When do you create cluster and noncluster index?

5 Answers   Satyam,

---

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

What is the difference between push and pull subscription? : sql server replication

1 Answers  

---

What is snapshot replication?

1 Answers  

---

After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,

---

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

1 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

What's the information that can be stored inside a bit column?

1 Answers  

---

How to insert data into an existing table?

1 Answers  

---