Viewing 15 posts - 61 through 75 (of 149 total)
Please explain, why 'b.' is selected and 'b' not.
August 29, 2013 at 12:16 am
Hugo Kornelis (8/22/2013)
palotaiarpad (8/22/2013)
BOL: However, you can change this behavior by changing the setting of CONCAT_NULL_YIELDS_NULL for the current session.The right answer is: it depends. 😀
Maybe you should specify...
August 22, 2013 at 9:07 am
BOL: However, you can change this behavior by changing the setting of CONCAT_NULL_YIELDS_NULL for the current session.
The right answer is: it depends. 😀
August 22, 2013 at 12:49 am
Maybe a clear definition of succesful execution would be helpful. In my opinion the statement execute runs fine if the procedure exists. The procedure throws an error not the execute...
August 15, 2013 at 12:36 am
Upgrade a project would be also possible or? Use the Integration Services Import Project Wizard create a new Integration Services project based on an existing one.
August 5, 2013 at 9:06 am
It was too easy. The first statement let choose the correct answer.
June 5, 2013 at 3:24 am
Sorry, but i hate codes like this. It took several minutes to clear up and make it well formated.
But finally i got it right!
The 50 is ok in my opinion,...
May 31, 2013 at 5:20 am
It was easy to answer, but:
- the right answer should be: it depends, as CHARINDEX uses the collation of the input.
- the question is actually more about SUBSTRING as CHARINDEX
May 21, 2013 at 2:36 am
Actualy it should be:
SELECT
customerID, count(city) as 'Count'
INTO CustomerCities
FROM Customers
GROUP BY CustomerID
May 13, 2013 at 7:52 am
Shouldn't be the first column binary? Or is the datatype precedence not applied here?
May 10, 2013 at 12:13 am
A nice one! I learnt something new, even if i wouldn't use this behaviour.
I'll still declare every variable as before. It's much easier to read and understand for me.
April 30, 2013 at 12:17 am
Viewing 15 posts - 61 through 75 (of 149 total)