Technical questions

From: eNerGiZer1010 (anonymous_at_discussions.microsoft.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 07:40:29 -0700

Hi folks,

I have a project underway and am having a couple
technical difficulties. My duty is to run my access
database with sql server.

My fist problem is for table jobs.
If I want to delete a certain number of JobId's what do I
have to write in the criteria. For example if I want to
delete IdJobs 19 750 to 19 760. What is the function that
will do so. What do I write in the criteria.

My second problem has to do with the query's.
I have a large number of lignes (enregistrements) that I
have to query. From what I heard the is a limited number
of lines allowed per query. How can disable that feature
to have unlimited lines for every query?

Finally my last problem is much more technical for you
sql wizards. I have a script to automate a query in
access. What I have to do is configure the script to be
compatible with sql server. So far it hasen't been that
easy. When I run the script it's giving me the error that
code 80040E21. The line is the following:

Else
        oRS.Open "Select * from AlertHistory Where Date
=#"&DateValue(LogTimeStamp)&"#;",oConn

What I think is that maybe the date format is not the
same because what I need is yyyy/MM/dd.

Could a genius figure this out. I need to run the script
to do a query in sql.

Thanks for all the help.

Cheers!!!

Relevant Pages

  • Re: Technical questions
    ... >technical difficulties. ... >of lines allowed per query. ... What I have to do is configure the script to be ... >compatible with sql server. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Just starting to learn it . . .
    ... > I can't get a script to run that's supposed to generate a Query ... the above is gibberish as far as SQL Server is concerned. ...
    (comp.databases.ms-sqlserver)
  • Re: IS NULL not working in WHERE clause.
    ... is a DW fact table to be used in building Analysis Services cubes. ... The table create script for my smaller one day table is: ... I am running SQL Server 2000 EE. ... QUERY 2: ...
    (microsoft.public.sqlserver.programming)
  • Script error
    ... I´ve done one script where i verify the sql server version ... but if i comment the query the script runs without any ...
    (microsoft.public.sqlserver.server)
  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)