今天碰到一个问题,需要在SQL Server中用print打印出需要的信息,其中要求每一条信息完了之后换行,想到可以用字符串拼接,然后在字符串中添加换行处理。如下:
DECLARE @COUNT_DETAILS INT
DECLARE @COUNT_ASSETPLAN INT
DECLARE @COUNT_PRINCIPAL INT
DECLARE @COUNT_INTEREST INT
SET @COUNT_DETAILS = ( SELECT COUNT(DISTINCT DIMLOANID) FROM TrustManagement.TrustManagement.tblAssetDetails_New WHERE TrustId = 157 )
SET @COUNT_ASSETPLAN = ( SELECT COUNT( DISTINCT DIMLOANID) FROM TrustManagement.Asset.TrustAssetPaymentPlan_New WHERE TrustId = 157 )
SET @COUNT_PRINCIPAL = ( SELECT COUNT( DISTINCT DIMLOANID) FROM TrustManagement.Asset.PrincipalSchedule_New WHERE TrustId = 157)
SET @COUNT_INTEREST = ( SELECT COUNT( DISTINCT DIMLOANID ) FROM TrustManagement.Asset.InterestSchedule_New WHERE TrustId = 157 )
if @COUNT_DETAILS = @COUNT_ASSETPLAN and @COUNT_ASSETPLAN = @COUNT_PRINCIPAL and @COUNT_PRINCIPAL = @COUNT_INTEREST
print N'完全拆分'
else
print N'不完全拆分'
print ' COUNT_DETAILS ' + convert(nvarchar, @COUNT_DETAILS ) + char(13) +
' COUNT_ASSETPLAN ' + convert(nvarchar, @COUNT_ASSETPLAN ) + char(13) +
' COUNT_PRINCIPAL ' + convert(nvarchar, @COUNT_PRINCIPAL ) + char(13) +
' COUNT_INTEREST ' + convert(nvarchar, @COUNT_INTEREST )