[ n a t a s a @ 08.06.2010. 12:49 ] @
Da li znate kako da resim problem? Treba da pozovem proceduru u okviru druge procedure. Evo kako sam uradila: CREATE PROCEDURE create_proba @patPersonID int, @patLogID int AS --declare @return int --exec @return =dbo.create_log @patLogID INSERT INTO [DentalDB].[dbo].[tblPatient] ( [patPersonID], [patLogID] ) VALUES (@patPersonID , EXEC create_log @patLogID ) i prijavi mi gresku: Msg 156, Level 15, State 1, Procedure create_proba, Line 13 Incorrect syntax near the keyword 'EXEC'. Msg 102, Level 15, State 1, Procedure create_proba, Line 13 Incorrect syntax near ')'. Hvala unapred! |