این چرا خطا میده ؟

جامعه‌ها وبلاگ شروع یادگیری برنامه نویسی

Error SQL71006: Only one statement is allowed per batch. A batch separator, such as 'GO', might be required between statements. l

این خطا رو چطوری درست کنم؟

کدی که زدم

CREATE table table_name (
id int PRIMARY KEY NOT NULL UNIQUE
,first_name varchar(64)
,family varchar(64)
,AGE INT
,daneshgah varchar(64)
,term int
,farghe_tahsil varchar(32)
,tozihat varchar(128)
,city varchar
, constraint check_person CHECK (AGE >= 18 and city = "tehran" or first_name = "%a%")
)
go insert into table_name(id, AGE, city, first_name)
values (5,, 18, "tehran", 1, "loghman");

سلام،

به این شکل بنویسید:

CREATE TABLE table_name (
    id int PRIMARY KEY NOT NULL,
    first_name varchar(64),
    family varchar(64),
    AGE INT,
    daneshgah varchar(64),
    term int,
    farghe_tahsil varchar(32),
    tozihat varchar(128),
    city varchar(64),
    CONSTRAINT check_person CHECK (AGE >= 18 AND (city = 'tehran' OR first_name LIKE '%a%'))
);
GO
INSERT INTO table_name(id, AGE, city, first_name)
VALUES (5, 18, 'tehran', 'loghman');