Don't use SELECT *.

.dup

.But starting statements with terminators teaches bad habits .For example I had a dev recently who scattered ; randomly until the SQL proc started working .Once it had been explained...

Since I still have no idea what you're trying to do, maybe.

See the edits of my earlier post!

GilaMonster (3/30/2015)

---

If that's an excel spreadsheet, you don't need and shouldn't be using a format file, you should be specifying the driver that you...

Ask yourself whether you could solve the problem with that little information....

I still have no idea what you're trying to do.

We're not sitting in your office, we can't see your screen, we don't know what you're trying to achieve unless you...

Huh?

If data has been deleted, it's gone. Or are you referring to a table which has an 'IsDeleted' column or similar.

Don't put stuff in the root of a drive, you're likely to get permission problems. Windows protects the root directory of all drives, C the most, but all others as...

You missed the exact same letter in both the statement and the error message, an error that stated that the format of the file name was wrong?

If that's an excel...

You've left out the drive letter in the path

Cannot bulk load because the file ":\Work\Development\SalesReportsFF.xml" could not be opened. Operating system error code 123(The filename, directory name, or volume label...

Read Jeff's post again

Jeff Moden (3/23/2015)

---

You can't use BULK INSERT to import .xlsx files. It can be done with OPENROWSET but you'll need the ACE Drivers to do that....

.This .It's a statement terminator .It has no place at the beginning of statements .I can't imagine...

I'd recommend restoring from a clean backup.

Since Sharepoint keeps the site structure as data, any repairs may leave the site unusable. Rather restore from a backup which was taken before...

It's not a migration. It's not a 'alter table set in-memory'. You create new tables which are in-memory and you copy the data from the old tables to the new...