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] <firebird-support@yahoogroups.com> wrote: 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 extend we can > use. > > That's the reason I wanted to learn TSQL from firebird point of view.
You cannot use T-SQL in Firebird, because T-SQL is the SQL dialect specific to Microsoft SQL Server (and some variants of Sybase). For the SQL dialect you can use with Firebird, look no further than the Firebird 2.5 Language Reference (https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25.html) Mark #yiv5250121586 #yiv5250121586 -- #yiv5250121586ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5250121586 #yiv5250121586ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5250121586 #yiv5250121586ygrp-mkp #yiv5250121586hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5250121586 #yiv5250121586ygrp-mkp #yiv5250121586ads {margin-bottom:10px;}#yiv5250121586 #yiv5250121586ygrp-mkp .yiv5250121586ad {padding:0 0;}#yiv5250121586 #yiv5250121586ygrp-mkp .yiv5250121586ad p {margin:0;}#yiv5250121586 #yiv5250121586ygrp-mkp .yiv5250121586ad a {color:#0000ff;text-decoration:none;}#yiv5250121586 #yiv5250121586ygrp-sponsor #yiv5250121586ygrp-lc {font-family:Arial;}#yiv5250121586 #yiv5250121586ygrp-sponsor #yiv5250121586ygrp-lc #yiv5250121586hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5250121586 #yiv5250121586ygrp-sponsor #yiv5250121586ygrp-lc .yiv5250121586ad {margin-bottom:10px;padding:0 0;}#yiv5250121586 #yiv5250121586actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5250121586 #yiv5250121586activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5250121586 #yiv5250121586activity span {font-weight:700;}#yiv5250121586 #yiv5250121586activity span:first-child {text-transform:uppercase;}#yiv5250121586 #yiv5250121586activity span a {color:#5085b6;text-decoration:none;}#yiv5250121586 #yiv5250121586activity span span {color:#ff7900;}#yiv5250121586 #yiv5250121586activity span .yiv5250121586underline {text-decoration:underline;}#yiv5250121586 .yiv5250121586attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5250121586 .yiv5250121586attach div a {text-decoration:none;}#yiv5250121586 .yiv5250121586attach img {border:none;padding-right:5px;}#yiv5250121586 .yiv5250121586attach label {display:block;margin-bottom:5px;}#yiv5250121586 .yiv5250121586attach label a {text-decoration:none;}#yiv5250121586 blockquote {margin:0 0 0 4px;}#yiv5250121586 .yiv5250121586bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5250121586 .yiv5250121586bold a {text-decoration:none;}#yiv5250121586 dd.yiv5250121586last p a {font-family:Verdana;font-weight:700;}#yiv5250121586 dd.yiv5250121586last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5250121586 dd.yiv5250121586last p span.yiv5250121586yshortcuts {margin-right:0;}#yiv5250121586 div.yiv5250121586attach-table div div a {text-decoration:none;}#yiv5250121586 div.yiv5250121586attach-table {width:400px;}#yiv5250121586 div.yiv5250121586file-title a, #yiv5250121586 div.yiv5250121586file-title a:active, #yiv5250121586 div.yiv5250121586file-title a:hover, #yiv5250121586 div.yiv5250121586file-title a:visited {text-decoration:none;}#yiv5250121586 div.yiv5250121586photo-title a, #yiv5250121586 div.yiv5250121586photo-title a:active, #yiv5250121586 div.yiv5250121586photo-title a:hover, #yiv5250121586 div.yiv5250121586photo-title a:visited {text-decoration:none;}#yiv5250121586 div#yiv5250121586ygrp-mlmsg #yiv5250121586ygrp-msg p a span.yiv5250121586yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5250121586 .yiv5250121586green {color:#628c2a;}#yiv5250121586 .yiv5250121586MsoNormal {margin:0 0 0 0;}#yiv5250121586 o {font-size:0;}#yiv5250121586 #yiv5250121586photos div {float:left;width:72px;}#yiv5250121586 #yiv5250121586photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5250121586 #yiv5250121586photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5250121586 #yiv5250121586reco-category {font-size:77%;}#yiv5250121586 #yiv5250121586reco-desc {font-size:77%;}#yiv5250121586 .yiv5250121586replbq {margin:4px;}#yiv5250121586 #yiv5250121586ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5250121586 #yiv5250121586ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5250121586 #yiv5250121586ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5250121586 #yiv5250121586ygrp-mlmsg select, #yiv5250121586 input, #yiv5250121586 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5250121586 #yiv5250121586ygrp-mlmsg pre, #yiv5250121586 code {font:115% monospace;}#yiv5250121586 #yiv5250121586ygrp-mlmsg * {line-height:1.22em;}#yiv5250121586 #yiv5250121586ygrp-mlmsg #yiv5250121586logo {padding-bottom:10px;}#yiv5250121586 #yiv5250121586ygrp-msg p a {font-family:Verdana;}#yiv5250121586 #yiv5250121586ygrp-msg p#yiv5250121586attach-count span {color:#1E66AE;font-weight:700;}#yiv5250121586 #yiv5250121586ygrp-reco #yiv5250121586reco-head {color:#ff7900;font-weight:700;}#yiv5250121586 #yiv5250121586ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5250121586 #yiv5250121586ygrp-sponsor #yiv5250121586ov li a {font-size:130%;text-decoration:none;}#yiv5250121586 #yiv5250121586ygrp-sponsor #yiv5250121586ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5250121586 #yiv5250121586ygrp-sponsor #yiv5250121586ov ul {margin:0;padding:0 0 0 8px;}#yiv5250121586 #yiv5250121586ygrp-text {font-family:Georgia;}#yiv5250121586 #yiv5250121586ygrp-text p {margin:0 0 1em 0;}#yiv5250121586 #yiv5250121586ygrp-text tt {font-size:120%;}#yiv5250121586 #yiv5250121586ygrp-vital ul li:last-child {border-right:none !important;}#yiv5250121586