Hello,
I have the following simple code in a trigger (SQL Server Express 2008 R2, Windows 8):
-----------------------------------------------------------------------
DECLARE
@Designation varchar(50),
@Message nvarchar(4000),
@Count int
SELECT @Count = ... (some statement)
IF ( @Count = 1 )
BEGIN
SET @Designation = (SELECT Designation FROM AFFAIRE WHERE N_Affaire = @N_Affaire)
SET @Message = cast('The folder ' + @Designation + '" is closed.' + CHAR(13) + 'You must re-open it manually in order to save your data.' as nvarchar(4000))
RAISERROR(@Message, 0, 0)
ROLLBACK TRANSACTION
RETURN
END
--------------------------------------------------------- ...
Go to the complete details ...