Activity overview
Latest activity by Michael.Kriegner
Thank you for your quick answer. I have seen your new solution in SQL Prompt 4.0. But, quite frankly I would prefer to configure it. It would be perfect, if it goes hand in hand with the layout functions/configuration.
Thank you for your great support!
Michael Kriegner / comments
Thank you for your quick answer. I have seen your new solution in SQL Prompt 4.0. But, quite frankly I would prefer to configure it. It would be perfect, if it goes hand in hand with the layout fun...
I agree with geophphrie. Sometimes I write a single line of code in middle of a procedure/function, just to select this line, execute it (for testing something or getting info) and delete the line.
I often get the whole screen with red lines and while tipping the code, they are flickering very nervous. That's very annoying and would also be a reason for me, to turn it off.
Besides, I got many exceptions (most times object null references) so I had to deinstall it. Version 3.9 works fine. / comments
I agree with geophphrie. Sometimes I write a single line of code in middle of a procedure/function, just to select this line, execute it (for testing something or getting info) and delete the line....
Foreign keys from another database?
Is it possible to select foreign key values from tables in another database? Something to customize with a select? Because we have many datatables shifted into a main database.
Thanks for help,
Mic...
Hi,
I also don't like the behaviour on double-clicking identifiers. Selection stops on underlines (something like SP_Help). Therefor @variable is now selected completely. This wasn't in version 3.9. For me, I prefer the default behaviour from SSMS (always select the whole identifier). Hope you can change this or make a setting.
I also would wish easy functions like $Date$, $Time$, $Username$, $Computername$ in code snippets (perhaps even $Database.dbo.ScalarFunction$) and something to import my old snippets.
Thank you very much for early access (great idea!) ,
Michael Kriegner / comments
Hi,
I also don't like the behaviour on double-clicking identifiers. Selection stops on underlines (something like SP_Help). Therefor @variable is now selected completely. This wasn't in version 3.9...
INSERT Auto-Completion layout feature
Perhaps you could consider a setting for layouting the insert statement.
I would write insert-statements like this:INSERT TableX
(
Column1,
Column2
)
VALUES
(
-- @Column1,
...