在SQL SERVER中,按以下要求创建学员表正确的SQL语句是( )。学员表(s
11 查阅
CREATE TABLE stuTable ( ID NUMERIC(6,0) NOT NULL, Name VARCHAR(4), Card INT)
CREATE TABLE stuTable( ID INT IDENTITY(10000,1), Name VARCHAR(4), Card DECIMAL(18,0))
IF EXISTS(SELECT * FROM sysobjects WHERE name=' stuTable ')DROP TABLE stuTableGOCREATE TABLE stuTable( ID NUMERIC(4,0) NOT NULL, Name VARCHAR(4), Card INT)
IF EXISTS(SELECT * FROM sysobjects WHERE name=' stuTable ')DROP TABLE stuTableGOCREATE TABLE stuTable( ID INT IDENTITY(10000,1), Name VARCHAR(8), Card NUMERIC(18,0))
参考答案: