MS-SQL Server
sql语句小问题！
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区
CREATE TABLE [dbo].[Wound](
[WoundID] [int] IDENTITY(1,1) NOT NULL,
[Winding] [varchar](50) NULL,
[Laps] [varchar](50) NULL,
[Wire] [varchar](50) NULL,
[RootNumber] [varchar](50) NULL,
[Pin] [varchar](50) NULL,
[RoutingI] [varchar](200) NULL,
[ELaps] [varchar](200) NULL,
[Skeleton_Pin] [varchar](20) NULL,
[Inductance] [varchar](10) NULL,
[C_Res] [varchar](10) NULL,
[Saturated] [varchar](10) NULL,
[T_Leakage] [varchar](10) NULL,
[TF_ID] [int] NULL,
CONSTRAINT [PK_Wound] PRIMARY KEY CLUSTERED
(
[WoundID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
declare @sql Nvarchar(2000)
set @sql='select TF_ID '
select @sql=@sql+', max(case when Winding='''+CAST(Winding as nvarchar(10))+''' then cast(Laps as INT) else 0 end) as ['+CAST(Winding as varchar(10))+',Laps],
max(case when Winding='''+CAST(Winding as nvarchar(10))+''' then cast(Wire as varchar(10)) else null end) as ['+CAST(Winding as varchar(10))+',Wire],
max(case when Winding='''+CAST(Winding as nvarchar(10))+''' then cast(Inductance as varchar(10)) else null end) as ['+CAST(Winding as varchar(10))+',Inductance],
max(case when Winding='''+CAST(Winding as nvarchar(10))+''' then cast(C_Res as varchar(10)) else null end) as ['+CAST(Winding as varchar(10))+',C_Res],
max(case when Winding='''+CAST(Winding as nvarchar(10))+''' then cast(Saturated as varchar(10)) else null end) as ['+CAST(Winding as varchar(10))+',Saturated]'
from (select DISTINCT Winding from wound b ) as t
set @sql=@sql+'from wound b,Transformer a GROUP BY TF_ID'
exec (@sql)
在本机可以执行。但放在另外一台机子上就出错。都是sql2008的。
‘）’附近有语法错误
...全文
相关推荐
MyBatis 执行动态 SQL语句详解
大家对mybatis执行任意sql语句都了解，那么MyBatis执行动态SQL语句呢？下面脚本之家小编给大家解答下mybatis执行动态sql语句的方法，非常不错，感兴趣的朋友参考下吧
discuz 查询语句安全威胁[Query] SELECT /*!40001 SQL_CACHE */的解决方法
Error messages:[Type] 查询语句安全威胁[Query] SELECT /*!40001 SQL_CACHE */ * FROM common_syscache WHER
百万级SQL语句_MySQL（测试数据）
SQL文件中内含2087516条数据，列分别为`id`,`user_id`,`vote_id`,`group_id`,`create_time`，可自行测试在满足百万级数据下SQL语句性能问题！ 主要帮助想练习SQL语句优化却没有如此大量的数据的童鞋~~~ 如果你是想在百万级数据下，打怪升级SQL语句的童鞋赶紧下载试试你SQL语句的功底吧！
sql语句区别
access和SQL语句的区别 内置两者常用的区别
Mybatis控制台打印Sql语句的实现代码
MyBatis是一个支持普通SQL查询，存储过程和高级映射的优秀持久层框架，下面给大家介绍Mybatis控制台打印Sql语句的实现代码，非常不错，感兴趣的朋友一起看下吧
