Uniqueidentifier.

• kev43barrie

  Right there with Babe

  Points: 756

  More actions

  November 23, 2011 at 10:49 am

  #390937

  I have a variable of type uniqueidentifier. I would to include this in a varchar. I have tried CAST(@Var, NVARCHAR(50)) and CONVERT. But when I try to print the varchar it is empty. Any ideas?

  SET @RulesName = 'Site: 1, RoleType: 2, Role: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx';

  SET @RulesName = REPLACE(@RulesName, '1', @SiteName_Id);

  SET @RulesName = REPLACE(@RulesName, '2', @RoleType_Id);

  SET @RulesName = REPLACE(@RulesName, 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx', CONVERT(NVARCHAR(50),@Var));

  Thanks

  Kevin.

• viiki.seth

  Ten Centuries

  Points: 1127

  More actions

  November 23, 2011 at 10:58 am

  #1412370

  Try with using Navarchar(MAX)

• Lowell

  SSC Guru

  Points: 323518

  More actions

  November 23, 2011 at 11:05 am

  #1412373

  not sure where your issue likes, i'm able to convert to a varchar(40) no problem:

  create table Example(id int identity(1,1) not null primary key,myUQ uniqueidentifier)

  GO

  insert into Example (myUQ) VALUES (newid())

  GO 10 --insert tthe above 10 times!

  SELECT id, myUQ,convert(varchar(40),myUQ) FROM Example

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 23, 2011 at 11:11 am

  #1412376

  You don't need an NVarchar for uniqueidentifier, it contains the characters A-F, 0-9 and - and is 36 characters long.

  Try this:

  SET @RulesName = 'Site: 1, RoleType: 2, Role: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx';

  SET @RulesName = REPLACE(@RulesName, '1', @SiteName_Id);

  SET @RulesName = REPLACE(@RulesName, '2', @RoleType_Id);

  SET @RulesName = REPLACE(@RulesName, 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx', CAST(@Var AS VARCHAR(36));

  SELECT @RulesName

  If that doesn't work, please post the values that @SiteName_Id, @RoleType_Id and @Var have at the beginning of that code block so I can test it. This is very likely a case of propagation of nulls. Check the values of @SiteName_Id, @RoleType_Id and @Var before that code block.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• RowanCollum

  SSC Veteran

  Points: 224

  More actions

  November 23, 2011 at 6:51 pm

  #1412529

  As a quick proof of concept, you could start with something like...

  select cast(newid() as sysname)

  -- OR --

  print cast(newid() as sysname)

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  November 23, 2011 at 7:31 pm

  #1412531

  kev43barrie (11/23/2011)

  ---

  I have a variable of type uniqueidentifier. I would to include this in a varchar. I have tried CAST(@Var, NVARCHAR(50)) and CONVERT. But when I try to print the varchar it is empty. Any ideas?

  It probably sounds like a stupid question but did you populate the variable with anything?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)