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:
On 7/2/2000 9:51 PM, Gregoryagu@aol.com supposedly said:
>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.'
Transact-SQL is the SQL language used to work with Microsoft SQL
Server. You can read about it on Microsoft's site at
http://msdn.microsoft.com/library/, and then looking under Platform SDK/
Data Access Services/ Microsoft SQL Server.
___/
/
__/
/
____/
Ed Leafe
Transact-SQL is the version of ANSI SQL-92 (plus enhancements) which
MS SQL-Server supports. The enhancements to ANSI SQL are usually
things like date handling functions.
Examples of VFP functions which are not supported by SQL Server are
INLIST (use IN ( , , ,) )
DTOC (use CAST)
In other words, for most VFP functions there is a corresponding SQL
function, but they do not always have the same name or function
exactly the same way.
It's important to know the differences when writing a SELECT statement
against Fox tables which may eventually be migrated to an SQL
database.
Other SQL databases like Oracle have different enhancements to the
SQL-92 standard.
Cindy Winegarden
Microsoft Certified Professional, Visual FoxPro
Duke Children's Information Systems
Duke University Medical Center
cindyw@duke.edu
----- Original Message -----
From: <Gregoryagu@aol.com>
To: "Multiple recipients of ProFox" <profox@leafe.com>
Sent: Sunday, July 02, 2000 9:51 PM
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
|
|
|
|
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
In a message dated 7/2/00 9:05:58 PM Central Daylight Time,
jgunvaldson@home.com writes:
<< 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? >>
No, that was just what I needed. :)
I went to the URL that Ed gave me. I didn't know that MSDN had a Full
library online, and then I found I didn't know that it is on my latest MSDN
CD. Talk about circular logic - going out to the web to find something, only
to find it at home.
Thanks to all.
Gregory A. Gum
Dallas Texas
"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
>
>
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
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
|
|
|
|
I am using SQL Server 2000 and need to check for NULL. i.e. SELECT *
FROM tablename WHERE column = NULL
How is this accomplished? Thanks.
Tim Grahl
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
Yeah I sent this at like 8:00AM EST this morning. I figured it out
after all :P
Tim Grahl
-----Original Message-----
From: Timothy Grahl
Sent: Tuesday, July 13, 2004 7:58 AM
To: ProFox Email List
Subject: [NF] Checking for NULL with Transact SQL
I am using SQL Server 2000 and need to check for NULL. i.e. SELECT *
FROM tablename WHERE column = NULL
How is this accomplished? Thanks.
Tim Grahl
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]