StumbleUpon  Del.icio.us  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

FROM
(
SELECT * FROM tbl_union_first
UNION
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 Nulgath Secret Walkthrough