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
| /* ***** Object: Table T1 Script Date: 21/09/2016 ******/
DROP TABLE T1
GO
/* ***** Object: Table T1 Script Date: 21/09/2016 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE T1 (
T1_CODE bigint IDENTITY(1,1) NOT NULL,
NOM varchar(60) NOT NULL,
VILLE varchar(60) NOT NULL,
CONSTRAINT T1_PK PRIMARY KEY CLUSTERED
(
T1_CODE ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
GO
SET ANSI_PADDING OFF
GO
INSERT INTO T1 (NOM, VILLE) VALUES
('DUPOND','PARIS'),
('CHARLES','LYON'),
('MARTIN','PARIS'),
('LOUISE','LILLE'),
('MARCEL','PARIS');
SELECT * FROM T1;
SELECT * INTO XT1 FROM T1 WHERE T1.VILLE='PARIS';
SELECT * FROM XT1;
1 DUPOND PARIS
3 MARTIN PARIS
5 MARCEL PARIS |
Partager