SQL Server 表变量和临时表

发布时间:2017-06-25 00:04:17 编辑:站点网
(Length * Windth * Height) ,Indate DATETIME NOT NULL DEFAULT(GETDATE()) ); INSERT INTO @tb_table(ProductName, Length, Windth, Height) VALUES('A', 0.1, 0.2, 0.3); INSERT INTO @tb_table(ProductName, Length, Windth, Height) VALUES('B', 0.4, 0.5, 0.6); INSERT INTO @tb_table(ProductName, Length, Windth, Height) VALUES('C', 0.7, 0.8, 0.9); UPDATE A SET Length = 2.5 FROM @tb_table AS A WHERE RowID = 1 ; DELETE TOP(1) A FROM @tb_table AS A WHERE RowID = 2; SELECT * FROM @tb_table;
更多相关内容:
    无相关信息
[!--temp.cy--]