Author: Cindy Winegarden
Posted: 2000-07-03 at 10:57:17
FYI to all, SQL For Smarties is now in its Second Edition.
From the preface:
"I have reorganized this book quite a bit since the first edition.
Many of the previous sections have been moved to new locations and
expanded. I have also dropped a lot of the more theoretical material
in favor of more programming methods. Don't worry; the theory stuff
has been moved to the next book in this series, 'Data and Databases.'"
Cindy Winegarden
Microsoft Certified Professional, Visual FoxPro
Duke Children's Information Systems
Duke University Medical Center
cindyw@duke.edu
----- Original Message -----
From: "jgunva - John C. Gunvaldson (DQ)" <jgunvaldson@dataquick.com>
To: "Multiple recipients of ProFox" <profox@leafe.com>
Sent: Monday, July 03, 2000 11:16 AM
Subject: RE: Transact-SQL
| 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
|
|
|
|
| ----------------------------------------
| Subscription maintenance at:
| http://leafe.com/mailListMaint.html
|
|
|
|