Re: [firebird-support] Book on T-SQL

2018-04-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18-4-2018 18:15, blackfalconsoftw...@outlook.com [firebird-support] wrote: > One of the newer and nice error trapping features in T-SQL is the > implementation of the "Try-Catch" block, which I used quite a bit when > working on developing corporate databases. That is supported in Firebird

Re: [firebird-support] Book on T-SQL

2018-04-18 Thread blackfalconsoftw...@outlook.com [firebird-support]
Mark... One of the newer and nice error trapping features in T-SQL is the implementation of the "Try-Catch" block, which I used quite a bit when working on developing corporate databases. Another was the use of "select" to to test out functionality. for example, with T-SQL in a database

Re: [firebird-support] Book on T-SQL

2018-04-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18-4-2018 16:55, blackfalconsoftw...@outlook.com [firebird-support] wrote: > I have to disagree with your observation.  It is clearly stated in the > Firebird SQL Reference Manual that the development of Firebird-SQL is > with a strict implementation of the SQL-92 Standard. Could you

Re: [firebird-support] Book on T-SQL

2018-04-18 Thread blackfalconsoftw...@outlook.com [firebird-support]
I have to disagree with your observation. It is clearly stated in the Firebird SQL Reference Manual that the development of Firebird-SQL is with a strict implementation of the SQL-92 Standard. This is not to say that Firebird-SQL does not go beyond the SQL-92 Standard but it is somewhat

Re: [firebird-support] Book on T-SQL

2018-04-18 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi Steve, can you point me into one example about sentence mentioned by you"Firebird's implementation of SQL is a very strict implementation of the SQL-92 Standard.  As a result, this makes Firebird-SQL not only very limited in what it can do when compared to other SQL dialects but extremely

Re: [firebird-support] Book on T-SQL

2018-04-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18-4-2018 16:27, blackfalconsoftw...@outlook.com [firebird-support] wrote: > Firebird's implementation of SQL is a very strict implementation of the > SQL-92 Standard.  As a result, this makes Firebird-SQL not only very > limited in what it can do when compared to other SQL dialects but >

Re: [firebird-support] Book on T-SQL

2018-04-18 Thread blackfalconsoftw...@outlook.com [firebird-support]
I just wanted to follow up on this thread about learning Firebird-SQL since I have extensive experience with using SQL with a variety of database engines over a very long career. That being said, the gentleman who stated that you cannot use T-SQL with Firebird is primarily correct and learning

Re: [firebird-support] Book on T-SQL

2018-04-18 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
All In All, Thank You Everyone for the suggestion and Support.  On Wednesday, 18 April, 2018, 4:00:47 PM IST, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:   On 2018-04-18 12:24, Vishal Tiwari vishuals...@yahoo.co.in

Re: [firebird-support] Book on T-SQL

2018-04-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2018-04-18 12:24, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > Hi Mark, > > I want to use TSQL in Firebird, as I was going through some online > post at expert exchange where someone asked that can we use TSQL in > firebird, then the answer that not fully but upto some

Re: [firebird-support] Book on T-SQL

2018-04-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.04.2018 12:24, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > I want to use TSQL in Firebird Give up. Firebird supports standard SQL to some extend. T-SQL supports standard SQL to some extend. Firebird has no support for T-SQL. -- WBR, SD.

Re: [firebird-support] Book on T-SQL

2018-04-18 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
Hi Mark, I want to use TSQL in Firebird, as I was going through some online post at expert exchange where someone asked that can we use TSQL in firebird, then the answer that not fully but upto some extend we can use. That's the reason I wanted to learn TSQL from firebird point of view. On

Re: [firebird-support] Book on T-SQL

2018-04-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2018-04-18 06:14, 'Live.com Email' emendez...@nc.rr.com [firebird-support] wrote: > Vishal, > > The word “T-SQL” usually means transact SQL and that relates > mostly to SQL Server. So if you search on TSQL you will get lots of > hits pertaining to SQL Server. I’ve been working with FIREBIRD

Re: [firebird-support] Book on T-SQL

2018-04-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2018-04-18 08:57, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > Hi Edward Mendez, > > I totally agree with you that this Firebird group has also helped me > immensely, in my critical situations. > > Thank you so much for the replay and suggestions. I would go through >

Re: RE: [firebird-support] Book on T-SQL

2018-04-18 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
ps.com> Subject: [firebird-support] Book on T-SQL     Hi All,   I would like to know if there is any dedicated book with good examples on T-SQL.   I have googled and found that T-SQL Querying, T-SQL Fundamentals etc books   But it seems that they are mainly dedicated to SQL Server datab

RE: [firebird-support] Book on T-SQL

2018-04-17 Thread 'Live.com Email' emendez...@nc.rr.com [firebird-support]
com> Sent: Tuesday, April 17, 2018 11:33 PM To: Firebird-support <firebird-support@yahoogroups.com> Subject: [firebird-support] Book on T-SQL Hi All, I would like to know if there is any dedicated book with good examples on T-SQL. I have googled and found that T-SQL Que

[firebird-support] Book on T-SQL

2018-04-17 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
Hi All, I would like to know if there is any dedicated book with good examples on T-SQL. I have googled and found that T-SQL Querying, T-SQL Fundamentals etc books... But it seems that they are mainly dedicated to SQL Server database.a nd talk lot of stuffs on other stuffs in database. Since I