we can use "INTO" statement in various situations...
Normally, when we copy an existing table into an another name.
SELECT * INTO NewTableName FROM ExistingTableName
Asigning a column value into a variable inside the CURSOR
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
I hope it would help to proceed further!
iLink Multitech Solutions