Search  Search  

GUID formats and length.
  More SQL server database ... on Twitter on YouTube on flickr on Pinterest on Facebook on Google+ on Tumblr on LinkedIn

Free wallpapers of the hottest girls of the 2014 Winter Olympics

Complete guide for Euro 2012’, about 300 hundred pages filled with comprehensive information about Euro 2012

Euro 12 - teams, managers, players, fixtures, referees, the brand new ‘Tango 12’ Adidas ball and much, much more. Few hundreds amazing photos.

E-books, free e-books, Euro 2012 e-books

Auckland events in photos at

1 500 photos of fun-run 'Ports of Auckland Round the Bays 2012' at

Ocean swim - more than 1 500 photos of State King of the Bays Forums forums Forums - articles, news, links Forums - articles, news, links 

Photos of State King of the Bays event at

‘Complete guide for Euro 2012’: Given profile all 368 footballers with their photos.

‘Complete guide for Euro 2012’: Read about star players of each squad. Find out who is the key player of each team. What Pele expects of Euro 2012?

‘Complete guide for Euro 2012’: Compare annual salary of coaches participating in the Euro-2012 - and how it happened that the team of the most paid coach finished the last in their group?

‘Complete guide for Euro 2012’: Euro 2012 footballers: who are the most expensive players? Who are the Rising stars at Euro 2012?

E-books, free e-books, Euro 2012 e-books
 Rating: 3.8      Rate this article   28 
 13 Apr 2012

GUID formats and length.


Sometimes you want to create a random unique string. So you can use GUID. It is simple, fast and easy.

A GUID is a 128-bit integer (16 bytes) that can be used across all computers and networks wherever a unique identifier is required. Such an identifier has a very low probability of being duplicated.

Guid.NewGuid has no implicit "string length"; It all depends on the format used in the ToString (The no-argument ToString uses "D" formatting).

It depends on how you format the Guid:

Guid.NewGuid().ToString() => 36 characters (Hyphenated)
outputs: 12345678-1234-1234-1234-123456789abc

Guid.NewGuid().ToString("D") => 36 characters (Hyphenated, same as ToString())
outputs: 12345678-1234-1234-1234-123456789abc

Guid.NewGuid().ToString("N") => 32 characters (Digits only)
outputs: 12345678123412341234123456789abc

Guid.NewGuid().ToString("B") => 38 characters (Braces)
outputs: {12345678-1234-1234-1234-123456789abc}

Guid.NewGuid().ToString("P") => 38 characters (Parentheses)
outputs: (12345678-1234-1234-1234-123456789abc)

More similar topics with SQL tips:

Sparse Columns in SQL Server 2008

Oracle database - How to select several random records from a table

Database DB2 - How to select several random records from a table

MySQL database - How to select several random records from a table

PostgreSQL - How to select several random records from a table

Microsoft SQL Server - How to select several random records from a table

  More similar links:

Microsoft SQL Server - How to select several random records from a table.

Microsoft SQL Server 2008 – The latest version.

MS SQL server – connections and Connection Pooling

Microsoft SQL Server: the Difference between SSRS, SSIS and SSAS explained.


Database DB2 - How to select several random records from a table.

SQL Server 2008 R2

Microsoft SQL Server – General Info.

 Rate this article from 1 to 5 


11.07.2012    Arfat

Good question. OnUpdate is caelld after you call UpdateDatabase but before data is sent to the database. Same for OnDelete.New objects that are deleted before they are saved at least once will NOT get a OnDelete or OnUpdate since they never got tha

        Add comment
Your name:
Your comment:
 Tags: SoftFern Tutorials, SoftFern Programming Tutorials, random unique string, GUID, GUID is a 128-bit integer, Guid.NewGuid
   More SQL server database ...

  Home page Weird We sell Programming Windows
  News Our Photos Photoshop and Photography SQL server Microsoft Office
  Tech News Our Portfolio iPad Misc Web sites development
  Videos Archive Androids Graphic design Software development
  Auckland and New Zealand About Us Tablet PCs CD/DVD presentation Play games online
  Football Contact us Round the Bays 2012 photos Ocean Swim 2012 photos Auckland Events
  Sport Our Portfolio Stock Images Stock Photos Links Exchange
  Hot Girls Our clients On Twitter Add link Site Map
  Our Twitters’ gadget Site Map Google+ Site Grid
  Health and Beauty Site Grid Pinterest Natalia Soft Fern forums
  Misc News Web pages Facebook Photos, images Hair & Beauty
  On YouTube CD/DVD presentaton Tumblr Daily Motion Flickr
  YouTube - 2 Graphics LinkedIn Live Journal Stumble Upon
  Vimeo - videos Tutorials - Videos Tutorials - Weird Most Popular on Internet Yahts, boats, Tall Ships

SoftFern (New Zealand LTD). 
Design and development by SoftFern 2003 - 2014 Graphics supplied by