Tag: Microsoft SQL Server
-
Recreate views after changing datatypes in referenced tables
I recently came across a problem that was difficult to diagnose. After I had changed the datatype in a table from varchar(256) to varchar(512) my Access 2013 reports show data truncated to 256 characters. It turned out that the views that I’d created against the base table were truncating the field. After changing the datatype…
-
SQL Server Import Wizard cannot import fields containing more than 255 characters
I have been importing data from Excel to SQL Server using the SQL Server Import Wizard. Usually there is no problem but I have found a bug. 1. To reproduce: Try to import a column containing more than 255 characters text, optimistically set the destination datatype to nvarchar(max) and the failure options to “ignore” on…
-
How to create a calendar table with hourly grain
Calendar Tables – Why You Need One. <credit: This section was copied from Made2Mentor> What is a Date (Calendar) Table? For the purposes of this article a Date Table is a dedicated table containing a single record for each day in a defined range. They include fields with descriptive attributes for each day such as…
Dr James Bayley 