日期:2014-05-16 浏览次数:20647 次
CREATE PROCEDURE p_test
@CardNo varchar (50) ,
@OriginalCarId varchar (50)='1'
AS
BEGIN
PRINT 'cardno';
PRINT @CardNo;
PRINT 'OriginalCarId';
PRINT @OriginalCarId;
END
go
CREATE PROCEDURE p_test_2
@OriginalCarId varchar (50)='1',
@CardNo varchar (50)
AS
BEGIN
PRINT 'cardno';
PRINT @CardNo;
PRINT 'OriginalCarId';
PRINT @OriginalCarId;
END
EXEC p_test 'sdfsd'
EXEC p_test_2 default,'sdfsd' --default