Viewing 15 posts - 16 through 30 (of 319 total)
"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
https://docs.microsoft.com/en-us/sql/language-extensions/language-extensions-overview?view=sql-server-ver15
In SQL Server 2019, Java, Python, and R runtimes are supported.
So not every language can be added with a language extension, or am I misreading this?
It might help to...
November 19, 2020 at 6:48 pm
Thanks Steve for this question, it's a good reminder about useful preference variables.
November 15, 2020 at 3:40 pm
I answered "Only a SCH-M lock". I didn't test it, I was based on DOCS Lock Compatibility, where SCH-M is not compatible with IX.
November 3, 2020 at 1:57 am
I like the way you have it well thought out, how the questions follow each other logically after weeks. There is a small detail on today's QotD from which one...
May 31, 2020 at 1:53 pm
But still, this question gave me new knowledge, such as what are base packages in R, how to make a list of installed packages, because without plyr package you can...
May 13, 2020 at 3:47 pm
I'm sorry, but your explanation is incorrect. Numpy.info, to which you refer, is a numpy-specific help function that does not give such an output about the data frame that is...
May 6, 2020 at 3:59 am
Thanks for this question, but is the ranking 1, 2, 2, 4, 5 given in the explanation correct? For the default SKIP, I would expect the ranking 1, 2, 2,...
May 2, 2020 at 12:24 am
Write me a question. George 🙂
Sorry, I have no question, I just wanted to point out the 3rd parameter for the ROUND function;-)
April 27, 2020 at 3:49 pm
Thanks Steve for this question. You can also try this:
SELECT ROUND(-7.7, 0, 1) as Round_truncated, CEILING(-7.7) as 'Ceiling';
GO
April 27, 2020 at 2:57 pm
I don't work with memory-optimized tables so I searched the web for the answer. Two sources state that DBCC CHECKTABLE will return: "Msg 5296, Level 16, State 1, Line 86...
March 27, 2020 at 4:39 am
Viewing 15 posts - 16 through 30 (of 319 total)