sql 存储过程条件判断
create proc softuse_test_procif @id int as begin declare @v varchar(50) if @id='' begin select * from [test01].[dbo].[student3]; end else begin select * from [test01].[dbo].[student3] where stud_id=@id; end end