Look up BACKUP and RESTORE in BOL. It is described pretty well, and it should be what you need.

LOL... are you sure that JOIN is female? Maybe it would be a father 🙂

The only thing I can add is, that in my experience the first way - with LEFT JOIN - is better in most situations (not always).

So, regarding your original question,...

Maybe still answering questions from interview?

like here...

Maybe you are experiencing the bug that was described here?

confused about a user-defined function in group by

Micorosoft Knowledge base

Because you rarely need to view such long strings whole, the default setting of QA is to display 256 characters.

You can change this in Tools>Options>Results>Maximum characters per column.

That depends on many things, and it also depends on whom you ask :-). There are people who consider NULL values as a flaw in SQL and are of...

OK, thanks, I think it's clear now. This is pretty ugly format of flat file you have to create, I hate it when the lines are either head or detail...

What I really don't understand is why the date keeps changing on one invoice. Our invoices always have one date (well, actually there is date of issue, due date etc.,...

da,

I'm not sure whether this is only a matter of language, but if you have problems defining the requirements in English, you can try it in German (at least I...

Well, as I understand it, "a" and "b" are either variables passed to the code when you run it, or some fixed values hardcoded into the query. Unfortunately, in the...

If you are running this in QA, go to Tools>Options>Results and set Maximum characters per column.

Hi,

it would be a lot easier to find problems if you post the structure of all objects (here: table "Data") and a few rows of sample data.

So far, I've only...

I agree with Aaron. Correct solution is to make sure, that the row does not exceed the limit. How, that depends on what are you doing with this table and...

OK, thanks, seems I understood it correctly. I did some more testing now and the query I posted works for all possibilities mentioned in your post - you just have...