GUID Oracle ve MSSQL

by nurgun 24. August 2009 23:36

DB Sunuculardan GUID değeri almak için alttaki selectleri kullanabilirsiniz

Oracle

 

select sys_guid() from dual

alan tipi RAW(32)


(istek üzere yeni ekledim :)

.NET formatına uyarlamak için

 

select regexp_replace(lower(sys_guid()),'(.{8})(.{4})(.{4})(.{4})(.{12})','\1-\2-\3-\4-\5') from dual


 

MSSQL

select newid()

alan tipi uniqueidentifier

 


 

Tags: , , , , ,

MS SQL | Oracle

Comments

8/25/2009 9:44:31 AM #

Mehmet Uzun

Ciao,  
Questo articolo è molto utile, grazie

Mehmet Uzun Italy | Reply

4/12/2010 7:28:05 AM #

card games

I truly loved this excellent article. Be sure to keep it up. Greets!  !

card games United States | Reply

4/22/2010 8:09:51 PM #

hepa air cleaners

Im impressed.  I dont think Ive met anyone who knows as much about this subject as you do.  Youre truly well informed and very intelligent.  You wrote something that people could understand and made the subject intriguing for everyone.  Really, great blog youve got here.

hepa air cleaners United States | Reply

4/25/2010 11:31:26 AM #

fitted bedroom supplies

Have you ever thought about adding a little bit more than just your thoughts?  I mean, what you say is important and everything.  But its got no punch, no pop!  Maybe if you added a pic or two, a video?  You could have such a more powerful blog if you let people SEE what youre talking about instead of just reading it.

fitted bedroom supplies United States | Reply

4/27/2010 11:47:09 PM #

Rapidshare

I\'m happy I found this blog, I couldnt discover any info on this subject matter prior to. I also run a site and if you want to ever serious in a little bit of guest writing for me if possible feel free to let me know, i\'m always look for people to check out my site. Please stop by and leave a comment sometime!

Rapidshare United States | Reply

4/28/2010 1:40:00 AM #

Dating Forum

Thank you for this blog.  Thats all I can say.  You most definitely have made this blog into something thats eye opening and important.  You clearly know so much about the subject, youve covered so many bases.  Great stuff from this part of the internet.  Again, thank you for this blog.

Dating Forum United States | Reply

4/29/2010 12:52:15 PM #

free online game

Such a delightful article.. Thnx for spreading this information!

free online game United States | Reply

5/28/2010 7:32:34 PM #

metal fencing london

You...are...my...hero!!!  I cant believe something like this exists on the internet!  Its so true, so honest, and more than that you dont sound like an idiot!  Finally, someone who knows how to talk about a subject without sounding like a kid who didnt get that bike he wanted for Christmas.

metal fencing london United States | Reply

5/29/2010 11:46:25 PM #

Shelf Corporations

I hope you never stop!  This is one of the best blogs Ive ever read.  Youve got some mad skill here, man.  I just hope that you dont lose your style because youre definitely one of the coolest bloggers out there.  Please keep it up because the internet needs someone like you spreading the word.

Shelf Corporations United States | Reply

5/30/2010 6:51:19 AM #

P90X DVDs

I dont know what to say.  This is definitely one of the better blogs Ive read.  Youre so insightful, have so much real stuff to bring to the table.  I hope that more people read this and get what I got from it:  chills.  Great job and great blog.  I cant wait to read more, keep em comin!

P90X DVDs United States | Reply

6/1/2010 10:32:57 PM #

50cc motorbike

It's an interesting point you've raised and one that I'd not necessarily considered. I'lm sure I'll be wiser in the knowledge though.

50cc motorbike United Kingdom | Reply

6/2/2010 11:03:09 PM #

get traffic to website

Hi,thanks for the great quality of your blog, each time i come here, i m amazed.

get traffic to website Germany | Reply

6/3/2010 12:15:14 AM #

Kaitie | Custom Computers

This is very interesting. Keep blogging the way you do Smile

Kaitie | Custom Computers United States | Reply

6/3/2010 1:31:10 AM #

koi fish

One of the great factors about blogs is the facility to let all of us to share our thoughts on the world wide web. Thanks for sharing yours.

koi fish United States | Reply

6/3/2010 1:59:35 AM #

 outdoor sisal rugs

I am not much of a guy who thinks in so deeply about web design but I think your post had some valid points in it. Like designers are forced to design stuff within the limited code available and not go beyond it, their innovation is somewhat limited but still I think Web Design won't die! I agree that Amazon and other some big sites won't have a blog but now a days it's very important to have some sort of option available so people can quickly communicate their thoughts. I think Amazon if wants to shift it to that, they can get a customized CMS for themselves.

outdoor sisal rugs United States | Reply

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading



Nurgün Özgür

Facebook

 

Nurgün Özgür Photo

1993'ten bu yana profesyonel olarak yazılım ve sistem yönetimi konularında çeşitli yerli ve yabanci kuruluşların farklı kademelerinde aktif olarak yer aldım. 2011 yılında emekliliğe ayrıldım.

 

Valid XHTML 1.0 Transitional


Tag cloud


Facebook ile giriş