tag:blogger.com,1999:blog-3016850660716023308.post2732869439533970451..comments2023-05-14T06:52:46.591-04:00Comments on Jess Chadwick: Coder: Safe Handling of Uniqueidentifier Using T-SQLJess Chadwickhttp://www.blogger.com/profile/06496564636137348761noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-3016850660716023308.post-75586635211037784002012-08-25T17:58:23.699-04:002012-08-25T17:58:23.699-04:00Your IsValidGuid function is awesome. It just reso...Your IsValidGuid function is awesome. It just resolved for me a major data integrity issue for my team that we were running into loading data from one system to another.<br /><br />Thank you.Anonymoushttps://www.blogger.com/profile/16570634814917578357noreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-14957240282058622682011-06-27T16:10:33.749-04:002011-06-27T16:10:33.749-04:00Thanks!Thanks!John Skrotzki ( Partner: Source Recreation )https://www.blogger.com/profile/18125449228012516943noreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-4606071020553836102011-02-16T13:52:09.664-05:002011-02-16T13:52:09.664-05:00Man this saved me a lot of work. Thanks so much!Man this saved me a lot of work. Thanks so much!Robhttps://www.blogger.com/profile/08710365290847562635noreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-6778773253028531942010-09-30T13:57:20.204-04:002010-09-30T13:57:20.204-04:00Thanks for the code. This is very helpful. And sav...Thanks for the code. This is very helpful. And saved me at least a few hours of coding.Edge-L1-khttps://www.blogger.com/profile/04119279213366962824noreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-44874725733318971402009-07-16T11:01:57.584-04:002009-07-16T11:01:57.584-04:00nicely done ^_^nicely done ^_^risskyhttps://www.blogger.com/profile/01362110696653312139noreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-68961295132167082232009-04-07T10:46:00.000-04:002009-04-07T10:46:00.000-04:00Anonymous,Oh yeah - I've been getting into more Sh...Anonymous,<BR/>Oh yeah - I've been getting into more Sharepoint development lately and I can definitely say I've used this for my Sharepoint stuff more than a couple of times. :)Jess Chadwickhttps://www.blogger.com/profile/06496564636137348761noreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-14081227410420809112009-04-07T04:29:00.000-04:002009-04-07T04:29:00.000-04:00What can I say! You probably saved my professional...What can I say! You probably saved my professional life with this code! Sharepoint relies on unique identifiers.<BR/>just remember the curlie braces<BR/>string sId = "{AB9479D2-935B-4F65-9EEC-441713B4BF1E}" is something othere than "'AB9479D2-935B-4F65-9EEC-441713B4BF1E'"Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-7290171059725911722009-02-10T22:43:00.000-05:002009-02-10T22:43:00.000-05:00Great work man.Great work man.shaymaxhttps://www.blogger.com/profile/04039436090515329910noreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-69512114965835964302008-12-30T07:39:00.000-05:002008-12-30T07:39:00.000-05:00Thanks for the functions! I just ran into the need...Thanks for the functions! I just ran into the need to validate a uniqueidentifier.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-52485972963602778232008-12-22T14:54:00.000-05:002008-12-22T14:54:00.000-05:00Thanks for your comment, EN. I love to hear when ...Thanks for your comment, EN. I love to hear when my posts are helping someone!Jess Chadwickhttps://www.blogger.com/profile/06496564636137348761noreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-48186913182102592032008-12-22T13:17:00.000-05:002008-12-22T13:17:00.000-05:00Incredible... A year later this post still invalua...Incredible... A year later this post still invaluable. Outstanding!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-70110794703823147092007-11-05T15:16:00.000-05:002007-11-05T15:16:00.000-05:00I like how you decided to abbreviate assorted.I like how you decided to abbreviate assorted.Alex Palilonishttps://www.blogger.com/profile/02778772084525991970noreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-39343096353577336372007-11-02T14:28:00.000-04:002007-11-02T14:28:00.000-04:00Thanks for your comment, Sloan - I'm glad I could ...Thanks for your comment, Sloan - I'm glad I could help you out! Not having to recompile to make a production fix is always a good thing. :)Jess Chadwickhttps://www.blogger.com/profile/06496564636137348761noreply@blogger.comtag:blogger.com,1999:blog-3016850660716023308.post-72587540282855638072007-11-02T14:07:00.000-04:002007-11-02T14:07:00.000-04:00Thanks!To really fix my bug I need to take my Data...Thanks!<BR/><BR/>To really fix my bug I need to take my DataSet.MyTable.MyColumn....and make MyColumn a Guid (its a string now).<BR/>But you're code helped me put in a production time fix...without recompile.<BR/><BR/>I made the fix into 1 line (using your code of course).<BR/><BR/>select @myguid = <BR/> STUFF(STUFF(STUFF(STUFF(UPPER(LTRIM(RTRIM(REPLACE( @myVarChar , '-', '')))) , 9, 0, '-'), 14, 0, '-') , 19, 0, '-') , 24, 0, '-') <BR/><BR/>For a quick fix.<BR/><BR/>I appreciate the post.Harrisonhttps://www.blogger.com/profile/07498998030926750120noreply@blogger.com