create procedure XXX
  @type varchar(20)
as
begin
  if @type = 'ok'
      select getdate()
end
go

exec XXX 'ok'
drop proc XXX

------解决方案--------------------
if @type='ok'

------解决方案--------------------
create procedure XXX
  @type varchar(20)
  
  as
  begin 
  if @type='ok'
     dothing
  end
  

------解决方案--------------------
探讨

SQL code


create procedure XXX
  @type varchar(20)
as
begin
  if @type = 'ok'
      select getdate()
end
go

exec XXX 'ok'
drop proc XXX