Hi Gopi,

select * into TestTable from

(

select CAST(1 as smallint) as C1, CAST(6 as smallint) as C2

union

select CAST(2 as tinyint),CAST(6 as int)

union

select CAST(3 as bigint),CAST(6 as smallint)

union

select CAST(4 as int),CAST(6 as tinyint)

) T

Note: Good only....

But u've given only these are the orderwise datatype based on size . but i need how i can come to know query wise.. plz will u give example and we must see the difference in that example visually.