首頁 > 資訊科技 > 資料庫 > SQL語法美化軟體 - SQL Pretty Printer 3.3.3
2012
12-02

SQL語法美化軟體 - SQL Pretty Printer 3.3.3

這是一套很好用的資料庫SQL語法軟體,他可以直接把SQL語法轉成C#、PASCAL、PHP...等等的語法,對於程式開發者是很好用的,尤其是開發delphi 常常會被幾個引號搞亂,使用SQL  Pretty Printer 就可以快速編程了。

原本很亂的SQL

SELECT top 100
sl.specObjId,
sl.lineID,
sMax.maxVel
-- get the spectroscopic object ID, the line ID, and the max width (in velocity)
FROM SpecLine sl,
(SELECT
specObjID,
lineID,
Max(2.99e52.354sigma/wave) as maxVel
FROM SpecLine
WHERE (
-- only include measured lines
category = 2 AND
-- only include the most prominent lines
lineID in (1215,1400,1549,1909,2799,4863,6565) AND
-- make sure that this is a reaonably well measured line
-- (these are fairly weak constraints)
nSigma > 3 AND
chisq/nu < 20 AND
ew > 0 AND
abs(ew - heightsigma1.065*2.354/continuum)/ew < 0.25
)
GROUP BY specObjID, lineID) as sMax

整理後的SQL

SELECT top 100 sl.specObjId,
sl.lineID,
sMax.maxVel
-- get the spectroscopic object ID, the line ID, and the max width (in velocity)
FROM SpecLine sl,
(SELECT specObjID,
lineID,
Max(2.99e5 * 2.354 * sigma / wave) as maxVel
FROM SpecLine
WHERE (
-- only include measured lines
category = 2
AND
-- only include the most prominent lines
lineID in ( 1215, 1400, 1549, 1909,
2799, 4863, 6565 )
AND
-- make sure that this is a reaonably well measured line
-- (these are fairly weak constraints)
nSigma > 3
AND chisq / nu < 20
AND ew > 0
AND abs(ew - height * sigma * 1.065 * 2.354 / continuum) / ew < 0.25 )
GROUP BY specObjID,
lineID) as sMax

有需要的可以下載試用
http://www.dpriver.com/index.php

最後修改日:
作者:蔡 小翰

常見問題:

  1. 文章可以轉貼嗎?可以,不過請要註明出處並標示本站連結。
  2. 載點可以轉貼嗎?可以,歡迎隨意盜連,無須告知。
  3. 反盜版聲明:本站支持正版軟體,請勿討論破解版、快樂版、註冊碼、註冊機、序號...等違法主題。
  4. 檔案無法解壓縮或解壓縮時發生錯誤?請使用7-Zip解壓縮
  5. 更多細節請參閱使用條款及免責聲明


發表迴響

這個網站採用 Akismet 服務減少垃圾留言。進一步瞭解 Akismet 如何處理網站訪客的留言資料