我想创建一个表:create table test.#News(
-> News_id int not null,
-> NewsTitle varchar(100),
-> NewsContent varchar(2000),
-> NewsDateTime datetime);sql语法错误错误信息是:
int not null,NewsTitle varchar(100),
NewsContent varchar(2000),
NewsDateTime da' at line 2
怎么解决?SQL
-> News_id int not null,
-> NewsTitle varchar(100),
-> NewsContent varchar(2000),
-> NewsDateTime datetime);sql语法错误错误信息是:
int not null,NewsTitle varchar(100),
NewsContent varchar(2000),
NewsDateTime da' at line 2
怎么解决?SQL
News_id INT NOT NULL,
NewsTitle VARCHAR(100),
NewsContent VARCHAR(2000),
NewsDateTime DATETIME);
News_id INT NOT NULL,
NewsTitle VARCHAR(100),
NewsContent VARCHAR(2000),
NewsDateTime DATETIME);
DECLARE @News Table
(
News_id int NOT NULL,
NewsTitle varchar(100),
NewsContent varchar(2000),
NewsDateTime datetime
) 这样对么?
但是这样不出来