insert into A(title) values('书名') insert into B(tID,content) values(SCOPE_IDENTITY(),'内容')
CREATE PROCEDURE Insert_title @title varchar(4000),@content varchar(4000) AS BEGIN insert into A(title) values(@title) insert into B(tID,content) values(SCOPE_IDENTITY(),@content) END GO --调用 exec Insert_title '书名','内容'
insert into B(tID,content) values(SCOPE_IDENTITY(),'内容')
@title varchar(4000),@content varchar(4000)
AS
BEGIN
insert into A(title) values(@title)
insert into B(tID,content) values(SCOPE_IDENTITY(),@content)
END
GO
--调用
exec Insert_title '书名','内容'