http://www.microsoft.com has a pretty complete list of feature differences. You might start there.

Yes, there are disadvantages to using Select to assign values, if you use it incorrectly.

On the other hand, if I limited myself to things that can only, ever be used...

Since table variables are also created in tempdb, and follow the same rules on using memory, their only speed advantage is that they don't write to the transaction log. ...

You can, but there's no reason to do so.

If you have a Numbers/Tally table, this will do that kind of thing:

select substring(@String + ',', Number, charindex(',', @String + ',', Number) - Number)

from dbo.Numbers

where Number <= len(@String)...

Try this, see if it does what you need:

set nocount on;

if object_id(N'tempdb..#famille') is not null

drop table #famille;

if object_id(N'tempdb..#sousFamille') is not null

drop table #sousFamille;

--

create table #famille (

familleID int primary key,

famille varchar(100));

--

create...

Was probably/possibly overkill. Nothing wrong with mentioning what you can't do yet, but the only reason to bring it up again is if they start talking about it and...

joseph s (5/7/2009)

---

Thanks GSquared, for your explanation. The word normalization would make more sense rather than column partitioning simply put.

A rather new guy to sql programming would go all around...

No idea what would cause that in that case.

I don't have a copy of Access available right now, but from what I remember (I used to do a lot of this two years ago), what you do is...

Someone...

WoW reminds me more and more of...

Yeah. Haven't you noticed?

I just tried a couple of different ways to get that same data, and that one performs as well as any of the others I could come up with. ...

RBarryYoung (5/6/2009)

---

Grant Fritchey (5/6/2009)

---

I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly...