Viewing 15 posts - 196 through 210 (of 219 total)
Jeff Moden (12/21/2009)
...
SELECT REPLACE((SELECT CHAR(SUBSTRING('.'+p2.Cypher,N+1,CHARINDEX('.',p2.Cypher+'.',N)-N)+64)
FROM dbo.Tally t
...
Msg 208, Level 16, State...
December 22, 2009 at 12:32 am
Toreador (12/18/2009)
No-one seems to want to comment about my earlier reply though, maybe I'm the only one who found the behaviour interesting :crying:
I shall try to comment, this seems to...
December 18, 2009 at 3:43 am
sknox (12/17/2009)
I think that's a question of terminology. I consider an open session an active task.
Ok, let's see BOL about active tasks 🙂
What is a task? http://msdn.microsoft.com/en-us/library/ms189267.aspx
A task represents a...
December 18, 2009 at 12:19 am
Dude76 (12/17/2009)
When all active tasks have stopped referencing them : true : almost the word by word the definition given by msdn 🙂
Consider an example.
1) A global temporary table is...
December 17, 2009 at 8:57 am
It would be much better if the options #2 and #3 where not separated from each other. Neither #2 nor #3 in itself does not trigger SQL Server to drop...
December 17, 2009 at 7:37 am
Explanation
When precision is not specified with the decimal type, TSQL will use whatever precision would use the minimum space to store with the number it is converting to.
This is not...
December 16, 2009 at 5:04 am
Richard Gibbins (12/14/2009)
declare @txt varchar(255)
set @txt = 'Question'
insert xxx values ('')
select @txt = isnull (a, '?') from xxx order...
December 14, 2009 at 1:53 pm
Hugo Kornelis (12/12/2009)
...
My guess is that on SQL Server 2000, the engine assumes a zero length...
December 14, 2009 at 7:42 am
Christian Buettner-167247 (12/14/2009)
Same code as before, but positioned order by (1 instead of i)
select @txt = @txt + '-' + a from #xxx order by 1
Not the same code. Your...
December 14, 2009 at 3:30 am
Carlo Romagnano (12/14/2009)
That isn't true.Count() return 0
This is not true that "That isn't true" 🙂
"SELECT COUNT" statement from your example returns a zero as a result, so the result contains...
December 14, 2009 at 1:59 am
Hugo Kornelis
Thank you for explanation. Could you also explain why "under SQL Server 2000, the result is '1234' regardless of the number of NULLs appended"?
December 12, 2009 at 7:09 am
Terribly phrased options to choose.
A clustered index physically rearanges data on disk.
rearranges?
I think this option should look like this: "When created or rebuilded, a clustered index physically rearranges data on...
December 9, 2009 at 12:43 am
hakan.winther (12/8/2009)
vk-kirov (12/8/2009)
mohd.nizamuddin (12/8/2009)
However, in the example the functions Count(*), SUM, MAX, MIN etc are not a deterministic function.This is incorrect.
All of the aggregate and string built-in functions are deterministic.
Count...
December 8, 2009 at 6:38 am
mohd.nizamuddin (12/8/2009)
However, in the example the functions Count(*), SUM, MAX, MIN etc are not a deterministic function.
This is incorrect. Check BOL (Deterministic and Nondeterministic Functions): http://msdn.microsoft.com/en-us/library/ms178091.aspx
All of the aggregate and...
December 8, 2009 at 2:31 am
stewartc-708166 (12/3/2009)
the explanation re why the rounding off takes place is.....?
Something about this can be found in BOL, topic "Precision, Scale, and Length (Transact-SQL)": http://technet.microsoft.com/en-us/library/ms190476.aspx
We have two numbers of type...
December 4, 2009 at 1:28 am
Viewing 15 posts - 196 through 210 (of 219 total)