#眉標=SQL Server 2008 #副標=SQL Server 2008 新功能概覽(1) #大標=管理與開發新一代資料庫平台 #作者=文/胡百敬 ====<反灰>=========== CREATE TYPE mytab AS TABLE (id int); DECLARE @t mytab; ======================= ==============<反灰>================= MERGE tbDest D USING tbSource s ON D.c1 = S.c1 WHEN MATCHED THEN --修改 UPDATE SET D.c2 = S.c2 WHEN SOURCE NOT MATCHED THEN --刪除 DELETE WHEN TARGET NOT MATCHED THEN --新增 INSERT VALUES(c1, c2) OUTPUT $action, INSERTED.c1 [New c1], INSERTED.c2 [New c2], DELETED.c1 [Original c1], DELETED.c2 [Original c2]; ===================================== ======<反灰 >============ DECLARE @i int = 4 ======================= ============<反灰>================== DECLARE @i INT=2 SELECT TOP 3 @i *= @i FROM sys.objects SELECT @i ================================ ============<反灰>================== DECLARE @t TABLE (id int, name varchar(20)); INSERT INTO @t VALUES (1, 'Fred'), (2, 'Jim'), (3, 'Sue'); ================================ ====================== 參考資料 據 SQL Server Magazine 的調查(http://www.sqlmag.com/Articles/ArticleID/97987/97987.html?Ad=1),仍有 81% 的用戶使用 SQL Server 2000,40% 的用戶有採用 SQL Server 2005。針對以往這些 SQL Server 暢銷的版本 6.5/7.0/2000 而言,由於間隔了 8 年以上,因此筆者相信 SQL Server 2008 將是這些版本升級的主要選擇。 =========================