Viewing 15 posts - 16 through 30 (of 64 total)
The link above to vote is dead now that MS discontinued Connect and moved to UserVoice. Here is the the updated link to the topic:
Task List seems incomplete
https://feedback.azure.com/forums/908035-sql-server/suggestions/32899060-task-list-seems-incomplete
August 19, 2020 at 5:34 am
You can complain to Microsoft here:
July 17, 2020 at 5:54 pm
We use OUTPUT for capturing new key values added. When I started there was code like this:
CREATE PROC dbo.TheProc
@InputPrams datatypes
AS
declare @NewKey int;
SELECT @NewKey = MAX(TheKey)...
January 3, 2020 at 4:49 pm
The problem is that once the total price was added, it became part of the DISTINCT evaluation.
There are two rows with 'Car', and "SELECT DISTINCT Product" would return one row...
October 14, 2019 at 5:03 pm
ScottPletcher - Monday, December 31, 2012 2:40 PM
SELECT *INTO dbo.newtable
FROM dbo.oldtable_with_identity
UNION ALL
SELECT TOP (1) *
FROM dbo.oldtable_with_identity
WHERE 1 = 0
I was able to...
July 13, 2018 at 3:10 pm
Man! You guys have to go and take the fun out of everything 😉. But, yeah, you're probably right. Thank you.
May 18, 2018 at 9:35 am
Solomon,
I have successfully deployed some SQL CLR for EXTERNAL_ACCESS to allow Web service calls from SQL Server. Since I am a DBA and not a .Net programming expert,...
June 21, 2017 at 12:51 pm
Hi,
Is there any possibility of the "The .NET Environment" table being updated to through SQL Server 2016 (and maybe even 2017)?
June 6, 2017 at 11:43 am
OK,
I was able to make this work with SQL Server 2014 and Excel 2013.
First, here's the sp_send_dbmail call:
exec msdb.dbo.sp_send_dbmail
@profile_name = 'dbmail'
, @recipients = N'XYZ@abc.com'
, @subject = N'T-SQL Query...
October 24, 2016 at 2:22 pm
I have recently encountered a case where I have to process a database with literally thousands of views. In these views the first 29 columns are always the same,...
June 25, 2016 at 1:54 pm
Well, most of the data in the remote views does pass muster, so we end up pulling most of it. Thus, it is more efficient to get all the...
April 1, 2016 at 11:02 am
As I mentioned above, I get and store the sys.objects/sys.columns meta data for the remote views first, so I do have the column names. I use that to dynamically...
March 28, 2016 at 9:12 pm
I needed to create temp tables that match a remote system's data, and the remote system has an ever increasing number of programatically named views that I need to get...
March 23, 2016 at 2:35 pm
Hi,
I found the KB 956032 article, too. We just rebuilt our SQL Server instance from (SQL 2008 R2 on Win 2008 R2) to (SQL 2014 SP1 on Win 2012...
February 22, 2016 at 4:03 pm
I had this problem in SQL 2008 R2 (local & remote). Just removing the USE statement fixed it for me.
November 2, 2015 at 1:17 pm
Viewing 15 posts - 16 through 30 (of 64 total)