1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| BEGIN TRY
BEGIN TRAN
IF (@pId > 0)
BEGIN
SET @sql = 'UPDATE [SERVER].BASE.dbo.TABLE '
SET @sql += 'SET YTS_PRIXNET = '+CAST(@pPrix AS VARCHAR)+', '
SET @sql += 'YTS_PRIXBRUT = '+CAST(@pPrix AS VARCHAR)+' '
SET @sql += 'WHERE YTS_IDENTIFIANT = '+CAST(@pId AS VARCHAR)+'; '
SET @sql += 'SELECT @nbOUT = @@ROWCOUNT'
SET @param = '@nbOUT int OUTPUT'
EXEC sp_executesql @sql, @param, @nbOUT = @nbLigne OUTPUT
IF (@nbLigne <> 1)
BEGIN
RAISERROR (@sql,11,1)
END
END
COMMIT TRAN
END TRY
BEGIN CATCH
ROLLBACK TRAN
END CATCH |
Partager