Question

如何在sql server中创建一个存储过程中的varchar型的输入参数默认值为空

Answer 1

create procedure aaa
@abc varchar(30) = null
as
begin
.....
end