User profile for rjpaulsen

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

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

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

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

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

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

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

How can we help you today?

rjpaulsen

Comments