Viewing 15 posts - 1,141 through 1,155 (of 5,111 total)
SQL Server developer is the full version of SQL Server Enterprise, but is allowed only the development work (using it in a production environment is against the terms of the...
April 12, 2019 at 10:25 am
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...
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...
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...
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...
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?
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:
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,
...
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...
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.
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...
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....
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...
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...
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,...
April 8, 2019 at 3:02 pm
Viewing 15 posts - 1,141 through 1,155 (of 5,111 total)