Create PROC CreateSmallPage
(
@title nvarchar(200),
@parentID int,
@url varchar(200),
@sort int,
@des nvarchar(600),
@actionType varchar(20)
)
AS
BEGIN
BEGIN TRAN
INSERT INTO Zlb_Resource(Title, ParentID, URl, Sort, Des)
VALUES (@title, @parentID, @url, @sort, @des)
SELECT id, item into Zlb_Privilege FROM (SELECT [ID] FROM Zlb_Resource
CROSS JOIN (SELECT item FROM Split(@actionType,',')) AS S
)
IF(@@ERROR > 0)
ROLLBACK TRAN
ELSE
COMMIT TRAN
END提示错误:在关键字 'IF' 附近有语法错误,请问哪错了,谢谢大家了! 个把月不写SQL,把啥都给忘了!
CROSS JOIN (SELECT item FROM Split(@actionType,',')) AS S
) AS T少了个名
Create PROC CreateSmallPage
(
@title nvarchar(200),
@parentID int,
@url varchar(200),
@sort int,
@des nvarchar(600),
@actionType varchar(20)
)
AS
BEGIN
BEGIN TRAN
INSERT INTO Zlb_Resource(Title, ParentID, URl, Sort, Des)
VALUES (@title, @parentID, @url, @sort, @des)
SELECT id, item into Zlb_Privilege FROM (SELECT [ID] FROM Zlb_Resource
CROSS JOIN (SELECT item FROM Split(@actionType,',')) AS S
)
IF @@ERROR > 0
begin
ROLLBACK TRAN
end
ELSE
begin
COMMIT TRAN
end
END
COMMIT TRAN
ELSE
ROLLBACK TRAN
end
(
@title nvarchar(200),
@parentID int,
@url varchar(200),
@sort int,
@des nvarchar(600),
@actionType varchar(20)
)
AS
BEGIN
BEGIN TRAN
INSERT INTO Zlb_Resource(Title, ParentID, URl, Sort, Des)
VALUES (@title, @parentID, @url, @sort, @des)
SELECT id, item into Zlb_Privilege FROM (SELECT [ID] FROM Zlb_Resource
CROSS JOIN (SELECT item FROM Split(@actionType,',')) AS S
) as tab
IF(@@ERROR > 0)
ROLLBACK TRAN
ELSE
COMMIT TRAN
END
CROSS JOIN (SELECT item FROM Split(@actionType,',')) AS S
)t
Create PROC CreateSmallPage
(
@title nvarchar(200),
@parentID int,
@url varchar(200),
@sort int,
@des nvarchar(600),
@actionType varchar(20)
)
AS
BEGIN
BEGIN TRAN
INSERT INTO Zlb_Resource(Title, ParentID, URl, Sort, Des)
VALUES (@title, @parentID, @url, @sort, @des)
SELECT id, item into Zlb_Privilege FROM (SELECT [ID] FROM Zlb_Resource CROSS JOIN (SELECT item FROM Split(@actionType,',')) AS S ) as T
IF(@@ERROR > 0)
ROLLBACK TRAN
ELSE
COMMIT TRAN
END
--try
Create PROC CreateSmallPage
(
@title nvarchar(200),
@parentID int,
@url varchar(200),
@sort int,
@des nvarchar(600),
@actionType varchar(20)
)
AS
BEGIN
BEGIN TRAN
INSERT INTO Zlb_Resource(Title, ParentID, URl, Sort, Des)
VALUES (@title, @parentID, @url, @sort, @des)
SELECT id, item into Zlb_Privilege FROM (SELECT [ID] FROM Zlb_Resource
CROSS JOIN (SELECT item FROM Split(@actionType,',')) AS S
) tb
IF(@@ERROR > 0)
ROLLBACK TRAN
ELSE
COMMIT TRAN
END