SQL Server 2014???????????????

???????PRIMARY KEY????????UNIQUE CLUSTERED INDEX????????????????????????￡?????л?????DDL??DML???SQL Server?????????????????
1 ALTER PROCEDURE PopulateTempTable
2 AS
3 BEGIN
4     -- Create a new temp table
5     CREATE TABLE #TempTable
6     (
7         Col1 INT IDENTITY(1?? 1) PRIMARY KEY?? -- This creates also a Unique Clustered Index
8         Col2 CHAR(4000)??
9         Col3 CHAR(4000)
10     )
11
12     -- Insert 10 dummy records
13     DECLARE @i INT = 0
14     WHILE (@i < 10)
15     BEGIN
16         INSERT INTO #TempTable VALUES ('Woody'?? 'Tu')
17         SET @i += 1
18     END
19 END
20 GO
??????????????и??????????????????????????????SQL Server?????????????????????????

??????????????ζ???????????????????????Non-Clustered Indexes?????SQL Server??????????????????????洢????????????λ?????DDL??DML???
????????SQL Server 2014???????????????????????????????CREATE TABLE???????????????????????????
1 ALTER PROCEDURE PopulateTempTable
2 AS
3 BEGIN
4     -- Create a new temp table
5     CREATE TABLE #TempTable
6     (
7         Col1 INT IDENTITY(1?? 1) PRIMARY KEY?? -- This creates also a Unique Clustered Index
8         Col2 CHAR(100) INDEX idx_Col2??
9         Col3 CHAR(100) INDEX idx_Col3
10     )
11
12     -- Insert 10 dummy records
13     DECLARE @i INT = 0
14     WHILE (@i < 10)
15     BEGIN
16         INSERT INTO #TempTable VALUES ('Woody'?? 'Tu')
17         SET @i += 1
18     END
19 END
20 GO
????????????????????????????????????????????????2???????????????????????????л?????DDL??DML???SQL Server????ο?????沢?????????????

??????SQL Server 2014????????????????????????????????????DML??DDL?????????????????β???????????????????
????????1??????????????????????????????