字體：小 中 大 |
|
|
|
| 2013/09/20 00:53:01瀏覽46917｜回應0｜推薦0 | |
[SQL]字串轉數值、變數 將欄位ec轉成數值，2是小數點幾位
EX: // 可參考view : examans
SELECT CAST(CAST(ec AS decimal(18, 2)) / CAST(et AS decimal(18, 2)) AS decimal(18, 2)) AS Expr1, s_id
FROM dbo.examview
將欄位class_id轉成varchar
EX: // 可參考view : ntans
SELECT DISTINCT dbo.news.n_class, dbo.student.class_id, dbo.news.n_id, dbo.student.s_id
FROM dbo.news CROSS JOIN
dbo.student
WHERE (dbo.news.n_class LIKE '%,' + CONVERT(varchar, dbo.student.class_id) + ',%')
參考網站：
CAST 和 CONVERT http://technet.microsoft.com/zh-tw/library/ms187928.aspx
DECLARE @local_variable http://technet.microsoft.com/zh-tw/library/ms188927.aspx
|
|
| ( 知識學習｜語言 ) |
