It *might* be correct and safe if the appropriate uniqueness guarantees exist. In the sample you provided, there is no unique index, constraint, or primary key.

A safer way to...

Ok, so still no sample data (or a source table definition). No matter, I will try to answer as best I can given the information provided.

The easiest way to...

How about making it clear exactly what you want to see?

Some sample data and expected output would probably make this a lot easier...

Sure can:

http://www.sqlservercentral.com/Forums/Topic896583-338-1.aspx

Use SQLNCHAR instead of SQLCHAR in the format file.

As always, "it depends" 😀

BrainDonor (6/1/2010)

---

I suspect that is true, but personally I hate to just 'skip over' something that...

There are many ways to import such a file into SQL Server directly.

If you must use an external C# program for some reason, there are plenty of code examples out...

Assuming your import file contains explicit IDENTITY column values, you must add the KEEPIDENTITY option to your BULK INSERT statement for the import process to use them.

Steve Jones - Editor (6/1/2010)

---

I think you're right, but I'm not sure the exam delves this far down. From what I remember, execution plan is pretty much used for the...

Steve Jones - Editor (6/1/2010)

---

So in summary

Execution Plan = Query Plan + Execution Context

Context is used specific information in terms of parameters and other data structures that could change for...

PaulB-The-One-And-Only seems to know his Oracle stuff, and seems to monitor the Oracle forum(s) quite regularly.

Good to hear. Thanks.

I think it's just better laid-out 🙂

My guess would be that Lowell presented it as clearly as possible...

I looked at this question earlier - but you have made it hard for people to help you - so I chose to move on to other questions.

For advice on...