Post reply

SQL Server created a strange data type.

  • July 15, 2014 at 8:12 am

    #291151

    I was troubleshooting an insert statement and decided to use the source query to create a table using the method of

    Select BLAH

    Into Yadda_Table

    From ChaChaCha

    I'd look at the structure of the table to see if anything jumped out at me and it did... it ran me over and jumped on my carcass.

    I got a data type back of (Notes(varchar(800)) which I've never seen that kind of data type structure before. Any thoughts on this? Google is silent on this one so far.

  • July 15, 2014 at 8:32 am

    #1729490

    Looks like you have user-defined data types in that database. My guess, Notes is a data type that someone's created at some time. Select Into will keep the same data type as in the source table. If the source table has user-defined data types, so will the created table.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 15, 2014 at 8:52 am

    #1729498

    You're right. I traced it back to the original source and it turns out it was a database imported from a vendor. They created that data type in their database...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply