2-column liquid width layout template. Made for 1280x1024 screens and modern browsers but it should degrade well for smaller screens and older browsers. The template is a result of my obsession with dark colors. Personally, I find dark-templates harder to create than the lighter counterparts, which is rather sad because I find it so much easier ( on my eyes ) to read light text on dark backgrounds than dark text on light backgrounds.
EXEC sys.sp_tablesBut this will list every single table, including all the system tables, which we rarely ever want. To list only tables created by the user, add a @table_owner parameter. For most databases, this will be "dbo":
EXEC sys.sp_tables NULL, 'dbo', NULL, NULL, NULL
I thought long and hard about whether to make this a commercial template, because it involved a bit more work than the rest of them, but in the end decided that I'm going to keep it free. :-)
Enjoy!
COALESCE is a cool little function whose name/purpose I keep forgetting/confusing with other cool functions.
Anyway: COALESCE returns the first non-null value in a list:
PRINT COALESCE(900, NULL, 10, NULL, 40)The result: 900.
PRINT COALESCE(NULL, NULL, 10, NULL, 40)The result: 10.
Note that at least one value must be non-null. For example:
PRINT COALESCE(NULL, NULL, NULL)will result in an error — "At least one of the arguments to COALESCE must be a typed NULL."
I was dusting my hard drive the other day, and I came across a template I created way back. I did a couple of quick changes, and here you have it. Enjoy!
As always, you can do whatever you want with it. A mention and a link isn't necessary but is very much appreciated. :-)
After a marathon coding session, I finally have the new design online. I'm rather pleased with the design at the moment, and, hopefully, I'll remain just as pleased with in the coming months. You might have noticed ( if you didn't, notice it now ) the urls. I managed to get rid of the index.php in an extremely hackish way, but then, I tend to be anal-retentive about these kind of things. Also, the urls don't include subdomains anymore. While it seemed like a good idea back when it started, it started grating on my nerves the last couple of days. Undoubtedly, this is going to cause broken links and what-not, but hopefully everything will be back to normal in a couple of weeks.
There are a couple of things left to do still — namely, the contact form and the search results page...
Life-saving keyboard shortcuts that will make your life better now that you know them. Windows-only. If you're a Mac user, go away. 1. ALT + SPACE + N = Minimizes the currently active window. 2. WINDOWS + M = Minimizes all windows. Or, you can also use WINDOWS + D to minimize/restore all windows. 3. ALT + PRINT SCREEN = Screenshot of the current window. ( <— Woohoo! ) 4. CTRL + TAB = Switches between windows in the current application. 5. CTRL + F6 = Same as above, except that the above sequence acts like an ALT+TAB for the application whereas this one just goes to the next active window. 6. WINDOWS + E = Opens Windows Explorer. 7. WINDOWS + L = Locks the computer. 8. WINDOWS + BREAK = Opens System Properties. 9. WINDOWS + CTRL + F = Opens computer search. 10. WINDOWS + R = Opens run.
There are also the well-known ( one hopes ) CTRL+C (copy), CTRL+V (paste), CTRL + X (CUT), CTRL+W (close active window), ALT+F4(close active application) that I couldn't possibly live without.
Read more at Keyboard Shortcuts for Windows