Table type

  • Admingod

    SSCertifiable

    Points: 5528

    I just want to validate my use of a custom type. I'm doing a query on that I need to pass an unknown number of string values to. I created a custom table type, with a script that looks like, What length should I make the field, for it to be of use to others? I'm using it to hold values obtained from the field Column, which is only 10 characters in length. The length in the X table field Column is 2600, though I'll never have need for that many, in this particular use case.

    CREATE TYPE [dbo].[ColumnTableType] AS TABLE(

    [Column] [nvarchar](30) NULL

    )

    GO

     

Viewing post 1 (of 1 total)

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