Viewing 15 posts - 16 through 30 (of 82 total)
March 14, 2019 at 6:26 am
The description "version number" vs "an optional integer that is used to group procedures of the...
February 8, 2019 at 6:33 am
Would the overhead have been too much to go with case when ResendLimit>ResendCount then ResendLimit – ResendCount else 0 end as RetriesLeft,
My own tendency is to go...
February 5, 2019 at 6:45 am
https://docs.microsoft.com/en-us/sql/integration-services/packages/deploy-integration-services-ssis-projects-and-packages?view=sql-server-2017
It looks like the "Deploy Projects to Integration Services Server" section...
December 18, 2018 at 6:47 am
As an aside, if you want every letter in there: 'the quick brown fox jumps over the lazy dog'
May 4, 2018 at 8:38 am
If I alter the query to ">2" instead, I get a result of 3, and an error if I change that HAVING to a WHERE. It would appear that BOL is incorrect...
November 28, 2017 at 6:54 am
Heh, I was so confident of my answer being "obviously" correct that I expected to find out that I was wrong about how EXECUTE() functions.
September 5, 2017 at 6:36 am
July 31, 2017 at 9:53 am
Hugo Kornelis (8/8/2013)
srienstr (8/8/2013)
select checksum('00000000-0000-0000-0000-000000000000')-1448389036
You're calculating the checksum of a value that just happens to loook remarkably like a uniqueidentifier value - but is just a plain old varchar.
select checksum(cast('00000000-0000-0000-0000-000000000000'...
August 8, 2013 at 6:45 am
ok181ko (8/8/2013)
paul.knibbs (8/8/2013)
ok181ko (8/8/2013)
How aboutnewid() = '00000000-0000-0000-0000-000000000000'
The question is not correct. Answer is 0 (zero).
The question asked which of the answers were possible outputs of the statement. It never stated...
August 8, 2013 at 6:29 am
I could think of a few indexes that might be worth adding to the pantry. Though perhaps my wife would be happier if we continue with partitioning on the item_type...
July 26, 2013 at 9:41 am
L' Eomot Inversé (6/27/2013)
kapil_kk (6/27/2013)
Danny Ocean (6/26/2013)
I never used between for string operation. I also never seen this kind of condition in working scenario.:doze:
Same here...
I dont think there is any...
June 28, 2013 at 6:55 am
Working with health data, we have a lot of code ranges that we deal with for reporting from varchar fields. I have only very rarely seen between used incorrectly, but...
June 27, 2013 at 8:22 am
honza.mf (5/17/2013)
srienstr (5/17/2013)
L' Eomot Inversé (5/17/2013)
SQL became "SQL" because someone other than IBM owned the rights to the original name the IBM...
May 17, 2013 at 11:21 am
Viewing 15 posts - 16 through 30 (of 82 total)