User Defined type issue

2013-12-09
2013-12-09
  • If table has column with user defined type it will raise exception, during tSQLt.FakeTable SP.

    One of possible fix is
    ....
    CASE WHEN @CollationName IS NULL OR @CollationName = CONVERT (varchar, DATABASEPROPERTYEX(DB_NAME(),'collation')) THEN ''
    ELSE ' COLLATE ' + @CollationName
    END Collation
    ....
    in the [tSQLt].[Private_GetFullTypeName] function