单选题
数据库
题号 #2700510
在SQL Server 2008中,设在某数据库中建有如下所示的存储过程:
CREATE PROC P1
@a int = 20, @b char(4)
AS … …
设有下列调用该存储过程的语句:
Ⅰ.EXEC P1 100, 'a01'
Ⅱ.EXEC P1 'a01'
Ⅲ.EXEC P1 @b='a01'
Ⅳ.EXEC P1 @a=default, @b='a01'
上述语句中,能够正确调用该存储过程的是( )
参考答案
C
答案解析
暂无解析
你可能感兴趣的试题
A.T表:('a01',100)
INSERTED表:('a01',90)
DELETED表:('a01',100)
INSERTED表:('a01',90)
DELETED表:('a01',100)
B.T表:('a01',90)
INSERTED表:('a01',90)
DELETED表:('a01',100)
INSERTED表:('a01',90)
DELETED表:('a01',100)
C.T表:('a01',100)
INSERTED表:('a01',100)
DELETED表:('a01',90)
INSERTED表:('a01',100)
DELETED表:('a01',90)
D.T表:('a01',90)
INSERTED表:('a01',100)
DELETED表:('a01',90)
INSERTED表:('a01',100)
DELETED表:('a01',90)
A.Ⅰ、Ⅲ、Ⅳ
B.Ⅰ、Ⅲ、Ⅴ
C.Ⅱ、Ⅳ、Ⅴ
D.Ⅰ、Ⅳ、Ⅴ
A.CHECK(销售价格BETWEEN单价*0.6 AND单价*1.5)
B.CHECK(销售价格BETWEEN商品表.单价*0.6 AND商品表.单价*1.5)
C.CREATE TRIGGER tri_Sales ON销售表FOR INSERT,UPDATE
AS IF EXISTS(SELECT*FROM INSERTED a JOIN商品表b
ON a.商品号=b.商品号
WHERE销售价格NOT BETWEEN单价*0.6 AND单价*1.5)
ROLLBACK
AS IF EXISTS(SELECT*FROM INSERTED a JOIN商品表b
ON a.商品号=b.商品号
WHERE销售价格NOT BETWEEN单价*0.6 AND单价*1.5)
ROLLBACK
D.CREATE TRIGGER tri_Sales ON销售表INSTEAD OF INSERT,UPDATE
AS
IF EXISTS(SELECT*FROM INSERTED a JOIN商品表b
ON a.商品号=b.商品号
WHERE销售价格NOT BETWEEN单价*0.6 AND单价*1.5)
ROLLBACK
AS
IF EXISTS(SELECT*FROM INSERTED a JOIN商品表b
ON a.商品号=b.商品号
WHERE销售价格NOT BETWEEN单价*0.6 AND单价*1.5)
ROLLBACK