Posts
Sort by recent activity
Have Refresh Suggestions also refresh SSMS IntelliSense
Would it be possible when SQL Prompt's Refresh Suggestions is run it can also refresh SSMS's IntelliSense cache (equivalent of the menu Edit/IntelliSense/Refresh Local Cache or Edit.RefreshLocalCac...
Formatting in 7.3.0.535
If I format the following
Select *
From Person.Address As a
Where a.AddressID In ( - 1, -2, -3 )
You will notice that there is a space between the negative sign and the 1 (-[space]1), but the rest...
Formatting in 7.3.0.522: Why is it wrapping like this?
I created a restore script for someone to use, then formatted the SQL. FYI, my wrapping is set to 200.
Use master
Alter Database ABitLongerDatabaseName
Set Single_User
With Rollback Immediate
Res...
Problem with Tab History in 7.3.x beta
Hello,
I have noticed a problem with Tab History in the new round of 7.3.x betas, including the latest 7.3.0.460. The problems is that not all of my tabs are re-opening after I restart SSMS--some, ...
Issues with comments in 7.3.0.450
If you take this...
Begin
/*
* Should look like this
*/
Select 1
End
and run "Format SQL", it looks like this... (Hint: The /* got moved up after the Begin)
Begin /*
* Should look like ...
SQLPrompt 7.3.437 question
I am trying out the formatting in 7.3.437 (and yes, I know it's pre-release, so these may be on your list...), but I have two things so far.
If these options exist already, just let me know where I...
Single Line comments move to the next line
I don't know if this is a bug, or if this is a feature request. This is not a new bug/feature--it's been around for a while, I'm just getting around to mentioning it.
If you paste in the following ...
Insert Into @table with Identity Column
Hello,
SQL Prompt (at least 7.1.0.44) does not recognize an Identity column in a declared table when using "Insert Into".Declare @WorkContestNew table
(
Id int Identity
Prima...
Open in Excel (7.1.0.118)
When opening a result grid that contains datetime fields, the datetime values appear to be exported as strings. that is, if I have a datetime value of '2014-07-08 00:00:00.000', it still says '2014...
bug in cuff snippet
I just tried the cuff snippet today and I think I found a bug.
/* declare variables */
DECLARE @variable INT
DECLARE $cursor_name$ CURSOR FAST_FORWARD READ_ONLY FOR $select_statement$
OPEN $curso...