摘要:
MSDN聯機註解:LOG10 和POWER 函數是彼此反向關聯。例如,10^ LOG10(n) = n。只有一個值的轉換時沒問題,以下測測結果集。;WITH CAS( SELECT number FROM master..spt_values WHERE number BETWEEN 1 AND ... 阅读全文
摘要:
USE Tempdb go IF OBJECT_ID('Tab1') IS NOT NULL DROP TABLE Tab1 go create table Tab1(Col1 real,formula varchar(50)) insert into Tab1 select 1000,'+20.5 阅读全文