Comments
Sort by recent activity
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...
When it comes down to it I think it's probably about right. The previous price tag was small enough for a developer to out of pocket expense it, but $95 still small enough to justify the productivity increase to his/her employer depending upon how much time they spend writing SQL. / comments
When it comes down to it I think it's probably about right. The previous price tag was small enough for a developer to out of pocket expense it, but $95 still small enough to justify the productivi...
Neil Davidson wrote:
I'm hoping that even at $95 our users will be able to recoup their inital outlay very quickly. That's under an hour of billable time for a developer / DBA, so payback should be quick.
...
I'd be interested to know what other forum posters think.
For that hourly rate I think I'd like to work for red-gate software :lol: / comments
Neil Davidson wrote:
I'm hoping that even at $95 our users will be able to recoup their inital outlay very quickly. That's under an hour of billable time for a developer / DBA, so payback should...
Wow, that's aggressive! / comments
Wow, that's aggressive!
I figured out the pricing by clicking the "Buy Now" button on the Start up prompt. $95USD / comments
I figured out the pricing by clicking the "Buy Now" button on the Start up prompt. $95USD
You can keep a backup of the snippets by looking in
\documents and Settings\[your user]\Local Settings\Application Data\Red Gate\SQL Prompt
and copy off options.xml which contains all your snippets / comments
You can keep a backup of the snippets by looking in
\documents and Settings\[your user]\Local Settings\Application Data\Red Gate\SQL Prompt
and copy off options.xml which contains all your snippets