Page 56 - SQL
P. 56

UNIQUEIDENTIFIER


        A 16-byte GUID / UUID.


         DECLARE @GUID UNIQUEIDENTIFIER = NEWID();
         SELECT @GUID -- 'E28B3BD9-9174-41A9-8508-899A78A33540'
         DECLARE @bad_GUID_string VARCHAR(100) = 'E28B3BD9-9174-41A9-8508-899A78A33540_foobarbaz'
         SELECT
             @bad_GUID_string,   -- 'E28B3BD9-9174-41A9-8508-899A78A33540_foobarbaz'
             CONVERT(UNIQUEIDENTIFIER, @bad_GUID_string) -- 'E28B3BD9-9174-41A9-8508-899A78A33540'


        Read Data Types online: https://riptutorial.com/sql/topic/1166/data-types










































































        https://riptutorial.com/                                                                               38
   51   52   53   54   55   56   57   58   59   60   61