select f1 from b_compte
go
select f1,f2 as ff2 from b_compte t1, b_titre t2
go
select f1,f2 as ff2 from b_compte as t1, b_titre t2
go
select * from b_compte t1, b_titre t2
go
select count(*) from b_compte
go
select count(*) as cc from b_compte
go
select count(*) from b_compte where a=b
go
select count(*) from b_compte where a=b and b=c or c=d
go
select count(*) from b_compte where a-1=b+1+2 and b=c or c=d
go
select count(*) from b_compte where (a-1=b+1+4) and b=c or c=d
go
select count(*) from b_compte where a < 1
go
select count(*) from b_compte where a < trim(1,"allo")
go
select count(*) from b_compte where a < trim(2,"allo")
go
select count(*) from b_compte where a < trim(3,"xoxo")
go
select top 10 * from b_compte
go
select top 10 * from b_compte where a < b < c
go
select top 10 * from b_compte where a = b and a in (1,2,3)
go
select top 10 * from b_compte where a = b and a not in (1,2,3)
go
select top 10 * from b_compte where a = b and a in ('1',"2",'3')
go
select top 10 * from b_compte where a = b and a like '%hello%'
go
select top 10 * from b_compte where a = b and a not like '%hello%'
go
select top 10 * from b_compte where a = b and a not like '%hello%' group by f1,f2 order by f1 asc, f2 desc
go
select top 20 toto0, convert(1,2,3) as toto, toto2 from b_compte
go
select bidule = f1 + 1 from b_compte
go
select a,b from b_compte t1 join b_client on b_compte.no_compte = b_client.no_compte
go
select a,b from b_compte t1 join b_client on b_compte.no_compte = b_client.no_compte join b_titre on b_titre.security=b_compte.security
go
select a,b from b_compte t1 left outer join b_client on b_compte.no_compte = b_client.no_compte
go
select a,b from b_compte t1 join (select secur,firme from b_titre where secur=firme) t2 on t1.no_compte = t2.secur
go
select a from b_compte where a in (select user_num from b_user)
go
select a,b from b_compte t1 join b_client bcli on b_compte.no_compte = b_client.no_compte
go
update b_compte set a=1+b, b=2 where no_compte = 2
go
update b_compte set a=1+b, b=2 from #comptes where no_compte = 2
go
update b_compte set a=1+b, b=2 from #comptes t1 where no_compte = 2
go
update b_compte set a=1+b, b=2 from b_compte t1 join b_titre on b_titre.compte=t1.compte where no_compte = 2
go
delete b_compte where a=1+b and b<c
go
delete b_compte from tb tb1, autretb tb2 where a=1+b and b<c
go
select a,b from tb where a is null and b is not null
go
select a,b from tb where a = (select max(a) from tb)
go
update tb set a=(select max(a+1,2) from tb2)
go


select case when 1=2 then a1 else a2+1 as toto, toto2 from b_compte
go
select case when (1=2) then a1 else a2+1 as toto, toto2 from b_compte
go
select case when (1=2) then a1+b else a2+1 as toto, toto2 from b_compte
go
select case when (1=2) then when a < b then a1+b else a2+1 end else a3 end as toto, toto2 from b_compte
go
select bidule = case when (no_compte < 10) then convert(no_compte,1) else no_compte-1 end from b_compte
go
select a from tb where a = case when (case when a=b then then2 else else2 end) then then1 else else1 end
go
select a from tb where a = case when (case when a=b then then2 else else2 end) then then1 else (case when (x=y) then then3 else else3 end) end
go
select a from tb where a = case when b in (1,2) then 3 else 4 end
go

select distinct user_num, titre from b_user
go
drop table t1
go
drop table t1 drop table t2
go
set rowcount 10000
go
if (select object_id('#TransFilter')) is not null begin drop table #TransFilter end
go
select 1+1
go
select a from tb order by (f1) asc
go
insert into tb (a,b,c) values (1+1,2,"allo",'allo',"al""lo""")
go
select a from tb order by  f1,f2,f3
go
select a from tb (index itb)
go
select a from tb tb1 (index itb), tb2 (index itb2) where tb1.a=10
go
select a from tb where exists(select 1 from tb2)
go
select a from tb where not exists(select 1 from tb2)
go
select t0 t0#security from tb
go
create unique index PerformanceIndex2 on #Performance(INCEPTIONSTATE,  NO_COMPTE, DATE_MAJ)
go
create index PerformanceIndex2 on #Performance(INCEPTIONSTATE,  NO_COMPTE, DATE_MAJ)
go
create clustered index PerformanceIndex2 on #Performance(INCEPTIONSTATE,  NO_COMPTE, DATE_MAJ)
go
select a from tb union select b from ta order by a desc union select 10000
go
select 10 select 20
go
select a from tb where b in (NULL,1,2,3)
go
select a from tb where a+1 between b+2 and c-1 and x < y
go
truncate table toto
go
select 1 + /* allo */ /* autre */ 1
go
select 1 -- allo 
 + 1
go
use this_table
go
insert into B_SNAPSHOT_ACCOUNT select 20081766, id from #temp
go
select a from t1, tb2 where tb1.a *= tb2.a
go
select 1+2+3 from tb where a<1
go
select a,b,c from tb where a in (1,2,3,4,5,6,7,8,9)
go
select a,b,c from tb where a in ('a',1,2,3,4,5,6,7,8,9)
go
select a,b,c from tb where a in ('a','allo','cccc','ddd')
go
create clustered index #BRISEBO0_VAL_DoubleValue on #BRISEBO0 (VAL_DoubleValue)
go
select a from #table
go