TDClassに対応したストアド

ALTER PROCEDURE [dbo].[spInsUserInfo]
@UserId VARCHAR(10)
,@UserName NVARCHAR(255)
,@UserPassword VARCHAR(50)
,@UserGrant INT
,@UserStatus INT
,@CreateUserId VARCHAR(10)
,@CreateTimeStamp DATETIME
,@ErrorCode INT OUTPUT
,@ErrorText NVARCHAR(1000) OUTPUT
,@ErrorLine INT OUTPUT

AS
BEGIN
DECLARE @ReturnValue AS INT = 0
SET NOCOUNT ON

BEGIN TRY
INSERT INTO UserInfo(
UserId,
UserName,
UserPassword,
UserGrant,
UserStatus,
CreateUserId,
CreateTimeStamp
)VALUES(
@UserId,
@UserName,
@UserPassword,
@UserGrant,
@UserStatus,
@CreateUserId,
@CreateTimeStamp
)
END TRY
BEGIN CATCH
SET @ErrorCode = ERROR_NUMBER()
SET @ErrorText = ERROR_MESSAGE()
SET @ErrorLine = ERROR_LINE()
END CATCH
END