Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 import data

Author  Topic 

knight
Starting Member

13 Posts

Posted - 2004-12-13 : 14:08:56
Hi,
I try to import data from excel spread sheet into the sql server db but first I have to create or insert GUID newid in the table. Is there an easy way to import data and GUID create like autonumber?

Thank,
Knight

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-12-13 : 14:48:33
Set NEWID() as default value for the uniqueidentifier column

rockmoose
Go to Top of Page

knight
Starting Member

13 Posts

Posted - 2004-12-13 : 15:24:23
I did that too but still unable to import data unless I create new GUID.

knight
Go to Top of Page
   

- Advertisement -