PivotTables are a useful function on Excel which allow you to take a large dataset and transform it into an easy-to-read table. They can be used to separate data into timescales such as years or months, to compare data categories, and to produce charRead more...
Carriage returns within text cells can often cause problems when you want to transfer data to another platform, such as a database. An easy way to remove all carriage returns from a spreadsheet is to us the Excel Find and Replace function alongRead more...
The MS Excel VLOOKUP function is useful when you need to link data from multiple tables and worksheets.
This very simple example shows how to use the arguments in the VLOOKUP function:
More advanced uses of this function will follow in this blog soon.
To add a carriage return/new line to text inside a single MS Excel cell:
Click into the cell at the location to place the new line and use the keyboard 'Alt + Enter'.
See a video example here:
If you need to retrieve the total number of fields in your database, use the following query.
select count(*),c.table_nameRead more...
from information_schema.COLUMNS c
JOIN information_schema.tables t ON c.TABLE_NAME = t.TABLE_NAME
AND c.TABLE_Schema = t.TABLE_Sch
The compilation is disabled by default. In order to enable it, modify the Properties/AssemblyInfo.cs file.
Backing up your database may not be enough to ensure you can respond to a Disaster Recovery incident.
For the purposes of this article, we'll use MS SQL Server without replication, as our working example.
Public Class SessionsRead more...
Private Sub New()
blnPriceListActive = false
Public Shared ReadOnly Property Current As Sessions
RESTORE HEADERONLY FROM DISK = <path to backup file>