27,579
社区成员
发帖
与我相关
我的任务
分享Sql Server7.0触发器问题
在sql server7.0中如何实现如下功能的触发器?
CREATE TRIGGER SQ_PJFNBR ON T_PROJECT
INSTEAD OF INSERT
AS
BEGIN
INSERT INTO T_PROJECT
SELECT (select sqnow from sequence where sqtab='T_PROJECT'),PJNAME,PJDESC
FROM inserted
END
CREATE TRIGGER SQ_PJFNBR ON T_PROJECT
INSTEAD OF INSERT
AS
BEGIN
INSERT INTO T_PROJECT
SELECT (select sqnow from sequence where sqtab='T_PROJECT'),PJNAME,PJDESC
FROM inserted
END
...全文
请发表友善的回复…
发表回复
jinjazz 2005-03-31
- 打赏
- 举报
怪
