Thursday, 7 April 2011

select * into table2 from table1 where 1=0

I have table with name as table1 with 10 rows then what is the out put of

select *  into table2 from table1 where 1=0

ans:
table2 is created with 0 rows

reason for no rows: the where  condition 1=0 is always false so only table is going to created.

No comments:

Post a Comment