Post reply

Including Structures

  • June 10, 2004 at 11:44 am

    #87690

    I come from an environment where we had standard structures for addresses, time stamps, etc. and we included them in tables where we wanted. This saved us a lot of time and it tended to be less error prone. Does SQL Server have anything similar?

    What about writing Standard SPs? Where would I define them?

  • June 11, 2004 at 4:55 am

    #510017

    You can create User-defined data types when you need to store the same type of data in multiple tables. User-defined data types ensure that those columns containing this information have the same data type, length, and nullability.

    See Creating User-Defined Data Types in BOL.

     

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

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