Viewing 15 posts - 1,141 through 1,155 (of 5,109 total)
Argh!!! Didn't have an email for the thread and the site search engine is so bloody awful it can't find it. I did happen to run across a blog...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2019 at 8:54 pm
But now we have the interesting game that each QOTD is listed as an article. I'm not sure whether I like that or not.
Speaking of the QOTD, did...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2019 at 3:57 pm
This can perhaps be seen better with the below statement:
WITH N AS(
SELECT N
FROM (VALUES(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL))N(N)),
Tally AS(
SELECT...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2019 at 11:07 am
This behavior:
SELECT V.String,
CASE WHEN V.String COLLATE Latin1_General_100_BIN LIKE '%[a-z]%' THEN 'Yes' ELSE 'No' END AS ContainsLowerCase
FROM (VALUES('This has lowercase...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2019 at 10:58 am
Should this be considered as an error in earlier collations before 100?
Should what be considering an error?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2019 at 10:49 am
As I know, there is no true REGEX in SQL Server. Is the method to solve the question with "like" and wildcard?
You can use a different collation for that: Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2019 at 10:24 am
Perhaps, I did not put the question clearly. The initial question is how to check whether the string contains lower case letters.
That is far simpler:
SELECT V.String,
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 11, 2019 at 9:56 am
BINGO!! I would guess over 90% of the people who come to this site are not on a mobile device. So why do we cater to such a small...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 10, 2019 at 4:02 pm
I am trying to take a SQLEXPRESS database version 13.0.4001 and restore to SQL Server version 11.0.6248.0
You can't. SQL Server is not forward compatible.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 10, 2019 at 12:03 pm
Enterprise
What do you mean "enterprise"? Your title says the says Express. Even so a SQL Server 2012 database on Enterprise edition can be restored on a Standard Edition Server.
What...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 10, 2019 at 12:00 pm
If you want to develop SSIS propject for SQL Server 2019 you need at least version 15.8.1, SSDT for VS 2017. SQL Server 2019 isn't supported on the 2016 version....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 10, 2019 at 11:33 am
It's showing as delivered today - can you double check it's not hit spam/clutter etc.? If no luck there I'll dig deeper.
Dropped an email to our network team, looks...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 8, 2019 at 6:12 pm
Thanks Dave. I can't see I've received today's again. I am getting the subscription emails though; so would seem old they are bouncing
If you can, can you share the bounce...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 8, 2019 at 3:10 pm
Some real damning words here Steve. Some of it is justified others maybe not.
In terms of the point you made about questions, I think that this can be pretty valid,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 8, 2019 at 3:02 pm
In the 2008 R2 release they introduced SSIS project deployment model which uses SSISDB. Only the package deployment model is available in the 2008 release.
SSISDB was added in 2012,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2019 at 4:08 pm
Viewing 15 posts - 1,141 through 1,155 (of 5,109 total)