Would you like to increase the “TOP” limit when selecting or editing rows?? Then this post will help 🙂
This post is work in progress, but I am looking into the use of Full Text Search within SQL Server.
I have just found out, that if you want to enter a carriage return into an Excel cell, just press Alt+Enter 🙂
If you need to find out if a database is being used (or when it was last updated), a useful script contained within this post, will return the maximum date for each and every date/time field within all tables in the current database
When I searching the internet (in March 2013) I came across a useful list of shortcut keys for use within SQL Server when coding.
I recently copied all my e-mails out of an archive folder, so I could zip them up on my hard drive and then delete them out of my mailbox. To do this I wanted to rename each file with the date the email was sent, using the format YYYY-MM-DD. The Visual Basic for Application script within this post does just that 🙂
Back in January 2013, I had a problem with a computer I had assembled, incorporating an Intel DH77DF motherboard. It turned out it was a BIOS problem and was rectified by updated the BIO using a USB memory stick. This post will help you if you have similar problems.
Comparison between MIcrosoft SQL Server Transact-SQL and MySQL Syntax