String Formatting
cabolet
Posts: 8
It would be nice if SQL-Prompt had an option to change the output to a string that I can use in programming language.
Example:
Example:
SELECT DISTINCT
SSD_ServerName
, SSD_InstanceName
, SSD_DatabaseName
, SUM(SSD_DBFileSize_MB)
FROM
dbo.tbl_SSD_SQLServerDatabase
WHERE
SSD_SQS_ID = @iInstanceID
AND SSD_DBFileType = 'LOG'
GROUP BY
SSD_ServerName
, SSD_InstanceName
, SSD_DatabaseName
Change into:
strSQL = "SELECT DISTINCT " _
& " SSD_ServerName " _
& " , SSD_InstanceName " _
& " , SSD_DatabaseName " _
& " , SUM(SSD_DBFileSize_MB) " _
& " FROM " _
& " dbo.tbl_SSD_SQLServerDatabase " _
& " WHERE " _
& " SSD_SQS_ID = @iInstanceID " _
& " AND SSD_DBFileType = 'LOG' " _
& " GROUP BY " _
& " SSD_ServerName " _
& " , SSD_InstanceName " _
& " , SSD_DatabaseName "
Comments
Could I ask you to suggest it on our Uservoice site for Prompt? That way, we can gauge interest from other users in seeing this feature.
Redgate Software