存储过程如下:
CREATE PROCEDURE sp_CallData
@eduid varchar(32),
@queuenum varchar(20),
@createtime datetime
AS
insert into A (eduid,queuenum,queuetime) values
(@eduid,@queuenum,GetDate())
你这个存储过程有什么用?
CREATE PROCEDURE sp_CallData
@eduid varchar(32),
@queuenum varchar(20),
@createtime datetime
AS
insert into A (eduid,queuenum,queuetime) values
(@eduid,@queuenum,GetDate())
你这个存储过程有什么用?
ON B
AFTER INSERT
AS insert into servera.dbname..A( eduid,queuenum,queuetime )
select id, que, getdate()
from inserted