Again, and the point has been echoed by James, is that the all-rounder should know both.
I am not saying that SPs etc (not that has anything to do with you level of SQL per se) are what you should know, we all know that ColdFusion can do a lot with loops and SQL but if you have no choice but to use SQL in a job, you will be stuffed if all you know SELECT. "This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Mike Kear To: CF-Talk Sent: Sun Aug 27 12:05:06 2006 Subject: Re: Top 100 ColdFusion Programmers I think knowlege is worthwhile on its own merit. I think the more you know about all of the disciplines related to web technologies the better. However in 10 years I have never seen a routine done with a SP that couldnt also be done by some other method. I think stored procedures are only one of several choices usually. You could live without SPs, just as you can live without javascript or flash, even though they're all immensely useful tools in the right place. I think it's overstating the case to say "you can't be a coldfusion developer without knowing a lot about T-SQL". I think it's highly desirable to know about T-SQL, and if you know T-SQL you're more valuable so an employer who uses it, but you can be an effective developer in many environments without knowing squat about T-SQL. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > Robertson-Ravo, Neil (RX) wrote: > > > > > No excuse for not knowing a decent about of T-SQL. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251184 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

