|
|
-
Bradley M. Small Commented 8 Months ago through Just Learned
You're welcome. I have to keep SQL2K as well as SQL2K8 db's going and continue development in both environments. Lots of times, great tips come along, that just flat out don't help much in SQL2K ... At least I don't have to keep SQL7 and 6.5 working any...
|
-
Bradley M. Small Commented 8 Months ago through Just Learned
You're welcome. I have to keep SQL2K as well as SQL2K8 db's going and continue development in both environments. Lots of times, great tips come along, that just flat out don't help much in SQL2K ... At least I don't have to keep SQL7 and 6.5 working any...
|
RKA
106
·
2% ·
430
|
|
-
Bradley M. Small Commented 8 Months ago through Blogs
I guess you could use them together:
SELECT CHOOSE(IFF(....),url1, url2)
As for the IIF, I guess that will make MS Access users happy. I am not sure it does anything much better than the CASE statement. Anything that is not ANSI, however, wil...
|
|
|
-
Bradley M. Small Commented 8 Months ago through Blogs
I guess you could use them together:
SELECT CHOOSE(IFF(....),url1, url2)
As for the IIF, I guess that will make MS Access users happy. I am not sure it does anything much better than the CASE statement. Anything that is not ANSI, however, wil...
|
-
Bradley M. Small Commented 8 Months ago through Just Learned
Of course, this does not work in SQL Server 2000.
declare @n int
set @n = 3
-- works in 2K8 - Fails in 2K
select top (@n) * from tally
-- works in 2K8 and 2K
set Rowcount @n
select * from tally
s...
|
-
Bradley M. Small Commented 8 Months ago through Just Learned
Of course, this does not work in SQL Server 2000.
declare @n int
set @n = 3
-- works in 2K8 - Fails in 2K
select top (@n) * from tally
-- works in 2K8 and 2K
set Rowcount @n
select * from tally
s...
|
|
RKA
106
·
2% ·
430
|
|
-
Bradley M. Small Commented 10 Months ago through Puzzles
I am pretty sure that the output is actually nvarbinary because I used "for xml explicit" certainly if you consume it in Query Analyzer/SQL Studio it will be converted to some kind of text in the results window, but it is not a true varchar or nvarchar per
|
-
Bradley M. Small Commented 10 Months ago through Puzzles
The output is to be consumed how? I don't believe it is a string per-se but it certainly is just one of whatever it is. I was under the impression that it would be something like an nvarbinary or some such thing.
What is the purpose of the quiz table f
|
-
Bradley M. Small Solved 10 Months ago through Puzzles
not sure how this rates, but it seems to work.
I was not sure the reason to have the quiz table, though there was a relationship, it does not seem to use used. So perhaps I did something wrong :)
|