SQL Blank Title 73180

system · January 20, 2009, 11:53am

Thanks to all for your input.......this helps!

From: Hernandez, Dolores
Sent: Tuesday, January 20, 2009 9:07 AM
To: vantage@yahoogroups.com
Subject: SQL

I am about to take a course that will help me with writing queries in
SQL. My question to the group is that this course is taught using
Transact-SQL. Will that still be useful given that we don't use a SQL
server.

Thanks,

------------------------------------------------------------------------
---

Dolores Hernandez

Software/Database Analyst

713-896-5178

dhernandez@...

[Non-text portions of this message have been removed]

system · January 20, 2009, 10:05am

I am about to take a course that will help me with writing queries in
SQL. My question to the group is that this course is taught using
Transact-SQL. Will that still be useful given that we don't use a SQL
server.

Thanks,

------------------------------------------------------------------------
---

Dolores Hernandez

Software/Database Analyst

713-896-5178

dhernandez@...

[Non-text portions of this message have been removed]

system · January 20, 2009, 10:49am

I don't know what Transact-SQL is, but if I were you, I would take
advantage of learning SQL via any method.

We are on a Progress database and we do not use ODBC for any Vantage
reports.

However, when I am troubleshooting a problematic BAQ, I find it very
useful to re-create the BAQ in another software by writing a SQL
query and use ODBC. It is a quick and easy troubleshooting tool for
me.

Lynn

--- In vantage@yahoogroups.com, "Hernandez, Dolores" <dhernandez@...>
wrote:

>
> I am about to take a course that will help me with writing queries

in

> SQL. My question to the group is that this course is taught using
> Transact-SQL. Will that still be useful given that we don't use a

SQL

> server.
>
> Thanks,
>
>
>
> --------------------------------------------------------------------

----

> ---
>
> Dolores Hernandez
>
> Software/Database Analyst
>
> 713-896-5178
>
> dhernandez@...
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 20, 2009, 11:32am

Transact SQL is the standard used by most DBMS.

Know transact is good to know for lots of different situations when dealing
with DBs. If you are on a progress system it doesn't do you nearly as much
as it would if you were on MSSQL. They hide a lot of the ability to run
transact up against the DB.

But using an odbc with transact is very good knowledge.

In this day and age knowing transact is a must just for about every IT
person IMO.

~Charlie
________________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Lynn
Sent: Tuesday, January 20, 2009 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: SQL

I don't know what Transact-SQL is, but if I were you, I would take
advantage of learning SQL via any method.

We are on a Progress database and we do not use ODBC for any Vantage
reports.

However, when I am troubleshooting a problematic BAQ, I find it very
useful to re-create the BAQ in another software by writing a SQL
query and use ODBC. It is a quick and easy troubleshooting tool for
me.

Lynn

--- In vantage@yahoogroups.com, "Hernandez, Dolores" <dhernandez@...>
wrote:

>
> I am about to take a course that will help me with writing queries

in

> SQL. My question to the group is that this course is taught using
> Transact-SQL. Will that still be useful given that we don't use a

SQL

> server.
>
> Thanks,
>
>
>
> ----------------------------------------------------------

----

> ---
>
> Dolores Hernandez
>
> Software/Database Analyst
>
> 713-896-5178
>
> dhernandez@...
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 20, 2009, 11:32am

Dolores,

Transact SQL is a superset of SQL 92 and contains a set of additional
commands specific to SQL Server/Sybase. If the course is
predominantly centered on SQL theory and not the commands that are
specific to transact SQL then you will be well served. If, however,
the course is primarily about teaching commands specific to transact
SQL, then it will provide little, if any, value for your Progress
queries.

Best Regards,

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

This email, and any attachments thereto, is intended only for use by
the addressee(s) named herein and may contain legally privileged and/
or confidential information. If you are not the intended recipient of
this email, you are hereby notified that any dissemination,
distribution or copying of this email, and any attachments thereto, is
strictly prohibited. If you have received this email in error, please
immediately notify me by telephone and permanently delete the original
and any copy of any email and any printout thereof.

On Jan 20, 2009, at 7:06 AM, Hernandez, Dolores wrote:

> I am about to take a course that will help me with writing queries in
> SQL. My question to the group is that this course is taught using
> Transact-SQL. Will that still be useful given that we don't use a SQL
> server.
>
> Thanks,
>
> ----------------------------------------------------------
> ---
>
> Dolores Hernandez
>
> Software/Database Analyst
>
> 713-896-5178
>
> dhernandez@...
>
> [Non-text portions of this message have been removed]
>
>
>

[Non-text portions of this message have been removed]

system · January 20, 2009, 11:34am

Progress uses transact it's just buried in there. It is hidden in behind all
the 4GL.

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Michael Barry
Sent: Tuesday, January 20, 2009 11:32 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] SQL

Dolores,

Transact SQL is a superset of SQL 92 and contains a set of additional
commands specific to SQL Server/Sybase. If the course is
predominantly centered on SQL theory and not the commands that are
specific to transact SQL then you will be well served. If, however,
the course is primarily about teaching commands specific to transact
SQL, then it will provide little, if any, value for your Progress
queries.

Best Regards,

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia <http://www.aspacia.com/> com/

This email, and any attachments thereto, is intended only for use by
the addressee(s) named herein and may contain legally privileged and/
or confidential information. If you are not the intended recipient of
this email, you are hereby notified that any dissemination,
distribution or copying of this email, and any attachments thereto, is
strictly prohibited. If you have received this email in error, please
immediately notify me by telephone and permanently delete the original
and any copy of any email and any printout thereof.

On Jan 20, 2009, at 7:06 AM, Hernandez, Dolores wrote:

> I am about to take a course that will help me with writing queries in
> SQL. My question to the group is that this course is taught using
> Transact-SQL. Will that still be useful given that we don't use a SQL
> server.
>
> Thanks,
>
> ----------------------------------------------------------
> ---
>
> Dolores Hernandez
>
> Software/Database Analyst
>
> 713-896-5178
>
> dhernandez@energycr <mailto:dhernandez%40energycranes.com> anes.com
>
> [Non-text portions of this message have been removed]
>
>
>

[Non-text portions of this message have been removed]

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.10/1904 - Release Date: 1/20/2009
7:49 AM

[Non-text portions of this message have been removed]