Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,651 questions
2 answers
How to increment the value during insert programmatically
Declare @Order INT=0 INSERT INTO MyTable(col1,col2,ordercol) values('abc','xyz',++@Order) this way order value is not getting incremented, but i found this way value gets incremented during update declare @i int = SELECT ISNULL(MAX(interfaceID),0) +…
asked 2020-12-13T19:07:31.387+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(256, 12%, 34%)' 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)
Sudip Bhatt
2,276
Reputation points
commented 2020-12-18T03:21:34.29+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,581
Reputation points
2 answers
One of the answers was accepted by the question author.
Can i create a alias in internal AD to point to office 365 SMTP address to relay emails from internal application
Hi, We have a question internally, that can we create a alias (mail.domain.com) name for an office 365 SMTP address in our internal AD for our applications to relay an emails instead of using "smtp.office365.com". is it possible? Thanks …
asked 2020-12-15T17:28:01.507+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(137.6, 17%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
pavan kumar
371
Reputation points
accepted 2020-12-18T03:20:57.563+00:00
pavan kumar
371
Reputation points
5 answers
Can someone please help fix the coding issue for the application "Apartment Rental by City?" (Exception Unhandled - "Input string was not in correct format")
Option Strict On Public Class frmApartment ' Class level private variables Public Shared _intSizeOfArray As Integer = 9 Public Shared _strDisplayCity(_intSizeOfArray) As String Private…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,174 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,732 questions
Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
1,002 questions
![](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(48, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
1 answer
Zero Trust, Adaptive Auth & Solarwinds
Would Microsoft's zero trust architecture and/or adaptive authentication technology have helped to minimize the impact or more quickly identify this threat?
asked 2020-12-15T17:00:27.387+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(102.4, 47%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETF%3C/text%3E%3C/svg%3E)
Trey Foote Foundation
1
Reputation point
commented 2020-12-18T03:07:20.687+00:00
Candy Luo
12,711
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Logon prompts after upgrading to Outlook 2016
Hi and hope someone can help. Over the last 6 months we've migrated from on-prem Exchange 2010->2016. During this time we were also upgrading out clients from Office 2010->2016. During the transition Outlook 2010 clients had no issues,…
asked 2020-12-10T11:03:01.16+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(121.6, 6%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Stu C
191
Reputation points
commented 2020-12-18T03:03:55.373+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(281.6, 84%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jade Liang-MSFT
9,976
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Enabling FileStream in AG participated Database
Hi team, I was asked to enable FileStream for one of the existing varbinary(max) column in existing table. It is already participating in Avalability Group where we have 1 primary & 1 secondary server. Now as part of the change, i am doing the…
asked 2020-12-10T23:05:08.07+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(112.00000000000001, 78%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Balamurugan Rajendran
20
Reputation points
commented 2020-12-18T02:59:36.263+00:00
Ben Miller (DBAduck)
956
Reputation points
3 answers
What happens of I make one disk online when it has the same letter as the OS disk?
So I recently brought a SSD and have successfully cloned over my OS and C Drive, making it the new C Drive (system boots up as normal and it is labelled C in disk management) but now when I go to format the old C Drive it’s appearing as Offline and in…
asked 2020-12-12T21:21:52.213+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(112.00000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAE%3C/text%3E%3C/svg%3E)
Aaron Ellis
1
Reputation point
commented 2020-12-18T02:58:58.703+00:00
Xiaowei He
9,906
Reputation points
2 answers
Intune Policy deployment not accuratly showing who it has been deployed to.
Hi all, I have another very annoying Intune issue that is making it very hard to manage our Windows 10 devices. We have a bunch of policies (Baselines, security policies and classic device policies) that are deploying to Windows 10 devices without…
asked 2020-12-11T16:09:05.197+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(188.79999999999998, 38%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEN%3C/text%3E%3C/svg%3E)
Ed Newman
191
Reputation points
commented 2020-12-18T02:58:19.157+00:00
Lu Dai-MSFT
28,411
Reputation points
1 answer
[Migrated from MSDN Exchange Dev] Office 365 users are restricted to a 10MB attachment Limit
[Note] This thread was originally posted on MSDN. As the MSDN Exchange Dev forum mainly focuses on developing issues and the TechNet Exchange forums for general questions have been locked down, we manually migrated this one to Microsoft Q&A platform…
asked 2020-12-18T02:46:45.003+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(25.6, 67%, 12%)' 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)
Joyce Shen - MSFT
16,671
Reputation points
answered 2020-12-18T02:55:06.547+00:00
Joyce Shen - MSFT
16,671
Reputation points
2 answers
UEFI PXE boot bypassing Enter on Laptop
Hi All, seeing something I have never seen before. Suddenly Dell laptops that have had the network card as the first boot device are bypassing the requirement to press Enter to continue are booting to PXE after reboot. We can plug a desktop device into…
asked 2020-12-11T15:42:32.55+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(44.800000000000004, 38%, 14%)' 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)
William Bracken
1
Reputation point
commented 2020-12-18T02:54:41.063+00:00
Simon Ren-MSFT
35,306
Reputation points Microsoft Vendor
1 answer
Intune - IOS Company Portal Single App Mode - Wants to open Settings to install configuration profile
I have attempted to roll out enrollment profile which has Company Portal (VPP) run in exclusive/single app mode until sign in by end user. I gave one to test but when user signed in and profile downloaded the Company Portal app then states to open…
asked 2020-12-11T02:46:23.623+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(124.80000000000001, 5%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
A Wade
1
Reputation point
commented 2020-12-18T02:54:08.313+00:00
Lu Dai-MSFT
28,411
Reputation points
0 answers
RemoveAccessRule is not working for non-inherited ACEs
I am using RemoveAccessRule to remove some NTFS permissions. The script (too long to post) cycles through ACEs ($DACL) and should remove the entry. It works for some folders and for others it does not work and the entry does not get removed without any…
![](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, 31%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIA%3C/text%3E%3C/svg%3E)
![](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)
3 answers
One of the answers was accepted by the question author.
A malicious code was querying a hard-coded DNS server instead of system DNS even that was not registering with system
A malicious code was querying a hard-coded DNS server instead of system DNS even that was not registering with system. We could see the queries at the network level (Packetbeat logs). Can you please throw some light on it?
asked 2020-12-17T07:40:17.39+00:00
Nazakat Ali
61
Reputation points
answered 2020-12-18T02:34:28.063+00:00
Candy Luo
12,711
Reputation points Microsoft Vendor
1 answer
DB2 Statements to SQL
Hi. I am trying to migrate queries from DB2 to SQL. I have few statements in DB2 which I am not sure, how to have similar statement in SQL. How to use commands / equivalent of - REFRESH TABLE , RUNSTATS in SQL ? Thanks
asked 2020-12-17T09:48:55.89+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(9.6, 94%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Padmanabhan, Venkatesh
246
Reputation points
commented 2020-12-18T02:34:15.297+00:00
CathyJi-MSFT
22,306
Reputation points Microsoft Vendor
0 answers
Accessing property from multiple Classes (MVVM WPF application)
I have been trying to learn C# by creating a small app. Recently I have been trying to implement SessionEvent for screen lock/unlock to pause the timer. I am having a problem understanding how to access timer from App.xaml.cs. Currently while locking the…
Windows Presentation Foundation
Windows Presentation Foundation
A part of the .NET Framework that provides a unified programming model for building line-of-business desktop applications on Windows.
2,783 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,995 questions
XAML
XAML
A language based on Extensible Markup Language (XML) that enables developers to specify a hierarchy of objects with a set of properties and logic.
814 questions
asked 2020-12-16T14:23:49.5+00:00
mrw
201
Reputation points
commented 2020-12-18T02:27:16.837+00:00
DaisyTian-1203
11,626
Reputation points
1 answer
Beam like pointers invisible in text field in RDP client
I'm part of a team actively working on a HTML5 RDP client. Pointers received by the TS_COLORPOINTERATTRIBUTE PDU are transformed into cursor pointer files and applied using the CSS cursor attribute. This works except for beam like pointers! They are…
asked 2020-12-17T14:34:52.997+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(121.6, 73%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
geiregjo
1
Reputation point
answered 2020-12-18T02:17:20.31+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(38.4, 50%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJY%3C/text%3E%3C/svg%3E)
Jenny Yan-MSFT
9,336
Reputation points
3 answers
Windows 10 AlwaysON VPN with EAP-TEAP
Hello Guys, We are currently looking into using a new AlwaysOn VPN with EAP-TEAP against Cisco ASA + Cisco ISE Pair. We have tested everything with EAP-TLS (with User Certificate) and EAP-PEAP + EAP-Mschapv2 (User against AD) and everything seems to be…
asked 2020-10-08T12:12:44.94+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(25.6, 65%, 12%)' 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)
Stanislav Bachtin
1
Reputation point
commented 2020-12-18T02:13:50.753+00:00
Gloria Gu
3,896
Reputation points
1 answer
One of the answers was accepted by the question author.
How to send message to device after provisioning with mqtt x509?
I'm using the azure_sdk_for_c to provisioning with Azure it hub following the example paho_iot_provisioning_sample. I can successfully get the Hub Hostname and device ID from DPS but I don't know how to publish a message to the device. May I need to…
![](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(268.8, 63%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHV%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Find how many ticket removed, added and existing with SQL query
I have table with similar case number for different products. Hence I want to find the the case number has been added, removed and existing according to the date. I have a data something like below So the code should take data from 2020-12-02…
![](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(201.6, 41%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
0 answers
Help with our implementation of printing in our Direct2D Win32 app, using an ID2D1CommandList as render target.
We have a Win32 desktop app which uses Microsoft Direct2D to draw graphics to a D2D Bitmap render target. Users are then able to print those graphic objects. To do this, we switch the Direct2D render target for an ID2D1CommandList. We draw our graphics…
Windows API - Win32
Windows API - Win32
A core set of Windows application programming interfaces (APIs) for desktop and server applications. Previously known as Win32 API.
2,648 questions
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,754 questions
asked 2020-12-17T11:53:46.367+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, 84%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
M S
1
Reputation point
commented 2020-12-18T02:04:08.123+00:00
Drake Wu - MSFT
991
Reputation points