阅读下面T-SQL语句，对变量赋值时存在错误的是（ ）（其中money为钱币数据类型，为其变量赋值可用或者不用$等货币符号）。 A: declare @id int ,@price money Set @id =100 Set @price=$2.21 B: declare @id int ,@price money Select @id=100,@price=2.21 C: declare @id int ,@price money set @id=100,@price=2.21 D: declare @id int ,@price money Select @id=100Select @price=$2.21

阅读下面T-SQL语句,对变量赋值时存在错误的是(<br/>)。 A: DECLARE @var1 INT, @var2 MONEY SELECT @var1=100, @var2=$2.21 B: DECLARE @var1 INT, @var2 MONEYSELECT @var1=100SELECT @var2=$2.21 C: DECLARE @var1 INT, @var2 MONEY SET @var1=100, @var2=$2.21 D: DECLARE @var1 INT, @var2 MONEY SET @var1=100 SET @var2=$2.21

查询曾经考过100分的学生的学号，可以使用的SQL语句是：（ ） A: SELECT ALL Sno FROM SC WHERE Grade = 100; B: SELECT DISTINCT Sno FROM SC WHERE Grade = 100; C: SELECT ALL Sno FROM Student WHERE SGrade = 100; D: SELECT DISTINCT Sno FROM Student WHERE SGrade = 100;

在表ticket中查询所有票价小于100元的车次、始发站和终点信息的命令是 A: SELECT*FROM ticket WHERE票价＜100 B: SELECT车次、始发站、终点FROM ticket WHERE票价＞100 C: SELECT车次、始发站、终点FROM ticket WHERE票价＜100 D: SELECT*FROM ticket WHERE票价＞100

语句SELECT CONCAT('?', '100');的执行结果是______

如果QUANTITY的值为空值(null)，在执行以下哪个语句时会显示一个0 A: SELECT id_number, 100/quantity B: FROM C: inventory; D: SELECT id_number, NVL(100/quantity, 0) E: FROM F: inventory; G: SELECT id_number, NULL(100/quantity, 0) H: FROM I: inventory; J: SELECT id_number, TO_CHAR(100/quantity, 0) K: FROM L: inventory; M: SELECT id_number, NVL(100/quantity, ’999.00’) N: FROM O: inventory;

若想查询成绩表中，成绩在80~100分之间的学生记录，则下列语言中正确的是（）。 A: SELECT * FROM 成绩表 WHERE 成绩 NOT BETWEEN 80 AND 100 B: SELECT * FROM 成绩表 WHERE 成绩  BETWEEN 80~100 C: SELECT 成绩表 FROM * WHERE 成绩  BETWEEN 80 AND 100 D: SELECT * FROM 成绩表 WHERE 成绩  BETWEEN 80 AND 100

create table t（id int not null, a int default 0, b int default 0, c int default 0, primary key（id）, key idx_a_b（a, b））;下面语句能够利用到索引的是（） A: select b from t where a=10; B: select * from t where a=10 and id=100; C: select * from t where a=10 and b＞100; D: select * from t where a＞10 and b ＜ 100; E: select * from t order by b limit 10;

下列语句有语法错误的是（ ） A: declare @myvar int B: select * from students C: select @myvar=100 D: delete * from score

5-49、查询图书表中所有库存小于100的图书信息，正确的语句是__________。 A: SELECT * FROM 图书 WHILE 库存 B: SELECT * FROM 图书 WHERE 库存 C: SELECT * FROM 图书 FOR 库存 D: SELECT WHERE 库存