Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

XL import issue

Posted on 2010-09-02
2
Medium Priority
?
284 Views
Last Modified: 2012-05-10
Hello Experts ,

I am doing a raw import of an XL file in to all nvarchar fields table. It works fine but I want to introduce a GUID column which takes the input from your program and adds it as a first column in the table.

right now I dont have any identity column or differentiation between who uploaded or deleted.

is there a way to do it using c#
0
Comment
Question by:SubbuUSA
2 Comments
 
LVL 21

Accepted Solution

by:
MogalManic earned 1000 total points
ID: 33595325
Here is a tutorial on GUID's:http://rhondatipton.net/2007/09/30/generating-a-guid-in-c/

Is that what you want to do?

Do you have a second question on identifying who inserted / updated data?
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 1000 total points
ID: 33598681
All you have to do is add a column with a data type of uniqueidentifier and give it a default value of NEWID()
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

High user turnover can cause old/redundant user data to consume valuable space. UserResourceCleanup was developed to address this by automatically deleting user folders when the user account is deleted.
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question