错误为"SELECT" is not valid at this position,expecting: EOF, ';'
代码如下:
USE address
SELECT name,phone1 FROM dbo.Addressbook
CREATE TABLE Addressbook(
id INT PRIMARY KEY IDENTITY,
name VARCHAR(10),
phone1 VARCHAR(15),
phone2 VARCHAR(15)
)
USE addresslist
SELECT *FROM dbo.Addressbook
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('梁朝伟', '16667966666', '15688996423');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('周星驰', '19967998888', '13788996629');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('张曼玉', '11267996252', '15789496250');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('陈奕迅', '18767996252', '19788799682');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('张国荣', '18867996252', '15687996224');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('周慧敏', '18267996252', '15767996923');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('张国荣', '18967996252', '16777996225');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('陈柏宇', '18867996252', '15777996320');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('周柏豪', '18566725532', '16666996253');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('杨千嬅', '18867277993', '15799625625');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('某某惠', '18267996252', '15767996923');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('梁静茹', '18967996252', '16777996225');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('林宥嘉', '18867996252', '15777996320');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('刘瑞琦', '18566725532', '16666996253');
INSERT dbo.Addressbook(name,phone1,phone2)VALUES('孙燕姿', '18867277993', '15799625625');