Select the search type
 
  • Site
  • Web
Search
You are here:   Home
Register   |  Login

RSS Subscribe

Minimize

Blog Calendar

Minimize

Technology Links

Minimize

Bookmark

Minimize

Captured Technology - Blog

Minimize

Inserting a Unique Identifier (GUID) into a SQL Field

Dec 30

Written by:
12/30/2008 11:15 AM  RssIcon

If you have a database which contains GUIDs as a column of a table, then inserting the unique identifier into the needed column is not always straight forward. I found that converting the needed value into a unique identifier makes adding it to the database error free.

INSERT INTO SOMETABLE(GUID_1)
SELECT CAST('B14BC077-F1DF-457C-9F7E-7CB9E0BC1CF3' AS UNIQUEIDENTIFIER)

Trackback Print
Tags:
Categories:
Location: Blogs Parent Separator CapturedTech - Technology

Your name:
Gravatar Preview
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
CAPTCHA image
Enter the code shown above in the box below
Add Comment   Cancel 

Blog Directory

Minimize

FaceBook

Minimize

Mobile Version

Minimize
Add CapturedTech - Technology Mippin widget

Translate

Minimize

Sponsors

Minimize

Categories

Minimize

Recent Comments

Minimize
Re: Three Benefits to Using a Royalty-Free Image on Your Website or Blog
I also prefer to use royalty-free images. They give more credibility in your site or blog posts.
By Internet Video Production on: Friday, February 10, 2012
Re: Websites vs. Facebook Pages (Infographic)
Internet can be very useful for small business to market them self, there is always some free way to reach your audience via Internet.
By leadership training uae on: Friday, February 10, 2012
Re: Is Keyword Density Still Important For On Page SEO
The search engines hadn’t quite caught up yet. As a result, it wasn’t uncommon to see sites rank highly when their content read something like this.that they follow SEO best practices than you will by trying to figure out a way to get your keywords into your page content another one or two times.
By Søgemaskineoptimering on: Thursday, February 09, 2012
Re: Websites vs. Facebook Pages (Infographic)
Very interesting topic, infographics was a new concept for me, will definitely use it.
By Phone service on: Thursday, February 09, 2012
Re: Reducing Small Business Blues
Running a business is tough and you are right, most of the time you are the core aspect of each area of a business. I don't think I could handle doing my own accounting, like you I am too terrible with numbers!
By Peter Jones on: Wednesday, February 08, 2012

u comment, i follow

Home   |   Discussion Groups   |   Calendar   |   Chat