sql日期行转列问题答:CREATE TABLE row2col (LoadTime VARCHAR2(15),Driver VARCHAR2(10),NetWeight NUMBER(8,2),MaterialName Varchar2(10));INSERT INTO row2col VALUES('2014-12-01','sz',8.2,'粉煤灰');INSERT INTO row2col VALUES('2014-12-01','sz',2.2,'粉煤灰');INSERT INTO row2col VALUES('...
SQL SERVER 2008 复杂行转列答:2000000,6)insert into test values ('JNHS1501','2015-07-29',684770,7)insert into test values ('JNHS1502','2015-05-05',180000,1)insert into test values ('JNHS1502','2015-01-05',50000,2)执行declare @sql varchar(4000)set @sql = 'select 合同编号'select @sql = @sql +...