-
as seen on Stack Overflow
- Search for 'Stack Overflow'
hey all,
i have a table which has a primary key (UserID) this is of type UniqueIdentifier.
im trying to insert a value into this field but i keep getting an error.
i want to get the userID of the current user and insert the into the user_Details table, but i keep getting this error
Conversion…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am trying to cast an AuctionId that is a UNIQUEIDENTIFIER to an varchar(36) and then back to an UNIQUEIDENTIFIER. Please help me.
CAST((SUBSTRING(CAST([AuctionId] as VARCHAR(36)), 0, 35) + '1') AS UNIQUEIDENTIFIER)
But I keep getting this error:
Msg 8169, Level 16, State 2, Line 647
Conversion…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi! I need to change the type of my primary key column on a table from int to guid. The database already has data that I don't want to lose, and there are foreign keys to consider. Is there a painless way to do this or do I have to manually do it through a big a** script?:) I would appreciate any…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
In C# code I have a variable Guid? name.But,how to initialize this parameter to null,since I cannot assign null for a guid type
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a parent table and child table where the columns that join them together are the UNIQUEIDENTIFIER type.
The child table has a clustered index on the column that joins it to the parent table (its PK, which is also clustered).
I have created a copy of both of these tables but changed the relationship…
>>> More