Author: jgunva - John C. Gunvaldson (DQ)
Posted: 2000-07-03 at 10:16:01
Hi Anders,
I'm not sure I would disagree...
I do about 60/40 VFP/SQL design here at the office. Allot of DTS sessions
and Stored Procedure writes in support of our internet products.
I know dozens of ways to do data manipulation in FoxPro - and continue to
seek equivalent (ease of use) in the T-SQL calls and functions... Not an
easy translation - in most cases...
To that end - I just ran out last Friday (coincidently) and bought "Joe
Celko's - SQL for Smarties". What intrigued me was the play on the dummies
books (which I never like those title anyway <g>)... Also bought "Robert
Vieira's" "Professional SQL Server 7.0 programming" from Wrox press - I was
scanning chapters - and liked the way this book emphasis programming - and
not administration.
"SQL for Smarties" seems to have allot of very clever code examples - and
looks like fun reading. Maybe I can get a handle on this "Diseased Mutant...
<g>"
Cheers,
John C. Gunvaldson, CNE, MCP
Database Developer
-----Original Message-----
From: profox@leafe.com [mailto:profox@leafe.com]On Behalf Of Anders
Altberg
Sent: Monday, July 03, 2000 1:31 AM
To: Multiple recipients of ProFox
Subject: Re: Transact-SQL
"T-SQL is ANSI-92 equiv SQL language ", that's not an opinion all members of
the SQL committee share. Joe Celko calls T-SQL a "diseased mutant product"
<s>.
----- Original Message -----
From: "John C. Gunvaldson, CNE, MCP" <jgunvaldson@home.com>
To: "Multiple recipients of ProFox" <profox@leafe.com>
Sent: Monday, July 03, 2000 4:00 AM
Subject: RE: Transact-SQL
> Ah,
>
> My favorite topic - T-SQL is ANSI-92 equiv SQL language incorporated by
> Microsoft SQL Server and SYBASE SQL Server.
>
> Sybase and Microsoft have altered T-SQL under each care - but most
commands
> are still the same.
>
> T-SQL, the language, can be found in SQL Stored Procedures, Triggers,
> Scripts and various implementations of the DTS Sessions...
>
> hth - more?
>
> John C. Gunvaldson, CNE, MCP
> San Diego, CA
>
>
> -----Original Message-----
> From: profox@leafe.com [mailto:profox@leafe.com]On Behalf Of
> Gregoryagu@aol.com
> Sent: Sunday, July 02, 2000 6:52 PM
> To: Multiple recipients of ProFox
> Subject: Transact-SQL
>
>
>
> Can someone tell me what "Transact-SQL" is, as in the following:
>
> 'Although VFP and Transact-SQL have some functions in common, many VFP
> functions aren't supported by SQL Server.'
>
>
>
> Gregory A. Gum
> Dallas Texas
>
>
> ----------------------------------------
> Subscription maintenance at:
> http://leafe.com/mailListMaint.html
>
>
>
>
>
> ----------------------------------------
> Subscription maintenance at:
> http://leafe.com/mailListMaint.html
>
>
----------------------------------------
Subscription maintenance at:
http://leafe.com/mailListMaint.html