DECLARE @USERROWS NVARCHAR(MAX)
SET @USERROWS=''
SET @USERROWS='wode'
print LEN(@USERROWS)
SET @USERROWS=SUBSTRING(@USERROWS,0,LEN(@USERROWS))
print @USERROWS --结果为 wod
DECLARE @USERROWS NVARCHAR(MAX)
SET @USERROWS='wode'
SET @USERROWS=SUBSTRING(@USERROWS,1,LEN(@USERROWS)-1)
print @USERROWS --结果为 wod
转载于:https://www.cnblogs.com/shikyoh/archive/2011/07/20/2112228.html