nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

2529_en-US

liliconcom

Heads Up: TSQL sql_variant data type WILL NOT import into JMP

I just discovered that JMP (version 8 at least) will not import column data type "sql_variant" into its tables.

I spent all afternoon trying to figure out why two columns would not load in my JMP ODCB SQL query. I finally noticed that those two columns are "sql_variant" data type.

Very easy fix though: just convert your column data type in SQL using CAST. For example, if your "sql_variant" column is "Blah", SELECT it as "CAST( Blah AS VARCHAR(MAX))" or int, datetime, etc...

Cheers!
Chadd

Comments

There are no comments yet

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of