Transfer Data using Select into

Posted Date: 26 Oct 2009	Resource Type: Articles	Category: Databases
Author: Rajesh.Dharmakkan	Member Level: Gold
Rating:	Points: 10 (Rs 2)

Transfer Data using Select into

We can transfer data from one table to another without using cursor. This select into is used to transfer the data when the table is not created. The selected values will be transferred to the new table which automatically created.

Syntax.

Select col, Col2 …… into NewTable
from OldTable
Where Condition

The selected no of columns and its data will transferred to the new Table “NewTableName”. We can control the no of rows by using the where condition.
The no of columns which can control in the select query.

This is the efficient way of transferring data from one table to another table.

If you want to transfer data to the old column use insert into command.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Transer data from one table to another . Select into . Move data to another table .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Cluster Index and Non-Cluster Index
	Previous Resource: Datatype conversion in SQL Server
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

More Resources