Adding to what Steve said, you might want to model your SQL statements using the SQL tools that come with MS SQL, or download some free tools that can check the syntax for you.
John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Wednesday, December 29, 2010 9:09 AM To: ProFox Email List Subject: Re: select on ms sql 2005 data on web server On Wed, Dec 29, 2010 at 6:48 AM, James E Harvey <[email protected]> wrote: > Do you have a favorite source you use to research the syntax? -------------------- You are in a hard situation. VFP made you think you were in control but allowed you to do improper syntax. You will attempt to carry those bad traits over and cause more frustration first and then harm. Frustration could be knowing how to group by. Harm is putting functions into your syntax. TTOD() to name one that you presented. These languages are similar but not the same. Much like Spanish and Portuguese are not the same. Don't get frustrated. If I were you I would learn how to generate Stored Procedures that demand input params and allow you to generate output params. This will help teach you syntax for T-SQL. You will learn that you can do conditional processing IF Else. You will grasp the "end" word as well. Google will help you out a lot. sites that you were interested in: www.databasejournal.com www.sqlshare.com << daily video they present www.stackoverflow.com http://www.sqlshare.com/login.aspx?returnurl=/player.aspx?vid=872 is a vid on how to CONVERT Very important to understand! :) Last thing is to not "Select *" when returning data for actual use unless you actually need every column. Your pipe is only so wide so limit what you receive to get it faster. I cannot state this enough. HTH -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/05f601cba772$a1e94200$e5bbc6...@[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
