Answer Posted / uttam sing rawat

select distinct Owner_Name from dbo.Tbl_Owner where bike
in(Select distinct bike from dbo.Tbl_Owner)

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1035

---

Do you know the capabilities of cursors?

1150

---

What command is used to delete a table from the database in the sql server and how?

1117

---

Explain how you can deploy an SSRS report?

150

---

what changed between the previous version of sql server and the current version? : Sql server database administration

1015

---

What are the new data types are introduced in sql 2000?

907

---

How network traffic be reduced by using the stored procedure?

1118

---

Explain few examples of RDBMS?

1042

---

What is the difference between grant and with grant while giving permissions to the user?

966

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

992

---

Is oracle faster than sql server?

957

---

can we have a nested transaction? : Sql server database administration

1103

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1225

---

Mention the 3 ways to get a count of the number of records in a table.

979

---

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

2240

---