Posts
Sort by recent activity
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...
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...
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...