use =
Here you can see some default values for the parameters.
BEGIN TRANSACTION
GO
CREATE PROCEDURE dbo.GestionStatutDossier
-- Add the parameters for the stored procedure here
@StaId int = NULL,
@DosID uniqueidentifier,
@staDate datetime = '20120101',
@staBL nvarchar (50) = 'FOO',
@staCRprod nvarchar (50) = NULL
AS BEGIN
SELECT
@StaId
, @DosID
, @staDate
, @staBL
, @staCRprod
END
GO
DECLARE @dosID UNIQUEIDENTIFIER = NEWID()
EXEC dbo.GestionStatutDossier @DosID = @dosID
GO
ROLLBACK TRANSACTION
Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
declaring a parameter as null
Posted - 05/08/2012 : 06:23:24
