Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on Inserting value into unique Identifier within the SQL Server forums, part of the Databases category; How can i insert value in a column of a table which has data type as unique Identifier...
|
|||||||
| SQL Server SQL Server is a Database Management System(DBMS) by Microsoft |
![]() |
| LinkBack | Thread Tools | Display Modes |
|
|||
|
Re: Inserting value into unique Identifier
use NEWID() function as default, while creating the table with unique Identifier
eg. col_name UNIQUEIDENTIFIER DEFAULT NEWID() |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| ORA-12154: TNS:could not resolve the connect identifier | abhi_ratn | Data Warehousing | 1 | 02-11-2009 02:21 PM |
| Inserting value using FOR LOOP in PROCEDURE | talha_saeed | Oracle | 3 | 01-04-2008 03:16 AM |
| Inserting instead of updating | krishnaindia2007 | Oracle | 4 | 10-15-2007 08:38 AM |
| Error while inserting or updating | Geek_Guest | SQL | 1 | 09-09-2007 11:28 AM |
| Retrieve value set through an Ordinal Identifier | Geek_Guest | QTP | 0 | 07-03-2007 09:05 AM |