geohernandez - Journey of a Database Engineer
  • ABOUT
  • CONTACT ME
ABOUT
CONTACT ME
geohernandez - Journey of a Database Engineer
  • ABOUT
  • CONTACT ME
Chronicles from the trenches•T-SQL

Dealing with errors for SQL_Variant datatype in MS SQL Server

September 15, 2018 by geohernandez 1 Comment

I have to confess; I have had traumatic experiences with variant data type in my beginning as a software developer, in fact, I always have believed that it is an anti-pattern, at least in the OOP world, on the other hand in the Database world it gains much relevance, Why? Because of every column inside a table is supposed to be a specific datatype, otherwise, it could create a great number of conflicts and uncomfortable situations.

Continue reading
Share:

Search for articles

Recent Posts

  • Implementing CTE for filling gaps inside a sequence
  • Using recursive CTE for generating a specific number of rows
  • Soft skills and Why we must improve them

Categories

  • Chronicles from the trenches (5)
  • DB optimization (1)
  • SSIS (2)
  • T-SQL (4)

Archives

  • November 2018 (3)
  • October 2018 (1)
  • September 2018 (1)
  • August 2018 (2)

Subscribe to our newsletter

© 2018 copyright Geo Hernandez // All rights reserved
Step by Step