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