Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-20 : 08:34:22
|
| Einstein writes "1. I want to know how to use a derived tables to build a complexed queries?2.how to apply table value function for sales reporting?3.How to calculate percent on bails?4.How to rename all tables in the database?5.How to apply correlated subquery with averaging?6.How to prevent table lock escalation?6.How to update 17 million rows for ordrdetails?7.How to create a covering index?8.How to use UNION ALL insted of or?.9.How to return OUTPUT WITH dynamic sql?10.Sample of database for a school using M.S.access?I need sql database books to continue my IT program.Einstein JamesP.O.Box KT 386Kotobabi AccraGhana." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-01-20 : 08:36:06
|
| I'll point you to Books Online (Start Menu, Programs, Microsoft SQL Server) and the SQL Team Bookstore:http://www.sqlteam.com/store.aspSince your name is Einstein and you're trying to build reference skills, I'll leave the rest of the questions to you. We don't do homework or answer exam questions on SQL Team, you won't learn anything if we did. |
 |
|
|
|
|
|
S.Q.L Database