[晴天,小F]有没有格式化TSQL代码的工具 现有一存储过程 写得巨复杂很多层的 BEGIN END 嵌套 。全都没有缩进有没有让它自动缩进的工具。这样看起来就方便了,TAB键按得我心烦了JS代码,CSS样式网上有现成的工具可以格式化,这个TSQL代码,大家用过类似的格式化工具没? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 sql prompt 有的,不过这些格式美化可能要自己调一下 用這工具吧http://download.csdn.net/detail/roy_88/2816421 用SQL Assistant这个工具可以格式化代码--格式化前SELECT t1.EquipmentID, t1.EquipmentDescFirst + ISNULL(t1.EquipmentDescLast, '') AS EquipmentDesc, t1.EquipmentDescFirst + '<br>' + ISNULL(t1.EquipmentDescLast, '') AS EquipmentDescShow, t1.PhaseTypeID, t1.EquipmentSeq, t1.CommonClassCount, t1.HolidayClassCount, t2.PhaseTypeDescFROM dbo.tbl_Equipment AS t1 LEFT OUTER JOIN dbo.tbl_PhaseType AS t2 ON t1.PhaseTypeID = t2.PhaseTypeID--格式化后/************************************************************ * Code formatted by SoftTree SQL Assistant ?v4.5.9 * Time: 2011-11-1 11:48:30 ************************************************************/SELECT t1.EquipmentID, t1.EquipmentDescFirst + ISNULL(t1.EquipmentDescLast, '') AS EquipmentDesc, t1.EquipmentDescFirst + '<br>' + ISNULL(t1.EquipmentDescLast, '') AS EquipmentDescShow, t1.PhaseTypeID, t1.EquipmentSeq, t1.CommonClassCount, t1.HolidayClassCount, t2.PhaseTypeDescFROM dbo.tbl_Equipment AS t1 LEFT OUTER JOIN dbo.tbl_PhaseType AS t2 ON t1.PhaseTypeID = t2.PhaseTypeID下载http://download.csdn.net/detail/koumingjie/2033013 sql prompt 5 或是sql prompt 4 都可以。 谢谢各位的回答 和推荐 ,问题解决了实际使用对比发现SQL Assistant比sql prompt 好用些两个工具的原理好像是一样的结帖 请问:SQL2005 安装之后,实例名称可以改吗? 新人求问,急,如何查询. 找不到存储过程 'selectsnamefrom'是啥原因啊 能不能吧 查询语句结果插入已有表的数据中 大家帮忙啊 急啊 数据同步问题[ 使用邹建的方法 出现的问题] SQL连接字符串问题 求教sql查询语句 jinfeng_wang(G-G-S,D-D-U)对我写的那篇SQL结业论文有异议,说他那篇写得比我好,我不服气,大家来看看,300分,来者有分:) 请推荐一本SQL SERVER 7.0的好书! 新手求教 根据日期汇总后再行转列
这个工具可以格式化代码--格式化前
SELECT t1.EquipmentID, t1.EquipmentDescFirst + ISNULL(t1.EquipmentDescLast, '') AS EquipmentDesc,
t1.EquipmentDescFirst + '<br>' + ISNULL(t1.EquipmentDescLast, '') AS EquipmentDescShow, t1.PhaseTypeID, t1.EquipmentSeq,
t1.CommonClassCount, t1.HolidayClassCount, t2.PhaseTypeDesc
FROM dbo.tbl_Equipment AS t1 LEFT OUTER JOIN
dbo.tbl_PhaseType AS t2 ON t1.PhaseTypeID = t2.PhaseTypeID
--格式化后
/************************************************************
* Code formatted by SoftTree SQL Assistant ?v4.5.9
* Time: 2011-11-1 11:48:30
************************************************************/SELECT t1.EquipmentID,
t1.EquipmentDescFirst + ISNULL(t1.EquipmentDescLast, '') AS EquipmentDesc,
t1.EquipmentDescFirst + '<br>' + ISNULL(t1.EquipmentDescLast, '') AS
EquipmentDescShow,
t1.PhaseTypeID,
t1.EquipmentSeq,
t1.CommonClassCount,
t1.HolidayClassCount,
t2.PhaseTypeDesc
FROM dbo.tbl_Equipment AS t1
LEFT OUTER JOIN dbo.tbl_PhaseType AS t2
ON t1.PhaseTypeID = t2.PhaseTypeID
下载
http://download.csdn.net/detail/koumingjie/2033013