Ah, that is good to...

100 is the number of characters you can store, not the size in bytes.

Since you are using a unicode column (datatype preceded by n), you are using twice as much...

Is it possible to give some sample data and desired output?

For starters, check out the datetimeoffset datatype:

http://msdn.microsoft.com/en-us/library/bb630289.aspx

ps: I think most people here want help asap. No need to point out...

Buh, got it wrong. But that's because I refuse to learn XQuery 😀

GSquared (1/26/2012)

---

It's not an IMEX issue. Those cause NULLs instead of text/numeric data, depending on which one it thinks the column is based on a 4-row sample. They...

I don't think that is correct syntax.

Store the two statements in variables. Then execute the statement in the IF construct with the EXEC statement or with sp_executesql.

edit: sorry, I wasn't...

In the connection string, add IMEX=1 at the end. http://www.connectionstrings.com/excel

Set the registry setting of TypeGuessRows to 0 for the JET provider. http://support.microsoft.com/kb/281517

This way, the JET provider will scan the entire...

Why are you trying to change the sa password if you have Windows Authentication?

The sa login is used with SQL Server Authentication.

I thought such a basic question, which has appeared numerous times in the QotD, would have been easier, but apparently more than 50% - at the moment - still got...

That would be surprising, as uncommitted transactions are rolled back when the session is terminated.

Has the behaviour from your...

If you kill the session, the transaction will be rolled back, as stated explicitly in the link that...

You can kill the client session:

http://msdn.microsoft.com/en-us/library/ms173730.aspx

Phil Parkin (1/26/2012)

---

Or...

One small question, just to be sure:

were the two inputs for the MERGE JOIN sorted?

Put a For Each Loop and loop over the object variable. Put the plan code value into a variable and use this variable in an expression to set your flat...