Viewing 15 posts - 9,571 through 9,585 (of 14,953 total)
http://www.microsoft.com has a pretty complete list of feature differences. You might start there.
May 7, 2009 at 12:06 pm
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...
May 7, 2009 at 12:03 pm
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. ...
May 7, 2009 at 11:53 am
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)...
May 7, 2009 at 9:12 am
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...
May 7, 2009 at 7:39 am
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...
May 7, 2009 at 7:11 am
joseph s (5/7/2009)
A rather new guy to sql programming would go all around...
May 7, 2009 at 7:06 am
No idea what would cause that in that case.
May 7, 2009 at 6:57 am
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...
May 7, 2009 at 6:55 am
Ratheesh.K.Nair (5/7/2009)
Hi Experts,What is Lazy writer ?
What are ACID PROPERTIES?Please Explain..
What happens when we issue a checkpoint? and wat all things triggers a checkpoint?
What happens when we start sql server?
TIA
Someone...
May 7, 2009 at 6:50 am
Jeremy Brown (5/6/2009)
Shifting the subject a bit. After the latest patch from Blizzard, I still think Death Knights are way OP. Discuss.
WoW reminds me more and more of...
May 7, 2009 at 6:40 am
Bob Hovious (5/6/2009)
...and GSquared is invisible ???
Yeah. Haven't you noticed?
May 6, 2009 at 2:35 pm
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. ...
May 6, 2009 at 2:34 pm
RBarryYoung (5/6/2009)
Grant Fritchey (5/6/2009)
Lynn Pettis (5/6/2009)
sorry, crushed you will be.
I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly...
May 6, 2009 at 2:12 pm
Viewing 15 posts - 9,571 through 9,585 (of 14,953 total)