Thread: View/Access Backend Tables, etc without purchasing additional module?
View Single Post

Old 01-24-2008, 10:04 AM   #11 (permalink)
DrewAllen DrewAllen is offline
Crystal Reports Guru

DrewAllen's Avatar

Join Date: May 2006
Location: Philadelphia, PA
Posts: 1,182
Rep Power: 4 DrewAllen is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Information Edge (TIE)
- API/VBA

Quote:
Originally Posted by fborchert View Post
That sounds wonderful! What training tools/tutorials would you recommend for SQL Server/Query Analyzer?
Well, I'm mostly self-taught. I created queries in MS Access and then looked at how it was written. MS Access SQL and MS SQL Server's T-SQL are similar enough that this works. From there I studied MS SQL Server Books On Line (BOL) extensively. I also found SQL Server magazine to be quite helpful, especially the column "T-SQL Black Belt".

Drew
__________________
J. Drew Allen
Children's Hospital of Philadelphia

Crystal Reports and SQL Server Consultant

It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.
Reply With Quote