Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,692 questions
2 answers
Multipoint geometry to Line geometry
HI, I have a multipoint shape geometry. 1) How do I convert this to a line geometry?. The points in the multipoint geometry are sorted. 2) Generalize the line. Reducing the amount of points by an algorithm e.g. Douglas Peucker with a variable tolerance =…
asked 2020-09-15T00:05:40.663+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 82%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
l pro
1
Reputation point
commented 2020-10-14T03:24:15.48+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EchoLiu-MSFT
14,601
Reputation points
1 answer
Uploading Paginated reports files by Powershell
Hello Guys I tried uploading paginated reports by powershell but I haven't find the right command to do it, I've used the following lines to upload datasets and reports but it doesnt work for uploading paginated reports. $datasetsFilenames =…
asked 2020-10-13T20:08:38.237+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 76%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jose Mantilla
1
Reputation point
answered 2020-10-14T03:00:29.817+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 94%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIX%3C/text%3E%3C/svg%3E)
Ian Xue-MSFT
40,591
Reputation points Microsoft External Staff
1 answer
One of the answers was accepted by the question author.
Delete CosmosDB entry with Azure Functions v3.x
I have been searching for a technique to use Azure Functions to delete items in a Cosmos database, using the in-browser code editor. Theres various reasons on my side why I dont want to use locally-developed code on VS. The code I am using is…
asked 2020-10-13T02:37:43.023+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 12%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDI%3C/text%3E%3C/svg%3E)
Dracon Interactive
26
Reputation points
commented 2020-10-14T02:57:21.647+00:00
Dracon Interactive
26
Reputation points
1 answer
Http response Truncated
I deployed an application under the IIS site of Sharepoint as the API site of my Web Part, as shown in the figure But when I request data from this site, I often find that the requested body is truncated. There is no rule to summarize (same request) …
asked 2020-09-29T08:23:51.787+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 64%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Alex Ren (Medalsoft)
41
Reputation points
commented 2020-10-14T02:39:54.523+00:00
Amos Wu-MSFT
4,051
Reputation points
5 answers
One of the answers was accepted by the question author.
Mapped network drives disconnect after some time
Hello everybody, As nobody answered to https://social.technet.microsoft.com/Forums/en-US/2b83691e-8cee-4950-96e2-a08c5ebce1c6/mapped-network-drives-disconnect-after-some-time?forum=winserverfiles for months now, I re-post here: A customer is running…
asked 2020-09-05T11:33:45.45+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 93%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESF%3C/text%3E%3C/svg%3E)
Stefan Falk
271
Reputation points
commented 2020-10-14T02:31:40.303+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 73%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESQ%3C/text%3E%3C/svg%3E)
Sunny Qi
11,076
Reputation points Microsoft External Staff
0 answers
Multiple federation endpoints on one ADFS servermultiple federation endpoints on one ADFS server
Is it possible to add Multiple federation endpoints on one ADFS server. We are currently using ADFS 3(2012 r2) Thanks
asked 2020-10-14T02:06:41.38+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 20%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pn_07
6
Reputation points
commented 2020-10-14T02:25:57.313+00:00
Pierre Audonnet - MSFT
10,191
Reputation points Microsoft Employee
9 answers
demtotion of 2008r2 and dns dlegation prompt
so demoting 2008r2 server. promoted 2 newer servers week ago. FSMO roles transfered, dnds and everything else looks good. do dcpromo on the 200842 server, and get to Remove DNS Delegation and it asks for admin credentials fro server that hosts…
asked 2020-10-10T16:04:26.887+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 24%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Captain Kirk
121
Reputation points
commented 2020-10-14T02:25:55.247+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 16%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHX%3C/text%3E%3C/svg%3E)
Hannah Xiong
6,286
Reputation points
5 answers
What kind of rights that can be given to a user?
Hi everybody When we create a new user in AD, by default, it has only user rights. One of the consequence is that they cannot have the rights to install new software. I was wondering how I could modify temporarily the rights that a user have so that he…
asked 2020-10-07T13:03:24.127+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 63%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFD%3C/text%3E%3C/svg%3E)
Frédéric Giguère
46
Reputation points
commented 2020-10-14T02:10:14.697+00:00
Hannah Xiong
6,286
Reputation points
2 answers
How to identify strong and weak ciphers?
Hi All, We have a doubt on how to identify the strong and weak ciphers from below: TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (0xc030) TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384 (0xc028) TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA (0xc013) Can anyone help me…
asked 2020-10-06T01:53:51.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 85%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFF%3C/text%3E%3C/svg%3E)
Fahrid F
201
Reputation points
commented 2020-10-14T02:06:19.473+00:00
Hannah Xiong
6,286
Reputation points
6 answers
upgrading domain controllers
upgrading two DCs from 2008r2 to 2012. we have licenses for 2012, will look at moving to 2019 next fiscal year. runing dcdiag on DC returns a few errors, and some in event viewer on DC, but not sure if it is something that would keep from going…
asked 2020-10-01T17:54:57.963+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 73%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
steve bart
1
Reputation point
commented 2020-10-14T02:03:42.32+00:00
Hannah Xiong
6,286
Reputation points
2 answers
One of the answers was accepted by the question author.
How to Use MAX() In An Update Query
I am trying to update a table with the MAX() function. This is the test scenario that I propose to you. Declare @LineItems Table ( ordernumber varchar(100) ,itemlinenumber int ,itemlineID varchar(100) ) Declare @OrderInfo Table ( …
asked 2020-10-14T01:16:52.773+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 79%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Johnathan Simpson
586
Reputation points
commented 2020-10-14T02:00:34.177+00:00
EchoLiu-MSFT
14,601
Reputation points
1 answer
Office 365 outlook attachment
Hello I want to buy Office 365 outlook for small business which is of security company. but i have question can i have security control on my office 365 outlook. can i turn off virus scanner on uploading attachment, and use my domain of outlook for…
asked 2020-10-07T07:28:53.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 36%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Fraz Ahmad
1
Reputation point
commented 2020-10-14T01:58:23.7+00:00
JeffYang-MSFT
6,241
Reputation points Microsoft External Staff
1 answer
How to get only list of attachment_ids for a message with O365?
I am using the Outlook 365 library with python. I want to list all the attachment_ids for a message id. Now the documentation only has list_attachements and get_attachment endpoints. These endpoints actually download all the attachments associated with…
asked 2020-10-03T02:35:31.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 68%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Amisha Joshipara
1
Reputation point
commented 2020-10-14T01:51:29.803+00:00
JeffYang-MSFT
6,241
Reputation points Microsoft External Staff
1 answer
Log in problem
Hello, my SIM card is no longer working but to log into my outlook it requires that I receive a text or call. When I press "try another way", these two options are only listed though I have the authenticator app. What's the next step to resolve…
asked 2020-10-02T15:55:06.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 9%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Haby
1
Reputation point
commented 2020-10-14T01:49:59.057+00:00
JeffYang-MSFT
6,241
Reputation points Microsoft External Staff
1 answer
Setting up On-Prem RDS Jump Host with MFA
Hi, I have a requirement to setup on-prem jump host with MFA /2FA (tokens) with Azure AD. I searched through but could not find any documentation to setup this on latest Windows platforms and the integration requirements/approach with Azure AD. Any…
asked 2020-09-29T03:22:35.533+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2020-10-14T01:47:26.513+00:00
Karlie Weng
19,141
Reputation points Microsoft External Staff
1 answer
VC++ Disable warning in external headers
Hi, few years ago disabling warnings in external headers was made possible with an experimental switch: /experimental:external broken-warnings-theory 3 years later this feature is still in experimental state. I'd like to know when it will be…
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,879 questions
asked 2020-10-13T10:26:42.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 36%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETR%3C/text%3E%3C/svg%3E)
Tony Riviere
1
Reputation point
answered 2020-10-14T01:44:43.943+00:00
Jeanine Zhang-MSFT
11,181
Reputation points Microsoft External Staff
2 answers
Get-RDRemoteApp randomly fails
When issuing a get-rdremoteapp cmd I randomly get failures stating the below. I can run the same command ten times and sometimes it runs fine and sometimes it doesn't. Whole environment is Server 2016, all updates applied.
asked 2020-09-22T15:45:04.837+00:00
slade1040
21
Reputation points
commented 2020-10-14T01:44:13.863+00:00
Karlie Weng
19,141
Reputation points Microsoft External Staff
1 answer
How to train for...
Dear all, I can't find any resources to train for the following two exams or get a feeling of what is required. Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) (…
asked 2020-10-13T08:00:10.323+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 20%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Melanie Haupt
1
Reputation point
commented 2020-10-14T01:43:53.78+00:00
Emily Hua-MSFT
27,731
Reputation points
2 answers
New scheduling needs due to Covid-19, is there any feature in SharePoint that can help?
Hi My post based on question on forum which was closed. I would like to ask is there any changes in this topis or any new suggestion? I past a question cause I have identical topic to handle and I didn't find solution in that post. …
asked 2020-10-12T10:56:26.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 34%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWB%3C/text%3E%3C/svg%3E)
Wojciech Bojewski
1
Reputation point
commented 2020-10-14T01:43:01.71+00:00
Jerry Xu-MSFT
7,961
Reputation points
1 answer
One of the answers was accepted by the question author.
Calling Azure Powershell commands from .net Core 3.1
Whenever I try to call Azure commands through .net core 3.1, it threw an exception I still get the error '{"The term 'Connect-AzureAD' is not recognized as the name of a cmdlet, function, script file, or operable program.\r\nCheck the spelling of…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 34%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)