|
|
|
DailyCoding > Database
|
Generate New Guid (uniqueidentifier) in SQL Server
|
| About how to generate a random unique identifier in using sql query in SQL server |
|
Author
admin on
Jun 19, 2008 |
8 Comments
|
| Rate it |
|
(Rated
4
by
12
people)
|
 |
Loading.. |
|
13,133 Views
|
|
|
If you want to generate a new Guid (uniqueidentifier) in SQL server the you can simply use the NEWID() function.
Example
SELECT NEWID()
GO
-- This will return a new random uniqueidentifier e.g.
E75B92A3-3299-4407-A913-C5CA196B3CAB
You can directly use this with INSERT statement to insert new row in table.
-- Inserting data in Employees table.
INSERT INTO Employees
(EmployeeID, Name, Phone)
VALUES
(NEWID(), 'John Kris', '99-99999')
|
|
Data
|
SQL
|
|
|
|
|
Leave a Comment
|
 |
Loading.. |
|
|
|
|
|