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

2018-04-18 Thread Daniel Rail dan...@accra.ca [firebird-support]

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]
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 the link. But I am still willing to know about T-SQL and how to write it. Thanking You Again And