January 15, 2018 at 12:56 am
What is the best data type to declare a GUID as in Stored Proc?
January 15, 2018 at 1:35 am
Super Cat - Monday, January 15, 2018 12:56 AMWhat is the best data type to declare a GUID as in Stored Proc?
The SQL equivalent of a GUID is UNIQUEIDENTIFIER
January 15, 2018 at 2:11 am
of couse the best way is to avoid it !
GUIDs have their place in the db world, but there are a number of better options when just picking them as an easy way to generate a random identifier.
( MustRead: https://www.sqlskills.com/blogs/kimberly/guids-as-primary-keys-andor-the-clustering-key/ )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 15, 2018 at 3:00 am
ALZDBA - Monday, January 15, 2018 2:11 AMof couse the best way is to avoid it !
GUIDs have their place in the db world, but there are a number of better options when just picking them as an easy way to generate a random identifier.
( MustRead: https://www.sqlskills.com/blogs/kimberly/guids-as-primary-keys-andor-the-clustering-key/ )
3rd Party VENDOR db design. Thanks for the reply.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy