sp with parameters

From: Luis Porras (luis.porras_at_dakotaimaging.com)
Date: 08/13/04


Date: Fri, 13 Aug 2004 11:48:44 -0600

Hi,

How do I execute a sybase sp with string parameters? (VC++ 6x)

example:

exec sp_getjobid 'operator_1'

Thanks!!



Relevant Pages

  • Re: exec/system wipes signal handler
    ... When you do an exec(), all of the code in memory ... new process image. ... array of pointers must be terminated by a NULL pointer. ... according to whether at least one file with suitable execute permissions ...
    (comp.lang.php)
  • Re: Application role to access xp_cmdshell
    ... This necessitates that your user procs be owned ... See Cross-database chaining in the SQL 2000 ... You will also need to allow non-sysadmin users to execute xp_cmdshell. ... EXEC sp_dboption 'MyDatabase', 'db chaining', true ...
    (microsoft.public.sqlserver.security)
  • Re: regex to find an stored proc name
    ... One major flaw in yours though is that is doesn't handle the return type as ... exec this a, b, c ... execute ... "Kevin Spencer" wrote: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Sleep freezing
    ... >> man exec. ... > form of a standard shell pipeline where each arg becomes one ... > word of a command, and each distinct command becomes a sub- ... The word "execute" means to replace the program running in the calling ...
    (comp.unix.shell)
  • Running a DTS Job from a stored procedure
    ... We now want to upgrade our SQL Servers to Windows 2003 server on a ... EXEC sp_DisplayOAErrorInfo @oPKG, @hr ... PRINT '*** Execute failed' ...
    (microsoft.public.sqlserver.dts)

Loading