By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,461 Members | 2,184 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,461 IT Pros & Developers. It's quick & easy.

General SQL Question

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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" <ma*********@ntlworld.com> wrote in message
news:k0***************@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
Nov 13 '05 #2

P: n/a

GET A REAL CAR!
"'69 Camaro" <Bl********************@Spameater.org> wrote in message
news:8Z****************@nwrddc02.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" <ma*********@ntlworld.com> wrote in message
news:k0***************@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

Nov 13 '05 #3

P: n/a
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" <42*@horsepower.net> wrote in message
news:N7*******************@cyclops.nntpserver.com. ..

GET A REAL CAR!
"'69 Camaro" <Bl********************@Spameater.org> wrote in message
news:8Z****************@nwrddc02.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" <ma*********@ntlworld.com> wrote in message
news:k0***************@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


Nov 13 '05 #4

P: n/a
Cheers for that!!!
"'69 Camaro" <Bl********************@Spameater.org> wrote in message news:8Z****************@nwrddc02.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" <ma*********@ntlworld.com> wrote in message
news:k0***************@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
Nov 13 '05 #5

P: n/a
You're welcome!
"Mark R" <ma*********@ntlworld.com> wrote in message
news:RO************@newsfe4-gui.ntli.net...
Cheers for that!!!
"'69 Camaro" <Bl********************@Spameater.org> wrote in message
news:8Z****************@nwrddc02.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" <ma*********@ntlworld.com> wrote in message
news:k0***************@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

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.