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
| if exists(select 1 from sys.tables where object_id = object_id('[dbo].[tManyColumns]'))
drop table [dbo].[tManyColumns]
GO
create table [dbo].[tManyColumns]
( [c1] [int] NOT NULL,
[c2] [int] NOT NULL,
[c3] [int] NULL,
[c4] [int] NULL,
[c5] [int] NULL,
[c6] [int] NULL,
[c7] [int] NULL,
[c8] [int] NULL,
[c9] [int] NULL,
[c10] [int] NULL,
[c11] [int] NULL,
[c12] [int] NULL,
[c13] [int] NULL,
[c14] [int] NULL,
[c15] [int] NULL,
[c16] [int] NULL,
[c17] [int] NULL,
[c18] [int] NULL,
[c19] [int] NULL,
[c20] [int] NULL,
[c21] [int] NULL,
[c22] [int] NULL,
[c23] [int] NULL,
[c24] [int] NULL,
[c25] [int] NULL,
[c26] [int] NULL,
[c27] [int] NULL,
[c28] [int] NULL,
[c29] [int] NULL,
[c30] [int] NULL,
[c31] [int] NULL,
[c32] [int] NULL,
[c33] [int] NULL,
[c34] [int] NULL,
[c35] [int] NULL,
[c36] [int] NULL,
[c37] [int] NULL,
[c38] [int] NULL,
[c39] [int] NULL
constraint [PK1] primary key clustered
(
[c1] ASC,
[c2] ASC
)
) ON [PRIMARY]
go
--populate the table
SET NOCOUNT ON;
SET XACT_ABORT ON;
GO
BEGIN TRANSACTION;
INSERT INTO [dbo].[tManyColumns]([c1], [c2], [c3], [c4], [c5], [c6], [c7],
[c8], [c9], [c10], [c12], [c13], [c14], [c15], [c16], [c17], [c18], [c19])
SELECT 1, 3, 32, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, 88, NULL, NULL UNION ALL
SELECT 1, 4, 32, 14, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL,
NULL, NULL, 88, NULL, NULL UNION ALL
SELECT 2, 1, 32, 14, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, 11, 88, NULL, NULL
COMMIT;
RAISERROR (N'[dbo].[tManyColumns]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO
--check contents of the table
select * from dbo.tManyColumns |
Partager