Activity overview
Latest activity by wilsonbenj
ORDER BY
whenever i write ORDER BY clauses, i generally specify ASC or DESC after the field i am ordering by...
eg
SELECT *
FROM Table
ORDER BY TableID DESC
the thing is, when i get to typing ASC or DESC, r...
I have installed SQL Refactor as well now and havent had the problem again yet - but i did have time off over Christmas/New year so it hasnt had much use yet!
Ben / comments
I have installed SQL Refactor as well now and havent had the problem again yet - but i did have time off over Christmas/New year so it hasnt had much use yet!
Ben
nope, i dont have SQL Refactor...i might download the trial and see what happens though! / comments
nope, i dont have SQL Refactor...i might download the trial and see what happens though!
Hi,
I am running Microsoft SQL Server Management Studio 9.00.1399.00 in English (not sure if there is an English (Australian) option, but if there is, that is what it would be!)
Ben / comments
Hi,
I am running Microsoft SQL Server Management Studio 9.00.1399.00 in English (not sure if there is an English (Australian) option, but if there is, that is what it would be!)
Ben
i second that - cross database support would be a big plus! / comments
i second that - cross database support would be a big plus!
SQL Prompt Menu in SQL Management Studio
ok, so I have installed version 3, and for the 2nd time in a week, the SQL Prompt menu in SSMS is disabled (greyed out), hence i am unable to access any of the menus/options.
I found another post t...
Suggestions
couple of things i thought of
1) from memory, you used to be able to order the candidate list the same was as the columns in the table were ordered, or alphabetically...would be nice to have that o...
i must say i agree! i think the list is popping up way too much too... / comments
i must say i agree! i think the list is popping up way too much too...
you could still ensure that we always have one option selected for this! / comments
you could still ensure that we always have one option selected for this!
Joins
when doing a join, the list of suggested joins is displayed after typing ON as i would expect, however if you press the space bar after selecting an item from the list, it displays the list of poss...