--:SetVar Procedure "AUX:TrimEndingSpaces"
if exists( select * from [sysobjects] (nolock) where [type]='P' and [name]=N'AUX:TrimEndingSpaces' )
   drop procedure [AUX:TrimEndingSpaces]
GO
/* Translated by $SQLTRANS utility (SQL-file technology). Method author: Sergei Y.Kitáev.
** Script translation date-time: 2022-11-27 00:29:29.24 (stamp of SQL-file generation). */
create procedure [AUX:TrimEndingSpaces] @String nvarchar(max) out
AS
/*==================================================================================================
# SQLAUX scripting library | Author: Sergei Y.Kitáev
----------------------------------------------------------------------------------------------------
#
# TRIMMING OF TAIL SPACES (PROCEDURE):
#
# === Usage: ===
# exec [AUX:TrimEndingSpaces] @<String variable> out
#
==================================================================================================*/
begin begin try set xact_abort off; set ansi_nulls,ansi_null_dflt_on,quoted_identifier,arithabort,nocount on; set implicit_transactions off; declare @initial_tran_count_aux int, @is_local_tran_open_aux bit; select @initial_tran_count_aux=@@trancount, @is_local_tran_open_aux=0; end try begin catch throw; end catch; begin try
----------------------------------------------------------------------------------------------------

set @String = RTRIM( @String )

----------------------------------------------------------------------------------------------------
if @is_local_tran_open_aux=1 raiserror ('Not closed local transaction was detected, previously opened by BEGIN_TRANSACTION_AUX macro.',11,1); end try begin catch if @is_local_tran_open_aux=1 and (@@trancount>@initial_tran_count_aux or xact_state()=-1) rollback transaction; set @is_local_tran_open_aux=0; throw; end catch; end
/*================================================================================================*/
GO
/*
declare @String nvarchar(max)
set @String = N'   12345     '
exec [AUX:TrimEndingSpaces] @String out
select '“'+@String+'”' 'String without tail spaces'
*/
