General SQL Question

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mark R
    #1

    General SQL Question

    Hi all,
    This query is not too specific, I was just curious. An application at work retrieves data from SQL server. One SQL that is used runs 3 at the same time and returns the results together in notepad. Each SQL has it's own header with the results underneath. I have looked at the SQL and as soon as the first finishes, the second starts and so on. All 3 SQL's are querying the same table.

    I have tried writing a SQL in the same format within access but it does not work. I have also tried the same thing with our work's oracle database and again, no joy. Is the ability to do this available to SQL server only??

    TIA

    Mark
    Tags: None
    • '69 Camaro
      #2
      Re: General SQL Question

      Hi, Mark.

      What you saw is Transact-SQL (or T-SQL, for short) for a batch job, or
      execution of SQL statements in sequence. Unfortunately, Access isn't
      capable of batch jobs. Access allows only one valid SQL statement per
      query. Oracle is also capable of running a batch of SQL statements, but
      you'll have to use one of Oracle's proprietary SQL programming languages,
      like PL/SQL or SQL*Plus, just like SQL Server uses its own proprietary
      programming language, T-SQL.

      HTH.

      Gunny

      See http://www.QBuilt.com for all your database needs.
      See http://www.Access.QBuilt.com for Microsoft Access tips.


      "Mark R" <mark.reed75@nt lworld.com> wrote in message
      news:k0mTc.483$ Ho4.274@newsfe1-gui.ntli.net...
      Hi all,
      This query is not too specific, I was just curious. An application at
      work retrieves data from SQL server. One SQL that is used runs 3 at the same
      time and returns the results together in notepad. Each SQL has it's own
      header with the results underneath. I have looked at the SQL and as soon as
      the first finishes, the second starts and so on. All 3 SQL's are querying
      the same table.

      I have tried writing a SQL in the same format within access but it does not
      work. I have also tried the same thing with our work's oracle database and
      again, no joy. Is the ability to do this available to SQL server only??

      TIA

      Mark


        Comment

        • 66 Corvette
          #3
          Re: General SQL Question


          GET A REAL CAR!


          "'69 Camaro" <Black_hole.To. 69Camaro@Spamea ter.org> wrote in message
          news:8ZlTc.3055 $io1.686@nwrddc 02.gnilink.net. ..[color=blue]
          > Hi, Mark.
          >
          > What you saw is Transact-SQL (or T-SQL, for short) for a batch job, or
          > execution of SQL statements in sequence. Unfortunately, Access isn't
          > capable of batch jobs. Access allows only one valid SQL statement per
          > query. Oracle is also capable of running a batch of SQL statements, but
          > you'll have to use one of Oracle's proprietary SQL programming languages,
          > like PL/SQL or SQL*Plus, just like SQL Server uses its own proprietary
          > programming language, T-SQL.
          >
          > HTH.
          >
          > Gunny
          >
          > See http://www.QBuilt.com for all your database needs.
          > See http://www.Access.QBuilt.com for Microsoft Access tips.
          >
          >
          > "Mark R" <mark.reed75@nt lworld.com> wrote in message
          > news:k0mTc.483$ Ho4.274@newsfe1-gui.ntli.net...
          > Hi all,
          > This query is not too specific, I was just curious. An application at
          > work retrieves data from SQL server. One SQL that is used runs 3 at the[/color]
          same[color=blue]
          > time and returns the results together in notepad. Each SQL has it's own
          > header with the results underneath. I have looked at the SQL and as soon[/color]
          as[color=blue]
          > the first finishes, the second starts and so on. All 3 SQL's are querying
          > the same table.
          >
          > I have tried writing a SQL in the same format within access but it does[/color]
          not[color=blue]
          > work. I have also tried the same thing with our work's oracle database and
          > again, no joy. Is the ability to do this available to SQL server only??
          >
          > TIA
          >
          > Mark
          >
          >[/color]


            Comment

            • '69 Camaro
              #4
              Re: General SQL Question

              At least I can bring up to four buddies with me to go cruisin' and my auto
              insurance was never more expensive than my mortgage payment! ;-)

              Gunny

              "66 Corvette" <427@horsepower .net> wrote in message
              news:N7tTc.1721 4$yi6.13152@cyc lops.nntpserver .com...[color=blue]
              >
              > GET A REAL CAR!
              >
              >
              > "'69 Camaro" <Black_hole.To. 69Camaro@Spamea ter.org> wrote in message
              > news:8ZlTc.3055 $io1.686@nwrddc 02.gnilink.net. ..[color=green]
              > > Hi, Mark.
              > >
              > > What you saw is Transact-SQL (or T-SQL, for short) for a batch job, or
              > > execution of SQL statements in sequence. Unfortunately, Access isn't
              > > capable of batch jobs. Access allows only one valid SQL statement per
              > > query. Oracle is also capable of running a batch of SQL statements, but
              > > you'll have to use one of Oracle's proprietary SQL programming[/color][/color]
              languages,[color=blue][color=green]
              > > like PL/SQL or SQL*Plus, just like SQL Server uses its own proprietary
              > > programming language, T-SQL.
              > >
              > > HTH.
              > >
              > > Gunny
              > >
              > > See http://www.QBuilt.com for all your database needs.
              > > See http://www.Access.QBuilt.com for Microsoft Access tips.
              > >
              > >
              > > "Mark R" <mark.reed75@nt lworld.com> wrote in message
              > > news:k0mTc.483$ Ho4.274@newsfe1-gui.ntli.net...
              > > Hi all,
              > > This query is not too specific, I was just curious. An application[/color][/color]
              at[color=blue][color=green]
              > > work retrieves data from SQL server. One SQL that is used runs 3 at the[/color]
              > same[color=green]
              > > time and returns the results together in notepad. Each SQL has it's own
              > > header with the results underneath. I have looked at the SQL and as soon[/color]
              > as[color=green]
              > > the first finishes, the second starts and so on. All 3 SQL's are[/color][/color]
              querying[color=blue][color=green]
              > > the same table.
              > >
              > > I have tried writing a SQL in the same format within access but it does[/color]
              > not[color=green]
              > > work. I have also tried the same thing with our work's oracle database[/color][/color]
              and[color=blue][color=green]
              > > again, no joy. Is the ability to do this available to SQL server only??
              > >
              > > TIA
              > >
              > > Mark
              > >
              > >[/color]
              >
              >[/color]


                Comment

                • Mark R
                  #5
                  Re: General SQL Question

                  Cheers for that!!!
                  "'69 Camaro" <Black_hole.To. 69Camaro@Spamea ter.org> wrote in message news:8ZlTc.3055 $io1.686@nwrddc 02.gnilink.net. ..
                  Hi, Mark.

                  What you saw is Transact-SQL (or T-SQL, for short) for a batch job, or
                  execution of SQL statements in sequence. Unfortunately, Access isn't
                  capable of batch jobs. Access allows only one valid SQL statement per
                  query. Oracle is also capable of running a batch of SQL statements, but
                  you'll have to use one of Oracle's proprietary SQL programming languages,
                  like PL/SQL or SQL*Plus, just like SQL Server uses its own proprietary
                  programming language, T-SQL.

                  HTH.

                  Gunny

                  See http://www.QBuilt.com for all your database needs.
                  See http://www.Access.QBuilt.com for Microsoft Access tips.


                  "Mark R" <mark.reed75@nt lworld.com> wrote in message
                  news:k0mTc.483$ Ho4.274@newsfe1-gui.ntli.net...
                  Hi all,
                  This query is not too specific, I was just curious. An application at
                  work retrieves data from SQL server. One SQL that is used runs 3 at the same
                  time and returns the results together in notepad. Each SQL has it's own
                  header with the results underneath. I have looked at the SQL and as soon as
                  the first finishes, the second starts and so on. All 3 SQL's are querying
                  the same table.

                  I have tried writing a SQL in the same format within access but it does not
                  work. I have also tried the same thing with our work's oracle database and
                  again, no joy. Is the ability to do this available to SQL server only??

                  TIA

                  Mark


                    Comment

                    • '69 Camaro
                      #6
                      Re: General SQL Question

                      You're welcome!
                      "Mark R" <mark.reed75@nt lworld.com> wrote in message
                      news:RODTc.87$X u.82@newsfe4-gui.ntli.net...
                      Cheers for that!!!
                      "'69 Camaro" <Black_hole.To. 69Camaro@Spamea ter.org> wrote in message
                      news:8ZlTc.3055 $io1.686@nwrddc 02.gnilink.net. ..
                      Hi, Mark.

                      What you saw is Transact-SQL (or T-SQL, for short) for a batch job, or
                      execution of SQL statements in sequence. Unfortunately, Access isn't
                      capable of batch jobs. Access allows only one valid SQL statement per
                      query. Oracle is also capable of running a batch of SQL statements, but
                      you'll have to use one of Oracle's proprietary SQL programming languages,
                      like PL/SQL or SQL*Plus, just like SQL Server uses its own proprietary
                      programming language, T-SQL.

                      HTH.

                      Gunny

                      See http://www.QBuilt.com for all your database needs.
                      See http://www.Access.QBuilt.com for Microsoft Access tips.


                      "Mark R" <mark.reed75@nt lworld.com> wrote in message
                      news:k0mTc.483$ Ho4.274@newsfe1-gui.ntli.net...
                      Hi all,
                      This query is not too specific, I was just curious. An application at
                      work retrieves data from SQL server. One SQL that is used runs 3 at the
                      same
                      time and returns the results together in notepad. Each SQL has it's own
                      header with the results underneath. I have looked at the SQL and as soon
                      as
                      the first finishes, the second starts and so on. All 3 SQL's are querying
                      the same table.

                      I have tried writing a SQL in the same format within access but it does
                      not
                      work. I have also tried the same thing with our work's oracle database and
                      again, no joy. Is the ability to do this available to SQL server only??

                      TIA

                      Mark



                        Comment

                        Previous template Next
                        Working...