Enter your email address:

Delivered by FeedBurner



Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Saturday, March 29, 2014 – Permalink –

SQL Statements Automatically

Hidden code


If you're having trouble figuring out a complex SQL statement for use in code, you may be able to simplify the process by first setting it up the query you want in the query design grid.

Once you've got it configured correctly, choose View >SQL view to reveal the underlying SQL statement, which you can copy and paste into your code.

You may have to make minor modifications, but this technique often eliminates much of the hassle of manually constructing SQL statements.

You can also tweak the underlying SQL code to adjust your Query. This code can also be copied and reused in other Queries after a little customizing.


See all Topics

Labels: , , , , ,


<Doug Klippert@ 3:23 AM

Comments: Post a Comment