How to generate and manually insert a uniqueidentifier in sql server

Question

I m trying to manually create a new user in my table but impossible to generate a  UniqueIdentifier  type without threw an exception      Here is my example   DECLARE  id uniqueidentifier SET  id   NEWID    INSERT INTO  dbo   aspnet Users               ApplicationId               UserId               UserName               LoweredUserName               LastName               FirstName               IsAnonymous               LastActivityDate               Culture        VALUES              ARMS               id              Admin               admin               lastname               firstname              0              2013-01-01 00 00 00               en   GO   Trow exception -   Msg 8169  Level 16  State 2  Line 4 Failed to convert a character string to uniqueidentifier   I use the NEWID   method but it s not work      http   www dailycoding com Posts generate new guid uniqueidentifier in sql server aspx

User · Answer

Kindly check Column ApplicationId datatype in Table aspnet_Users , ApplicationId column datatype should be uniqueidentifier .

*Your parameter order is passed wrongly , Parameter @id should be passed as first argument, but in your script it is placed in second argument..*

So error is raised..

Please refere sample script:

DECLARE @id uniqueidentifier
SET @id = NEWID()
Create Table #temp1(AppId uniqueidentifier)

insert into #temp1 values(@id)

Select * from #temp1

Drop Table #temp1

User · Answer

ApplicationId must be of type UniqueIdentifier   Your code works fine if you do   DECLARE  TTEST TABLE     TEST UNIQUEIDENTIFIER    DECLARE  UNIQUEX UNIQUEIDENTIFIER SET  UNIQUEX   NEWID     INSERT INTO  TTEST  TEST  VALUES   UNIQUEX    SELECT   FROM  TTEST   Therefore I would say it is safe to assume that ApplicationId is not the correct data type

[sql] How to generate and manually insert a uniqueidentifier in sql server?

Examples related to sql

Examples related to sql-server

Examples related to database

Examples related to tsql

Examples related to uniqueidentifier