How can we help you today? How can we help you today?
rjpaulsen
Activity overview Badges (0) Posts (12) Comments (26)

Comments

Sort by recent activity
On a related note, if you use a custom alias and then use SqlPrompt to instert a field, it will use the automatic alias value instead of the custom alias. In the example below, the table "Organization" is automatically aliased as "o", but I have chosen to use Org. SELECT * FROM Organization AS Org If using SqlPrompt to instert a field in the WHERE clause, you will get (Note the aliased named in the WHERE clause): SELECT * FROM Organization AS Org WHERE o.[OrgName] = 'Test' I'm not typing the query right now so I cannot test, but it may only occur if you leave out the 'AS' keyword when aliasing the table name. SELECT * FROM Organization Org WHERE o.[OrgName] = 'Test' / comments
  1. Community
  2. SQL Prompt 3 Beta
  3. Non-aliased query uses Aliases intellisense
On a related note, if you use a custom alias and then use SqlPrompt to instert a field, it will use the automatic alias value instead of the custom alias. In the example below, the table "Organizat...
0 votes
I feel like I was forced to agree. I want a recount. / comments
  1. Community
  2. SQL Prompt 3 Beta
  3. Should SPACE be used to select candidates by default?
I feel like I was forced to agree. I want a recount.
0 votes
I would suggest not making it the default. / comments
  1. Community
  2. SQL Prompt 3 Beta
  3. Should SPACE be used to select candidates by default?
I would suggest not making it the default.
0 votes
I like the 'Auto' alias feature, but I think a custom auto feature like PDinCA suggested. / comments
  1. Community
  2. SQL Prompt 3 Beta
  3. Define our own list of table Aliases?
I like the 'Auto' alias feature, but I think a custom auto feature like PDinCA suggested.
0 votes
Recent Queries/Query History A way to bring up recently typed queries, and 'as a template'. For example, while poking around data I may use the same 3 or 4 queries over and over, but with different values in the where clause. SSF Table1 WHERE UserID = 123 SSF Table2 WHERE RecordType='XYS' Kind of like how IE shows your previous URLs in the address bar. If not 'as a template', at least give the last few queries as I typed them in. Default Queries Each table would have one or more 'default' queries attached to it. For example, most of the time when I pull a record from the [Users] table, I enter one of two statements: SELECT*FROM Users WHERE UserID = 123 AND Status='Active' or SELECT*FROM Users WHERE LastLogin >= DATEADD(d, -1, GETDATE()) In SqlPrompt2, typing "SSF<tab>Users" becomes "SELECT * FROM Users" In the new version, typing "SSF"+"Users" would give a list of the two above queries + the option for a 'new' query. In the example below, Opt1 is the 'new' query, and Opt2/3 are the 'default' queries for the "Users" table. Opt1: SELECT*FROM Users Opt2: SELECT*FROM Users WHERE UserID = 123 AND Status='Active' Opt3: SELECT*FROM Users WHERE LastLogin >= DATEADD(d, -1, GETDATE()) Scripting Sprocs/Views I would like the ability to edit SPROCS/VIEWS w/o using the mouse. I would like to type something like... ALTER MySproc<tab> ...and get the complete contents of MySproc, as an alter statement, displayed on the screen. Slicing Sproc/View Scripts The current version of Sql Prompt shows the script for creating views/sprocs but does not allow you to select the text. Of course with the previous suggestion, this would not be needed. Selecting Multiple Fields When typing "SELECT" and the fields are displayed, it would be nice to select multiple fields instead of just one. Sounds like you're already on this. Selecting Commonly Used Fields When selecting fields from a table, it would be nice if the commonly used fields are listed first. For example, I have key for OrgID that is involved in almost every query I write. / comments
  1. Community
  2. SQL Prompt 3 Beta
  3. Any Other Features
Recent Queries/Query History A way to bring up recently typed queries, and 'as a template'. For example, while poking around data I may use the same 3 or 4 queries over and over, but with different...
0 votes
It would be nice if it 'learned' from the user. For example, if I normally give a table a specific alias then that is the alias that it would automatically use next time. This would also apply to my previous post about 'default' queries on tables. SqlPrompt would 'learn' what queries I usually use against specific tables. / comments
  1. Community
  2. SQL Prompt 3 Beta
  3. Any Other Features
It would be nice if it 'learned' from the user. For example, if I normally give a table a specific alias then that is the alias that it would automatically use next time. This would also apply to m...
0 votes
I posted this as a seperate message, but I guess it should go in this thread: Candidate List in FROM clause: In the WHERE clause, the candidate list displays fields from tables that are not in the FROM clause. I do not like how it shows these fields as options or how it adds the table to the FROM clause w/o a join. It is like if Intellisense displayed variables that are out of scope. How often do you have a multi-table FROM clause where a table is not part of a join? Even if Sql Prompt adds the table for you, you still need to go 'take care of it' by making the automatically added table part of a join. It is good that they are listed first, but it makes that list long and harder to look at. It also gives you the ability to automatically generate 'bad' Sql (the table w/o the join). I think just showing the fields from the current tables is best. / comments
  1. Community
  2. SQL Prompt 3 Beta
  3. What is Displayed in the Candidate List
I posted this as a seperate message, but I guess it should go in this thread: Candidate List in FROM clause: In the WHERE clause, the candidate list displays fields from tables that are not in the ...
0 votes
I agree. / comments
  1. Community
  2. SQL Refactor Beta
  3. Suggestion: Layout should correct the case of keywords
I agree.
0 votes
If listing features I'd like to see, this would not be one I would have thought of. I cannot think of the last time that I had to do this function, although I would be handy if I ever had to do it. I'd be more likely to use (purchase) a product that helps me a little bit all day long* instead of one that helps me once a month**. * Format Sql. ** Split tables into two. / comments
  1. Community
  2. SQL Refactor Beta
  3. Table Split
If listing features I'd like to see, this would not be one I would have thought of. I cannot think of the last time that I had to do this function, although I would be handy if I ever had to do it....
0 votes
I think this will be handly, I is just not one of those tools that you need every day (Unlike Lay out Sql). I used it a few times just to try it and it seems to work well. It would be nice if it supported the renaming of columns. / comments
  1. Community
  2. SQL Refactor Beta
  3. Smart Rename feature
I think this will be handly, I is just not one of those tools that you need every day (Unlike Lay out Sql). I used it a few times just to try it and it seems to work well. It would be nice if it su...
0 votes
Total activity
57
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
19