I am using NewID() to insert the data,
Code Snippet |
DECLARE @VenkatTableVar table ( RowGUID uniqueidentifier PRIMARY KEY,VenkatName sysname,Name varchar(20)) INSERT INTO @VenkatTableVar1 VALUES (newid(),'Venkat','VenkatName') SELECT * FROM @VenkatTableVar |
Tried with manual data into the unique identifier column,
Code Snippet |
DECLARE @VenkatTableVar table ( RowGUID uniqueidentifier PRIMARY KEY,VenkatName sysname,Name varchar(20)) INSERT INTO @VenkatTableVar VALUES ( cast( 'A8FB1E48-F129-44RC-82AE-001EAD5A8ADE' AS binary ), 'Venkat','VenkatName') SELECT * FROM @VenkatTableVar |
No comments:
Post a Comment