Answer Posted / ramesh

Full Outer Join requires a condition and related column in
the table.
Cross Join requires with out condition and no related
columns in the tables.

How to delete an existing row with delete statements in ms sql server?

1019

---

How do I find query history in sql server?

875

---

How to find the second highest salary of an employee?

1106

---

How to replace the Query Result 'Null Value' with a text ?

971

---

What Is Rdbms?

1082

---

What happens if null values are involved in boolean operations?

940

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

893

---

How do you delete duplicate records in sql server?

994

---

plss anybody specify tha constrian management system in dbms

2081

---

How to find the service pack installed? : sql server database administration

970

---

What are transactions in sql?

986

---

What is the usage of sign function?

1038

---

Please explain go command in sql server?

991

---

what type of index will get created after executing the above statement? : Sql server database administration

920

---

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

2160

---