Создание триггера

USE [multuser]
GO
/****** Object:  Trigger [dbo].[Products_INSERT]    Script Date: 04.12.2019 14:01:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Products_INSERT]
ON [dbo].[users]
AFTER INSERT
AS
INSERT INTO account(name, about)
SELECT NULL, 'Логин ' + lvl
FROM users

INSERT INTO users(login, pass, lvl)
VALUES ('xxxx', 'yyyy', 9)
 
SELECT * FROM account

INSERT INTO users(login, pass, lvl)
VALUES ('xxxx', 'yyyy', 9)
 
SELECT * FROM account

INSERT INTO users(user_id,login, pass, lvl)
VALUES (NULL, 'xxxx', 'yyyy', 9)
 
SELECT * FROM account

CREATE TABLE [dbo].[users](
    [user_id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](50) NOT NULL,
    [pass] [nvarchar](50) NOT NULL,
    [lvl] [INT] NOT NULL,
 CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED 
(
    [user_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]