590
社区成员
发帖
与我相关
我的任务
分享
[code=sql]
[/code]SELECT A.sUserID
, A.sUserName
, B.nUserGroupName
FROM A
INNER JOIN B ON A.nUserGroupID=B.nID;
CREATE PROC usp_iTabAAndTabB(
@sUserID INT,
@sUserName NVARCHAR(50),
@nUserGroupName NVARCHAR(50),
@nID INT=0 OUTPUT
)
AS
BEGIN
BEGIN TRY
BEGIN TRAN
DECLARE @nUserGroupID INT
SELECT @nUserGroupID=nID FROM B WHERE nUserGroupName=@nUserGroupName
IF @@ROWCOUNT=0
BEGIN
INSERT INTO B(nUserGroupName,nParentID)VALUES(@nUserGroupName,0)
SET @nUserGroupID=SCOPE_IDENTITY()
END
INSERT INTO A(sUserID,sUserName,nUserGroupID)
VALUES(@sUserID,@sUserName,@nUserGroupID)
SET @nID=SCOPE_IDENTITY()
COMMIT TRAN
END TRY
BEGIN CATCH
RAISERROR(N'插入数据失败',16,1)
ROLLBACK TRAN
END CATCH
END