ALTER PROCEDURE [dbo].[MobilMisafirOlustur]
AS
BEGIN
DECLARE @Username varchar(30)
DECLARE @UserId int, @Deger varchar(30)
BEGIN TRANSACTION
SET NOCOUNT ON;
SELECT TOP 1 @UserId = [UserID] FROM [dbo].[User] ORDER BY UserID DESC ;
SET @Deger = @UserId + 1
SET @Username = 'Misafir_' + @Deger
INSERT INTO [dbo].[User]([Username],[SessionId],[IP],[Aktif],[Engelli])
VALUES
(@Username, @Username, @Username, 1, 0 )
COMMIT TRANSACTION
SELECT @Username AS UserName
END