C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Generate GUID (Unique Identifier) in SQL Server

Posted Date: 03 May 2007 Resource Type: Code Snippets Category: SQL

Posted By: Balamurali Balaji Member Level: Diamond
Rating:

Points: 10

The following TSQL statement block creates a new Global Uniform Identifier(GUID). Most of your primary key columns can be of uniqueidentifier datatype and you can use it during insert of rows in your T-SQL block or stored procedure

Note: GUID is a 32 byte alpha-numeric string representation and its value depends on the system.


								
declare @guid uniqueidentifier
set @guid= NEWID()
print 'Value of @guidis: '+ CONVERT(varchar(255), @guid)

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to find out recently run queries in SQL Server 2005?
	Previous Resource: Find tables used in a stored procedure
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

audio conferencing services