今天碰到一个问题,需要在SQL Server中用print打印出需要的信息,其中要求每一条信息完了之后换行,想到可以用字符串拼接,然后在字符串中添加换行处理。如下:
DECLARE @COUNT_DETAILS INTDECLARE @COUNT_ASSETPLAN INTDECLARE @COUNT_PRINCIPAL INTDECLARE @COUNT_INTEREST INTSET @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'完全拆分' elseprint 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 )