Problem with execution

From: Johny (goky2002_at_beograd.com)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 13:13:59 +0200

have Stored procedure spAdmin_Do And I try to execute it from application (I
can execute it from Query Analyzer).
 The procedure simply stop at the first EXEC 'delete Do.dbo.Admin_Do' and
don't continue.
 If I delete that line procedure again stop at the first EXEC.

 Is it problem if I have more EXEC in procedure or How can I solve this on
some different way?

The procedure spAdmin_Do:

CREATE PROCEDURE spAdmin_Do
(
 @sFiscalYear varchar(10)
)
AS
   @sQueryPart1 varchar(1000),
   @sQueryPart2 varchar(1000),
   @sQueryPart3 varchar(1000)

SET @sQueryPart1 = " Some query "
SET @sQueryPart2 = " Some query "
SET @sQueryPart3 = " Some query "

SET DATEFORMAT dmy
Exec ('delete Do.dbo.Admin_Do')
EXEC(@sQueryPart1)

EXEC(@sQueryPart2)
EXEC(@sQueryPart3)
GO

Relevant Pages

  • Problem with execution
    ... I have Stored procedure spAdmin_Do And I try to execute it with ... If I delete that line procedure again stop at the first EXEC. ... SET DATEFORMAT dmy ...
    (borland.public.delphi.database.ado)
  • Problem with execution
    ... have Stored procedure spAdmin_Do And I try to execute it. ... If I delete that line procedure again stop at the first EXEC. ... SET DATEFORMAT dmy ...
    (microsoft.public.data.ado)
  • RE: Differences in execution times for a stored procedure
    ... If OleDb, ... "Vincent Keller" wrote:> I am trying to execute a time-consuming stored procedure in my application. ... > Are there some known performance differences in executing a query directly through Query Analyzer and through ADO.NET? ...
    (microsoft.public.dotnet.framework.adonet)
  • Differences in execution times for a stored procedure
    ... I am trying to execute a time-consuming stored procedure in my application. ... When I run the stored procedure through Query Analyzer, ... Are there some known performance differences in executing a query (stored ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO, SQLServer2000 and errors
    ... "Luigi" wrote in message ... > If I execute the stored procedure in Query Analyzer what happens, ...
    (microsoft.public.data.ado)