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
This post contains the C# class code, used to get the connection string for Entity Framework
Script to show or hide a text box based on the value of a selected drop-down list
Code used to populate a list of drop-down options for an MVC application
Today I worked out how to transpose SQL dates (copied from SQL Server) in Microsoft Word…..
Hi. The Transact-SQL script below returns the following information: ID – Just an identity column used within the script SchemaName – The name of the schema TableName – Obviously, the name of the table 🙂 ColumnName Type – The data type of the column Length – The maximum number of bytes used by the field […]