Comments
Sort by recent activity
The latest release works perfectly, thanks very much! / comments
The latest release works perfectly, thanks very much!
That's a remarkable response time! I look forward to the next release then. / comments
That's a remarkable response time! I look forward to the next release then.
The latest release fixes this problem as well. Nice work! / comments
The latest release fixes this problem as well. Nice work!
Confirmed, this now works as expected (and thanks for calling it a CASE expression, too!) / comments
Confirmed, this now works as expected (and thanks for calling it a CASE expression, too!)
Yes, that would be correct: I would expect the "place first item on new line" setting to supersede the "Collapse CASE statements" setting. / comments
Yes, that would be correct: I would expect the "place first item on new line" setting to supersede the "Collapse CASE statements" setting.
Confirmed, Aaron, the latest beta version allows me to format MERGE statements. / comments
Confirmed, Aaron, the latest beta version allows me to format MERGE statements.
Here's a genericized version of my stored procedure:
CREATE PROCEDURE spSampleOutput
(
@Date DATETIME2(3)
,@Int INT = 0 OUTPUT
)
AS
SELECT @Int = DATEDIFF(DAY, @Date, GETDATE())
If I create that stored procedure, open up a new query, and type "Execute spSampleOutput", SQL Prompt will auto-fill the details for me:
EXECUTE dbo.spSampleOutput
@Date = '2016-08-18 14:42:29'
, -- datetime2(23)
@Int = 0 -- int
Right-clicking spSampleOutput and choosing "Inline stored procedure" generates the following code:
DECLARE @Date DATETIME2(3);
SET @Date = '2016-08-18 14:42:29';
SELECT 0 = DATEDIFF(DAY, @Date, GETDATE()) -- int
Attempting to execute it, naturally, results in the following error:
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '='.
/ comments
Here's a genericized version of my stored procedure:
CREATE PROCEDURE spSampleOutput
(
@Date DATETIME2(3)
,@Int INT = 0 OUTPUT
)
AS
SELECT @Int = DATEDIFF(DAY, @Date, GETDATE())
If I create ...
And, after updating to SQL Source Control 5.2.0.318, the issue goes away. I'd assume this was part of the fix "SOC-7874, SOC-7878: SQL Source Control will clean-up temporary tables used when registering a database." / comments
And, after updating to SQL Source Control 5.2.0.318, the issue goes away. I'd assume this was part of the fix "SOC-7874, SOC-7878: SQL Source Control will clean-up temporary tables used when regis...
Up until this morning, I was using 7.2.2.273, and the highlighting didn't work: [image]
I downloaded 7.2.4.291 an hour ago, and apparently something you did fixed this issue, since I'm also not seeing it now. Reading over the release notes, perhaps it was a side effect of "Support ticket 67262: Fix for rename alias/variable inside OVER clauses not working"? / comments
Up until this morning, I was using 7.2.2.273, and the highlighting didn't work:
I downloaded 7.2.4.291 an hour ago, and apparently something you did fixed this issue, since I'm also not seeing it n...
I couldn't find this request on the UserVoice site, so I added it here: https://sqldoc.uservoice.com/forums/164799-general/suggestions/16044577-add-data-types-to-views
Was this request ever reviewed somewhere else, or given a priority/ETA? / comments
I couldn't find this request on the UserVoice site, so I added it here: https://sqldoc.uservoice.com/forums/164799-general/suggestions/16044577-add-data-types-to-views
Was this request ever reviewe...