1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135
|
USE TempDB GO CREATE TABLE Temp_Insert_T ( COLUMN1 NVARCHAR(MAX), COLUMN2 NVARCHAR(MAX), COLUMN3 NVARCHAR(MAX) ) GO INSERT Temp_Insert_T SELECT T_ID, T_NAME, T_AGE FROM Temp_T GO
SELECT * FROM Temp_Insert_T DROP TABLE Temp_Insert_T
USE TempDB GO IF EXISTS(SELECT name FROM sys.tables WHERE name=N'Temp_Insert_T') DROP TABLE Temp_Insert_T SELECT T_ID AS COLUMN1, T_NAME AS COLUMN2, T_AGE AS COLUMN3 INTO Temp_Insert_T FROM Temp_T GO
SELECT * FROM Temp_Insert_T DROP TABLE Temp_Insert_T
USE TempDB GO
IF EXISTS(SELECT name FROM sys.tables WHERE name=N'Temp_T') DROP TABLE Temp_T GO CREATE TABLE Temp_T ( ID INT, A VARCHAR(10), B VARCHAR(10) ) GO
INSERT INTO Temp_T(ID, A, B) SELECT 1, 'A1', 'B2' UNION ALL SELECT 2, 'A2', 'B2' UNION ALL SELECT 3, 'A3', 'B3' UNION ALL SELECT 4, 'A4', 'B4' UNION ALL SELECT 5, 'A5', 'B5' UNION ALL SELECT 6, 'A6', 'B6' UNION ALL SELECT 7, 'A7', 'B7' UNION ALL SELECT 8, 'A8', 'B8' UNION ALL SELECT 9, 'A9', 'B9' GO
IF EXISTS(SELECT name FROM sysobjects WHERE name='Temp_P') DROP PROCEDURE Temp_P GO CREATE PROCEDURE Temp_P AS BEGIN SELECT ID, A FROM Temp_T END GO
IF OBJECT_ID(N'Temp_Insert_T')IS NOT NULL DROP TABLE Temp_Insert_T CREATE TABLE Temp_Insert_T ( ID INT, a VARCHAR(10) ) GO
INSERT INTO test(ID, a) EXEC Temp_P GO SELECT * FROM Temp_Insert_T GO
|