You wanted four rows instead of three, right? Try this:

select typeId, trypename, typeInfoDesc

from types t left join typeinfo ti

on t.typeId = ti.typeInfoId

AND typeinfoId2 = @infoNr

In a case like this, use the tool above or, if you want to roll your own, SMO (SQL Management Objects) allows you generate SQL scripts by object or for...

But if you're using the GUI and you still need to change the schema, display the properties page from the table creation screen. You can change the schema there. Same...

It can be useful if you're returning a large amount of data and you don't want to wait for all the rows to process prior to the data returning. You...

If you're getting primary key violations, something else is up. You may also need to post the structure of the table you're inserting into.

Is that the complete procedure? Is there...

We use just 1204. I'm wondering though if we shouldn't switch it over to 1222. The XML output looks easier to read. Anyone using that?

Not stupid, you just needed a nudge.

I've been going around telling all & sundry that the bit data type wouldn't take a null. Then Gail just simply tells me I...

Instead of VARCHAR, if you use NVARCHAR, that might address the issue.

I love the missing index DMV's. They're not a panacea either, but they sure can help you spot something simple quickly.

Just to toss in a contrarian view point, I've never had DTA recommend a single index that was worth the trouble it took to run a series of scripts through...

If you're not already cycling your error log, you should.

Daily seems a bit high. We cycle ours once a week.

Boy. I don't know where I've been. I sure thought it was that way. Maybe I'm channeling some old bit of knowledge from a different system. Damn. I hate being...

You have to start from a concurrency model. It's either pessimistic or optimistic. You seem to be assuming an optimistic model, there are unlikely to be very many or any...

That's about as open ended a question as it's possible to ask.

Obviously, the Books Online would be a great place to start. I'd also suggest perusing Itzik Ben Gan's TSQL...

If it's possible, format the delimited list as XML and use XQuery to retreive it from there. We've started to find this a more optimal approach than the old one...