SQL GROUP BY and HAVING clauses
Continuing with SQL interview questions, please check out my second SQL post on SQL GROUP BY and HAVING clauses on my Programming Interviews Series blog….( read more )
Continuing with SQL interview questions, please check out my second SQL post on SQL GROUP BY and HAVING clauses on my Programming Interviews Series blog….( read more )
Turning my focus on SQL interview questions, please check out my first of many posts on SQL Select Where Interview Questions on my Programming Interviews Series blog….( read more )
Check out my latest post on Differentiate between alert(), prompt() and confirm() methods on my new blog on Programming Interviews Series ….( read more )
I have been working on a customer solution and have gotten to do some fun coding this week. As usual, I wanted to share it with you so that you can maybe learn a few new ways of working with SharePoint. The business problem is that the business wants users to view and accept a Terms & Conditions page before progressing on to the rest of the site. I will be covering the entire scenario in a series of posts, starting with this one. What is a Page Layout?
Good afternoon and happy Friday to each and every one of you.
Keyboard: ALT + SHIFT + T (line); CTRL + SHIFT + T (word); CTRL + T (character) Command: Edit.LineTranspose; Edit.WordTranspose; Edit.CharTranspose Versions: 2008,2010 Published: 4/8/2010 Code: vstipEdit0042 Download the seriously cool Tip of the Day Extension to get the daily tips delivered to your Start Page! Ever have a line you want to move down or switch with another line? Well it’s easy! Just find a couple of lines you want to switch and put your cursor in the top line: Then press ALT + SHIFT + T to transpose the two lines: This feature also works with words: CTRL + SHIFT + T: And characters as well: CTRL + T:
I just ran across a PowerPoint presentation by a colleague, David Chou , that is just plain awesome. Check out this deck on the Windows Azure platform. Windows Azure Platform View more presentations from lynnlangit .
Versions Supported: 2010 Keyboard Shortcut: CTRL + M, CTRL + H Menu Command: Edit -> Outlining -> Hide Selection Tip Code: vstipEdit0036 This is a new feature in VS2010 that absolutely rocks! Let’s say you have a chunk of code like this: Notice that Outlining only allows you to collapse the entire member by default (minus sign in the upper left-hand corner). What if you want to, say, collapse the “if” statements at the top? In prior versions you were out of luck but NOW you can do it. Here’s how: Select the chunk of code you want to hide: Now either press CTRL + M, CTRL + H or go to Edit -> Outlining -> Hide Selection on your Menu Bar to get this: Congratulations! You have successfully collapsed a custom region of code!
Versions Supported: 2008,2010 Keyboard Shortcut: CTRL + M, CTRL + M (toggle outlining expansion) Menu Command: Edit -> Outlining -> Toggle Outlining Expansion Tip Code: vstipEdit0035 When working with Outlining, you can perform many timesaving operations. One of those is the ability to take a long, funky chunk of code and worked with it in a collapsed state. Take, for example, this method that doesn’t even fit on the entire screen: When we collapse it using Outlining (click on the minus sign to the left of the signature) we get this: Now we can cut, copy, and paste all of that code in one compact, ready to go, unit! Try it yourself and see.
Versions Supported: 2008,2010 Menu Command: Tools -> Options -> Environment -> Documents Tip Code: vstipEdit0027 Normally, when you open up a new document it creates a new tab but you can just have the file open up in the current tab instead. Let me illustrate: Default (before): Default (after): But if you go to Tools -> Options -> Environment -> Documents and check the “Reuse current document window, if saved” option. This is what happens: Before: After: The caveat here is you have to have a “clean” (saved) document for this to work. If the document was “dirty” (not saved) this would be the result even with this option turned on: Before (note the asterisk to indicate the document is dirty): After:
Versions Supported: 2008,2010 Menu Command: Tools -> Options -> Text Editor -> All Languages -> General Tip Code: vstipEdit0025 Line numbers are not on by default. To turn on line numbers just go to Tools -> Options -> Text Editor -> General and check Line Numbers:
This made my jaw drop.