String Formatting

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:

SELECT DISTINCT
    SSD_ServerName
,	SSD_InstanceName
,	SSD_DatabaseName
,	SUM&#40;SSD_DBFileSize_MB&#41;
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&#40;SSD_DBFileSize_MB&#41; " _
	& " FROM " _
	& "     dbo.tbl_SSD_SQLServerDatabase " _
	& " WHERE " _
	& "     SSD_SQS_ID			= @iInstanceID " _
	& "     AND SSD_DBFileType	= 'LOG' " _
	& " GROUP BY " _
	& "     SSD_ServerName " _
	& " ,	SSD_InstanceName " _
	& " ,	SSD_DatabaseName "

cabolet February 16, 2013 10:25

Comments

1 comment

That's quite a nice idea actually

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.

James B February 18, 2013 09:34

0

Add comment

Please sign in to leave a comment.

How can we help you today?

String Formatting

Comments

Add comment