SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 07:03 PM
| ||||
| ||||
 Need some practice Please point me to a web resource from where I can study: 1) writing complex queries such as those involving HAVING, mult-level nested queries, GROUP BY, T-SQL functions 2) Joins - a lot of practice 3) Stored Procedures, transactions, cursors and triggers - I need some heavy-duty practice Where can I get some good practice of the above? Also, please recommend a good SQL Server/T-SQL book in the light of the above requirement.      |
|
02-29-2008, 07:03 PM
| |||
| |||
| Re: Need some practice Here's a good one for joins. I like the colors for the join tables: http://www.tek-tips.com/faqs.cfm?fid=4785 |
|
02-29-2008, 07:05 PM
| ||||
| ||||
| Re: Need some practice > Have you gotten a copy of SQL FOR SMARTIES yet? It is required for > working SQL programmers. And my house payment  The book is of little use to working SQL programmers, a lot of the examples aren't directly useable in SQL Server nor do they scale into the real world. People are better off spending a couple of minutes searching GOOGLE for the answers. -- Tony Rogerson SQL Server MVP http://sqlserverfaq.com - free video tutorials "--CELKO--" <jcelko212@earthlink.net> wrote in message news:1144801857.130733.158410@i40g2000cwc.googlegr oups.com... > Have you gotten a copy of SQL FOR SMARTIES yet? It is required for > working SQL programmers. And my house payment > |
 |
« SQL-DMO and C#: retrieve the list of User-Defined Functions
|
SQL Svr 2005 Express Does NOT Support DTS »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:53 PM.
