创建存储过程如下: create procedure scoreproc @scoreid int,@score numeric(4,2) output as select @score = score from scores where scoreid=@scoreid 正确的调用是:()
A. exec scoreproc 1,@myscore output print @myscore
B. exec scoreproc @id = 1,@myscore output print @myscore
C. declare @myscore numeric(4,2) exec scoreproc 1,@myscore output print @myscore
D. declare @myscore numeric(4,2) exec scoreproc @id = 1,@myscore output print @myscore
查看答案
常用的存储过程不包括()。
A. sp_tables
B. sp_columns
C. sp_stored_procedures
D. sp_renametable
已使用DROP TABLE删除表,若要删除表上的视图,必须通过使用DROP VIEW手工删除
创建存储过程的片断如下:创建成功后,以下()调用方式是正确的。(选择一项) create procedure proc_score @passed int = 60, @count int output as select count(*) from scores where score
A. execute proc_score @count int output
B. declare @count int execute proc_score 70,@count output
C. declare @count int output execute proc_score 70,@count
D. execute proc_score 70,@count output