bobbyache icon

Declare a column to use a sequential GUID in a table.

bobbyache | PRO | 01/23/19 08:55:14 AM UTC | 0 ⭐ | 6335 👁️ | Never ⏰ | []
T-SQL |

200 B

|

None

|

0 👍

/

0 👎

CREATE TABLE TestSeqGUID
(
    TestID      uniqueidentifier        CONSTRAINT Test_TestID_Default      DEFAULT newsequentialid(),
    Inserted    datetime                 CONSTRAINT Test_Inserted_Default   DEFAULT GETDATE()
)
go

Comments

  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎