USE master
GO

IF  EXISTS (
        SELECT name
                FROM sys.DATABASES
                WHERE name = N'ElenaBeklenishcheva'
)
ALTER DATABASE ElenaBeklenishcheva SET single_user WITH ROLLBACK immediate
GO

IF  EXISTS (
        SELECT name
                FROM sys.DATABASES
                WHERE name = N'ElenaBeklenishcheva'
)
DROP DATABASE [ElenaBeklenishcheva]
GO

CREATE DATABASE [ElenaBeklenishcheva]
GO

USE [ElenaBeklenishcheva]
GO

IF EXISTS(
  SELECT *
    FROM sys.schemas
   WHERE name = N'Scheme'
)
 DROP SCHEMA Scheme
GO

CREATE SCHEMA Scheme
GO


IF OBJECT_ID('regionsList', 'U') IS NOT NULL
  DROP TABLE regionsList
GO



CREATE TABLE regionsList(
    id_region VARCHAR(3) PRIMARY KEY NOT NULL,
    region_name VARCHAR(50) UNIQUE NOT NULL
)
GO


IF OBJECT_ID('trigRegionsList', 'TR') IS NOT NULL
    DROP TRIGGER trigRegionsList
GO

CREATE TRIGGER trigRegionsList ON regionsList INSTEAD OF INSERT
AS BEGIN
    print 'here'
    DECLARE @id VARCHAR(3)
    DECLARE @name VARCHAR(50)

    SELECT @id = (SELECT id_region FROM inserted)
    SELECT @name = (SELECT region_name FROM inserted)

    print @id

    IF (@id LIKE '[0-9][0-9]')
        INSERT INTO regionsList(id_region, region_name) VALUES
            (@id, @name);
    ELSE
        print 'Incorrect data in regionsList';
END



INSERT INTO regionsList(id_region, region_name) VALUES
(59, 'Пермский край'),
(66, 'Свердловская область'),
(50, 'Московская область'),
(68, 'Тамбовская область'),
(64, 'Саратовская область')


/*INSERT INTO regionsList(id_region, region_name) VALUES
(546, 'Плохая область')*/


SELECT * FROM regionsList