(
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;
更多相关内容：
