Answer Posted / Nitesh Ranjan

Joins in SQL allow combining data from two or more tables based on a common column, known as the join key. There are four main types of joins: 1) Inner Join: Returns only the matching records from both tables. 2) Left (Outer) Join: Includes all records from the left table and matching records from the right table. If there is no match, NULL values are displayed for the right table columns. 3) Right (Outer) Join: Works similarly to a left join but returns all records from the right table and matching records from the left table. 4) Full Outer Join: Returns all records when there is a match in either table, with NULL values for missing records.

What is a coalesce function?

1261

---

How to convert numeric expression data types using the cast() function?

1134

---

Why we use the openxml clause?

1059

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1055

---

Does view occupy space?

998

---

What is a view in sql?

1033

---

Disadvantages of the indexes?

1205

---

Can one drop a column from a table?

1075

---

do you know how to configure db2 side of the application? : Sql server database administration

1106

---

What are the properties of the transaction?

1059

---

What is self contained sub query?

1130

---

What is standby servers? Explain types of standby servers.

1067

---

How do I create a trace in sql server?

1102

---

How to rebuild the master database?

1148

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2285

---