Viewing 15 posts - 1 through 15 (of 314 total)
I had some time, so "I had fun" and put together another way to find the part name from the CTE.
The query below displays the text of the part name...
April 19, 2022 at 1:42 am
In SQL Server 2017 (14.x) and later, it is possible to use the TRIM (Transact-SQL) function:
;WITH ctePC
AS ( SELECT expression
...
April 12, 2022 at 12:19 am
The question is irrelevant to the possible answers and to the explanation given. The question asks about the type of database, not what Amazon Redshift is.
According to Docs AWS "
December 27, 2021 at 3:12 pm
Very weird Qotd. The QotD title is "Azure MariaDB", but the question is about MongoDB workload. MondoDB is probably a typo. Possible answers are more for MongoDB.
December 20, 2021 at 2:09 pm
Thanks Steve for your work. Yes, time seems to be running faster and faster, sometimes I have a hard time catching up ...: -
November 13, 2021 at 1:21 pm
In the Docs Client Protocols Properties (Order Tab), there is a note that the protocol order settings are not used by Microsoft .NET SqlClient. The protocol...
November 12, 2021 at 2:39 am
You'll probably make fun of me for not ending it yet but I had some time, so maybe:
"Which permission, at a minimum, should a user have to execute DROP AGGREGATE?...
November 9, 2021 at 4:04 pm
Hi Steve, and what about this: "Which database permission levels below can I use to run DROP AGGREGATE in SQL Server 2019?"
November 8, 2021 at 5:37 pm
Thanks Alessandro for this question and an excellent explanation.
September 29, 2021 at 4:18 pm
When you execute a lambda function on a single value as:
(lambda y: y+5) (5)
then the result is 10. So the answer (5) is not correct?
August 11, 2021 at 3:29 pm
"Confers ownership-like capabilities on the grantee." Yes, I read this sentence several times and also SQL Docs "ALTER AUTHORIZATION (Transact-SQL)". Then I found links to "
February 16, 2021 at 12:45 am
Thanks for this interesting question Steve but I'm not sure why the bcp command doesn't specify the connection to SQL Server? See Docs bcp Utility.
January 7, 2021 at 3:25 pm
Thanks Steve for this question and all the work on SSC.com. Merry Christmas and Happy Holidays to you. Good luck in the new year.
December 25, 2020 at 5:45 pm
Thanks Steve for this explanation, I understand. The current state is well stated in What you can do with Language Extensions.
November 20, 2020 at 6:50 pm
It might help to read the 3rd sentence of the @language argument description in the docs sp_execute_external_script (Transact-SQL).
I have. But see also the...
November 20, 2020 at 5:19 pm
Viewing 15 posts - 1 through 15 (of 314 total)