create table #temp1 ( id int, year1 int, count1 int ) --drop table #temp1 insert into #temp1 values (1,2001,200) insert into #temp1...

create table #duplicaterows ( id int, name varchar(50) ) go insert into #duplicaterows select 200,'anurag' union all select 200,'anurag' union all...

select unicode('A')--65 select unicode('a')--97 select unicode('Abfdgdfg')--65 select unicode('12')--49 select ascii('A')--65 select ascii('a')--97 select...

create table #quotetable (  name varchar(100) ) insert into #quotetable select 'Anurag' select quotename(name) from #quotetable-----[Anurag] select...

create table cummulativetable ( salary int ) insert into cummulativetable values(100) insert into cummulativetable values(200) insert into cummulativetable...