行列转换

 

SELECT

 

[blue] as col1,[red] as col2,[white] as col3

 

 

 

 

 

 

 

 

FROM

 

 

 

(

 

 

SELECT b.Size,a.Color,a.Color+b.Size as

c

 

 

FROM tblB as

b

 

 

CROSS JOIN tblA AS

a

)

 

 

AS

p

PIVOT

(

 

 

max(c

)

 

 

FOR

color

 

 

IN ([blue],[red],[white]

)

)

 

 

as

pvt

 

 

 

 

 

 

 

DELETE

 

FROM dbo.tbLab

WHERE

 

ID>10

DECLARE

 

@i int=0;

WHILE

 

(@i<1000)

BEGIN

SET

 

@i=@i+1;

INSERT

 

dbo.tbLab VALUES(@i+10,CHAR(CONVERT(INT,Ceiling(RAND()*100))%26+97)+CHAR(CONVERT(INT,Ceiling(RAND()*100))%26+97)+CHAR(CONVERT(INT,Ceiling(RAND()*100))%26+97)+CHAR(CONVERT(INT,Ceiling(RAND()*100))%26+97))

END

SELECT

 

Name

FROM

 

dbo.tbLab

WHERE

 

Name Like 'ang%'

GO