Answer / Abhishek Kumar Banswal

Cross join, also known as a Cartesian product, is used to combine every row from two or more tables without any matching condition. It produces a result set by multiplying the number of rows in one table by the number of rows in another table.

Explain the creation and execution of a user-defined function in the sql server?

1 Answers  

---

Explain transaction server distributed transaction?

1 Answers  

---

Name few of the dcl commands in sql?

1 Answers  

---

How do you connect 100 files as a flat file sources in one package of SSIS?

2 Answers  

---

How to enter binary string literals in ms sql server?

0 Answers  

---

What are the difference between primary key and unique key? : sql server database administration

1 Answers  

---

How to find index size for each index on table?

1 Answers  

---

What do you mean by tablesample?

1 Answers  

---

Is it possible to have clustered index on separate drive from original table location?

0 Answers  

---

How ssrs maintain security?

1 Answers  

---

What are the different authentication modes in sql server? How can it be changed?

1 Answers  

---

What are the purposes and advantages stored procedure?

1 Answers  

---