Viewing 15 posts - 1,666 through 1,680 (of 3,348 total)
bsk1234 (7/9/2013)
July 9, 2013 at 6:04 am
Carlo Romagnano (7/9/2013)
select concat(null + 'Hello','testString') as a, null+'testString' as b
It simply returns 'testString', NULL
😀
Yup. If you wanted to get 'HellotestString', you'd use SELECT CONCAT(NULL,...
July 9, 2013 at 3:13 am
logitestus (7/8/2013)
July 9, 2013 at 3:08 am
L' Eomot Inversé (7/7/2013)
Christian Buettner-167247 (7/4/2013)
L' Eomot Inversé (7/3/2013)
[...]as in the first statement where both arguments of LIKE are required to have a string type[...]
Hi,
they are not required to...
July 8, 2013 at 1:50 am
Not a bad question, but the explanation is only partial. Here's a fuller explanation.
For varchar, trailing spaces are preserved, so the variable stores six letters plus two trailing spaces. For...
July 8, 2013 at 1:48 am
Iggy-SQL (7/2/2013)
Statement 1 : The SQL Database Engine converted the Val value to...
July 3, 2013 at 1:25 am
paul s-306273 (7/2/2013)
And 'sequel' is the correct pronunciation of SQL...
Small correction. For the product SQL Server, the correct pronouciation is "sequel server". In the (then still printed) product documentation of...
July 2, 2013 at 6:14 am
samtrenchard (7/1/2013)
I do not understand the explanation as the sub query only returns the departmentid, not the empid.
The explanation doesn't actually explain the question and answer. It only tells you...
July 1, 2013 at 7:12 am
Mighty (6/30/2013)
Probably Hugo can explain us why the maximum precision is 7 for 4 byte storage. 😀
Floating point numbers are stored in "exponential notation" - that is the only way...
July 1, 2013 at 1:25 am
There's probably a much deeper explanation than this, which I'm hoping will come to light in the discussion.
Not much depth needed. See http://msdn.microsoft.com/en-us/library/ms173773.aspx and check the number of bytes used...
June 30, 2013 at 4:38 am
ronmoses (6/28/2013)
It doesn't strike me as a particularly useful function, especially given these examples:
SOUNDEX and DIFFERENCE can be useful, but you have to know their specifications. Here is a link...
June 30, 2013 at 4:36 am
psingla (6/26/2013)
It works well when length is 24 or less instead of 53..Any idea???????
1. The "or less" is irrelevant. SQL Server only uses two types of float internally - 4...
June 27, 2013 at 1:35 am
PRR.DB (6/25/2013)
RESTORE FILELISTONLY FROM disk='D:\DB\Backup\TestPartition.bak'
It is showing only...
June 26, 2013 at 2:24 am
Christian Buettner-167247 (6/24/2013)
More important - if you use regular tables instead, the query works just fine.
Hmmm, that's a surprise to me! I thought you'd get the same problem when using...
June 24, 2013 at 2:47 am
Christian Buettner-167247 (6/24/2013)
Why was this question reposted with the same misleading explanation as the original QOTD a month ago?
If you are refering to the mistake in the last sentence (that...
June 24, 2013 at 1:59 am
Viewing 15 posts - 1,666 through 1,680 (of 3,348 total)