>> but am now using sql manager 2005 lite which does not seem to be able to do it.
EMS sql manager 2005 lite? Excellent tool. Here, try this. Even faster way to write a select query. Open up a new editor window and drag/drop a table into the editor window. Poof. There is your select query. J On Mon, Mar 31, 2008 at 4:20 PM, Mike Little <[EMAIL PROTECTED]> wrote: > Awesome tip that! usually i have enterprise manager to construct my > queries but am now using sql manager 2005 lite which does not seem to be > able to do it. > > >First thing I would do is get rid of the get all the SELECT *. > > > >product.*, product_description.*, product_options.*, > > > >This will save you three trips to the database. A quick way to grab the > >fields of a table with out typing them is > > > >Run a Select * FROM YourTable > > > >And dump the list of Columns using > <cfoutput>#Myquery.ColumnList#</cfoutput> > > > > > > > >On Sun, Mar 30, 2008 at 9:31 PM, Mike Little <[EMAIL PROTECTED]> > wrote: > > > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302382 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
