calling sp in IF/BEGIN/END statement

• psconsulting

  SSC Eights!

  Points: 944

  More actions

  March 21, 2003 at 10:48 am

  #159279

  do i have to put anything in front of a stored procedure in order to call it with the begin end statement.

  for example:

  if 1=1

  begin

  sp_test

  end

  is this sufficent or do i need to put something in front. i thought exec but it errors off.

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  March 21, 2003 at 11:13 am

  #451722

  you must execute it like this:

  if 1=1

  begin

  EXEC sp_test

  end

  Are you having errors executing it like this? If so, what error?