How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

---

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

What are the benefits of filtered indexes?

0 Answers  

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

0 Answers  

---

how insert selected column only ?

3 Answers   Robert Half,

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

0 Answers  

---

Explain what is raid and what are different types of raid levels?

0 Answers  

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

---

Do you know the cursor optimization tips?

0 Answers  

---

What are cursors in ms sql server?

0 Answers  

---

Explain filtered indexes benefits?

0 Answers  

---