| Author |
Message |
cabolet
Joined: 15 Feb 2006
Posts: 5
|
 Posted: Sat Feb 16, 2013 4:25 pm Post subject: 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:
| Code: |
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 "
|
|
|
| Back to top |
|
 |
james.billings
Joined: 16 Jun 2010
Posts: 864
Location: My desk.
|
| Posted: Mon Feb 18, 2013 3:34 pm Post subject: |
|
|
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. |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
