string sqlString = @"DECLARE ProjectID number;BEGIN SELECT SEQ_PROJECTID.NEXTVAL INTO ProjectID FROM dual; INSERT INTO Project_BAK(ID,ProjectName) Values(ProjectID,:ProjectName);
SELECT ProjectID FROM DUAL;
END;";
Object=SqlCommand.ExecuteScalar(sqlString);----要怎么样才能获取到ProjectID 的值。不用存储过程,请问怎么实现。谢谢
SELECT ProjectID FROM DUAL;
END;";
Object=SqlCommand.ExecuteScalar(sqlString);----要怎么样才能获取到ProjectID 的值。不用存储过程,请问怎么实现。谢谢
SELECT SEQ_PROJECTID.NEXTVAL INTO ProjectID FROM dual不明白,楼主到底想要什么?