创建存储过程如下：Create proc bookproc @id int ,@title char(20) outputAs Select @title=title from book where id=@id执行该存储过程的方法正确的是（ ）
A: Exec bookproc 1,@title outputPrint @title
B: exec bookproc @id=1,@title outputPrint @title
C: declare @title char(2)Exec bookproc 1,@title outputPrint @title
D: declare @title char(20)Exec bookproc @id=1,@title outputPrint @title
A: Exec bookproc 1,@title outputPrint @title
B: exec bookproc @id=1,@title outputPrint @title
C: declare @title char(2)Exec bookproc 1,@title outputPrint @title
D: declare @title char(20)Exec bookproc @id=1,@title outputPrint @title
举一反三
- 创建存储过程如下:<br/>Create<br/>procedure bookproc<br/>@id<br/>int, @title char(20) output<br/>As<br/>Select<br/>@title=title from book where id=@id<br/>执行该存储过程的方法正确的是()。 A: exec bookproc 1, @title output <br/>print<br/>@title B: exec bookproc @id=1, @title output <br/>print<br/>@title C: declare @title char(20)<br/>exec<br/>bookproc 1, @title output <br/>print<br/>@title D: declare @title char(20)<br/>exec<br/>bookproc @id=1, @title output <br/>print<br/>@title
- 【单选题】以下哪个 sql 语句表示在 mysql 中创建 book 表,并添加 id 字段和 title 字段? A. create table book{ id varchar(32), title varchar(50) }; B. create table book( id varchar2(32), title varchar2(50) ); C. create table book( id varchar(32), title varchar(50) ); D. create table book[ id varchar(32), title varchar(50) ];
- 如果要把查询结果按照字段id升序排序，再按字段title降序排序，下面哪个链式操作表达式满足这个需求： A: order(“id , title”) B: order(“id , title desc”) C: order(“id title desc”) D: order(“id asc title desc”)
- 以下哪个代码能实现将id为title的元素隐藏? A: document.getElementById("title").style.display = "none"; B: document.getElementsByName("title").style.display = "none"; C: document.getElementById("title").style.display = "block"; D: document.getElementsByClassName("title").style.display = "none";
- 现有表book，字段：id(int)，title(varchar),price(float);其中id字段设为主键，使用insert语句向book表中插入数据，以下语句正确的是 A: insert into book(title,price) values('java',100) B: c)insert into book values('java',100) C: insert book values('java',100) D: insert into book(id,title,price) values(1,'java',100)