给存储过程里的参数定义默认值的问题

Question

请问怎么给参数定义一个NULL的默认值??

Answer 1

declare @a varchar(30)
set @a=null 

Answer 2

CREATE PROCEDURE au_info2
   @lastname varchar(30) = 'D%'

Answer 3

create proc p_test
@a=null
as
begin
    .....
end

Answer 4

create proc procname
@sname varchar(50) =null
as
selec * from ....

Answer 5

create proc P (@s1 int,@s2 nvarchar(100)=null,@s3 nvarchar(100))
as
select @s1,@s2,@s3go
調用
exec p @s1=1,@s3='a'--@s2用默認

Answer 6

--trycreate proc up_test1
@col varchar(10) = null
as
select * from tb where UNO = @col
go

Answer 7

create proc up_test1
@col varchar(10) = null --@col varchar(10) default null
as
select * from tb where UNO = @col
go

Answer 8

定义变量时直接赋值NULL即可.