Create Procedure Proc_insertnews
@id int=null
as
if(@id is null)
begin
print '1'
end
else
begin
print '2'
end Proc_insertnews 2
Proc_insertnews null我试了一下可以的啊
@id int=null
as
if(@id is null)
begin
print '1'
end
else
begin
print '2'
end Proc_insertnews 2
Proc_insertnews null我试了一下可以的啊
Create Procedure Proc_insertnews
@id int=null
as
if(@id is null)
print '过程1'
else
print '过程2'
go调用:
exec Proc_insertnews
exec Proc_insertnews null
exec Proc_insertnews 1
go返回:
过程1
过程1
过程2