用存储过程
我的代码同时插入两个数据库::
ALTER PROCEDURE dbo.InsertTS_ProInfor (
@InvestmentScale varchar(20),
@SubSpan
.........
)AS
SET NOCOUNT ON
BEGIN TRANSACTION
Insert Into TS_ProjectInformation
(MainProjectID,MainProjectSort,MainPlanStartDate ......)
values
(
@MainProjectID,@MainProjectSort,@MainProjectName.......
)
Insert Into TS_ProState(SubprojectID,....)
Values (@SubProjectID....)
COMMIT TRANSACTION
RETURN @@ERROR
我的代码同时插入两个数据库::
ALTER PROCEDURE dbo.InsertTS_ProInfor (
@InvestmentScale varchar(20),
@SubSpan
.........
)AS
SET NOCOUNT ON
BEGIN TRANSACTION
Insert Into TS_ProjectInformation
(MainProjectID,MainProjectSort,MainPlanStartDate ......)
values
(
@MainProjectID,@MainProjectSort,@MainProjectName.......
)
Insert Into TS_ProState(SubprojectID,....)
Values (@SubProjectID....)
COMMIT TRANSACTION
RETURN @@ERROR
FOR DELETE
AS insert into clientbak(clientname, owner)
values(select clientname, owner, from deleted)
GO我这样怎么不行
我检测语法,说是第4行括号附近有错误