what the use of into statement in SQL ?

Hi

we can use "INTO" statement in various situations...

Normally, when we copy an existing table into an another name.
SELECT * INTO NewTableName FROM ExistingTableName
GO
(or)
Asigning a column value into a variable inside the CURSOR

Note:
1. If you want to copy only the structure then simply include WHERE clause with FALSE condition
SELECT * INTO NewTableName FROM ExistingTableName WHERE 1=0
GO

I hope it would help to proceed further!

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions