Problem za izvrsenjem stored procedure
Imam proceduru spAdmin_Do And i izvrsavam je sa
adospDo.Close();
adospDo.ProcedureName = "spAdmin_Do";
adospDo.Parameters.Clear();
spparamFilterRequest = adospDo.Parameters.AddParameter();
spparamFilterRequest.DataType = ftString;
spparamFilterRequest.Size = 10;
spparamFilterRequest.Value = asYear;
adospDo.ExecProc();
Izvrsavanje procedure stane kod provg EXEC 'delete Do.dbo.Admin_Do' i ne nastavlja dalje(to sam vodeo kad sasm radio trace na SQL serveru).
Ako izbrisem prvi EXEC situacija je ista, blokira opet kod prvog EXEC na koji naidje.
Da li je problem sto u proceduri imam vise EXECA, ima li neko ideju?
Procedura 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
 |  |
 |
