Comments
Sort by recent activity
In your Windows user profile under \Local Settings\Application Data\Red Gate\SQL Prompt there lives a file called options.xml. This contains all your snippets as well as the other options.
So in a typical windows installation assuming your username is Olaf it would be c:\Documents and Settings\olaf\Local Settings\Application Data\Red Gate\SQL Prompt\options.xml / comments
In your Windows user profile under \Local Settings\Application Data\Red Gate\SQL Prompt there lives a file called options.xml. This contains all your snippets as well as the other options.
So in a ...
Surround the Parens with braces:
UPDATE table SET column = REPLACE{(}column,' ', ' '{)} http://www.red-gate.com/help/sqlprompt/Topics/SPT_ConfigAutoInsert.html / comments
Surround the Parens with braces:
UPDATE table SET column = REPLACE{(}column,' ', ' '{)}http://www.red-gate.com/help/sqlprompt/Topics/SPT_ConfigAutoInsert.html
Yes, auto indentation for those editors that don't do it would be wonderful. / comments
Yes, auto indentation for those editors that don't do it would be wonderful.
The link given doesn't work. Take off trailing "." http://www.red-gate.com/products/SQL_Prompt/index.htm / comments
The link given doesn't work. Take off trailing "."http://www.red-gate.com/products/SQL_Prompt/index.htm
It's great to know that you're listening to the feedback you've been getting, count me in for a sale. 8) / comments
It's great to know that you're listening to the feedback you've been getting, count me in for a sale. 8)
You can disable this bhavior:
Open the SQL Prompt Options
Go to the "Options" tab
Locate the Listbox labeled "Words that will trigger the candidate list"
Remove "ON"
I know what you mean because I format my JOINS the exact same way. (4 space tabs) / comments
You can disable this bhavior:
Open the SQL Prompt Options
Go to the "Options" tab
Locate the Listbox labeled "Words that will trigger the candidate list"
Remove "ON"
I know what you mean because I ...
kkozera wrote:
On multi-line snippets: I put my cursor a few tabs into the code window and executed the snippet. The first line of code started at my cursor position, but the following lines started back at the left side.
This is because each character is a literal keystroke sent to the editor. So an editor like QueryAnalyzer or SSMS will behave like this becuase the same thing would happen if you were to manually type in the snippet. Visual Studio on the other hand has smart indentation that auto-inserts
the tabs for you.
Perhaps that could also be a new feature: inserting smart indentations. / comments
kkozera wrote:
On multi-line snippets: I put my cursor a few tabs into the code window and executed the snippet. The first line of code started at my cursor position, but the following lines s...
Another thing I found that happens is if I were to give an invalid snippet syntax then use it in the editor random chunks of the output get skewed. While this is understandable (garbage in, garbage out) it effects the snippets engine from then out. Other correct snippets start behaving the same way and other odd things will happen even after the erroneous snippet is fixed. The only way to get around it is to restart the SQL Prompt app. / comments
Another thing I found that happens is if I were to give an invalid snippet syntax then use it in the editor random chunks of the output get skewed. While this is understandable (garbage in, garbage...
kkozera wrote:
When creating snippets with parens in them, the parens are not being included when the snippet is executed
Parens must be escaped with braces {}, so say you wanted
GETDATE()
the snippet syntax would be
GETDATE{(}{)}
(edited to fix bbcode) / comments
kkozera wrote:
When creating snippets with parens in them, the parens are not being included when the snippet is executed
Parens must be escaped with braces {}, so say you wanted
GETDATE()
the...
mkearl wrote:
I think most developers in the corporate world would have a tough time convincing corporate to puchase a tool that saves them a bit of typing.
I have to disagree with this because look at Coderush priced at $250 per seat. This is pretty popular software. Granted the huge scope of features of CodeRush makes it nearly incomparible to Sql Prompt but they both have the same goal.
Of course having said that as it stands I'm probably not going to buy Sql Prompt, but it also depends upon what changes from beta->release. If the price was $50 I would buy it as it is and live with the quirks. / comments
mkearl wrote:
I think most developers in the corporate world would have a tough time convincing corporate to puchase a tool that saves them a bit of typing.
I have to disagree with this because...