各位大神帮看看[有包子]# Java - 爪哇娇娃
b*f
1 楼
这么一个例子:
IF OBJECT_ID('T1') IS NOT NULL
DROP TABLE T1;
GO
CREATE TABLE T1 (id int PRIMARY KEY, timestamp);
GO
INSERT INTO T1(id) VALUES (1);
GO
declare @v timestamp;
INSERT INTO T1(id) OUTPUT inserted.timestamp as v VALUES (10);
select @v
假设这个@v是俺想作为stored-procedure的OUT参数返回,怎样才能把inserted.
timestamp值传递给@v呢?
多谢,给俺解决问题的奉上双黄包一个...
IF OBJECT_ID('T1') IS NOT NULL
DROP TABLE T1;
GO
CREATE TABLE T1 (id int PRIMARY KEY, timestamp);
GO
INSERT INTO T1(id) VALUES (1);
GO
declare @v timestamp;
INSERT INTO T1(id) OUTPUT inserted.timestamp as v VALUES (10);
select @v
假设这个@v是俺想作为stored-procedure的OUT参数返回,怎样才能把inserted.
timestamp值传递给@v呢?
多谢,给俺解决问题的奉上双黄包一个...