Re: SQL syntax

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Edward <nospam@xxxxxxxx> wrote in message
<news:GC_Ll.14500$BZ3.2656@xxxxxxxxxxxx>


I'm looking for a comprehensive guide to SQL syntax, but what I'm
finding is vague, general, and not providing diverse critical
accurate examples of using variables. I'm still looking.

First step - as advised previously - get yourself a book on SQL - it is a
completely different language to VB.
Second - always establish which database you are talking to - they do all
have different ideosyncrasies.
Third - test all queries out in the database first (such as SQL Query
Analyser etc).
Fourth - post questions on errors with queries to an appropriate newsgroup -
one that deals with the particular brand of SQL in use.
Fifth - make use of the Immediate widow when developing string concatination
of queries. Find out what the string concatination produces. Its a hell of
a lot more useful than posting code here and hoping someone else will: -
a) Do the concatinatiuon
b) Check the concatinated string.

SQL is not VB - VB can just create an SQL string and pass it to a database
for interpretation. Big difference.


--
Regards

Michael Cole


.

Relevant Pages

  • Advice Requested - We have created a decent Database - Now we need some decent Queries!
    ... We only need help with the SQL 2000 queries. ... dynamically build the query, as we don't know exactly how the user will ... query the database,. ...
    (microsoft.public.sqlserver.programming)
  • RE: convert query into the VB code
    ... you database size issue really is a non issue. ... I would suggest you just create a function that executes all the queries. ... "Juli Intern" wrote: ... I don't really care either it SQL within VB or Recordset procedure. ...
    (microsoft.public.access.queries)
  • Re: Inconsistent results with ADO.NET
    ... and also to use Sql Profiler to see what commands are executed. ... Making the connection to the database and filling the dataset ... ADO datasets with data for both of the main database queries. ... while they both return data on my development machine. ...
    (microsoft.public.dotnet.framework.adonet)
  • =?windows-1252?Q?Re=3A_DBA_Guru=3A_=2832bit=2C_2005=2C_600DB=92s=2C_Memory_issues?= =?windows
    ...  The database supports 3rd party software that has about 650 ... that kicks off 30 or so queries all at the same time. ... SQL Server’s memory. ... and handing out too much memory. ...
    (microsoft.public.sqlserver.server)
  • Re: Front End Database File Size
    ... Even though I know that it is more efficient to use saved queries, I change the SQL so much I end up constructing a lot of SQL in code ... ... Also, if the database is still under development, you will see lots of bloat ... I noticed that as the database is used, the size of the front-end mde file ...
    (microsoft.public.access.tablesdbdesign)