StumbleUpon  Facebook  Reddit  Add to diigo  

Follow - Monx007
Article Time Stamp: 21 September 2008, 14:52:46 GMT+7

Microsoft SQL (MS SQL): Sample SQL Script to Convert Union Query To A Select Into To Create A New Table

This example will show you how to use Select Into from Union Query (table tbl_union_first and table tbl_union_second) to get a new table (tbl_target) that contain all the data from the union tables.

SELECT * INTO tbl_target

SELECT * FROM tbl_union_first
SELECT * FROM tbl_union_second
) AS tbl_union_results

Article Source: Monx Digital Library

Copyrighted@ Monx Digital Library, otherwise stated
Use of our service is protected by our Terms of Use

 Back To Previous Page ...  




AQWorlds Banner