MSSQL 常用語法

查詢

SELECT  
 [id]
,[major_trader_id]
,[net_amount]
,[tradedate] 

FROM 
[quotefutures].[dbo].[futures_major_trader]  

where [tradedate] = '2016-06-28 00:00:00.000'

刪除

DELETE  FROM  [quotefutures].[dbo].[futures_major_trader]  where [tradedate] = '2016-06-28 00:00:00.000'

select * from (select top 30 * from quotestock.dbo.TSE100Price ORDER BY tradedate DESC) k order by k.tradedate;