Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,690 questions
2 answers
sql server-adding a suffix to an integer field
I would like to display an Integer type field (Salary in this example) with a symbol suffix (%) To do this I've cast it as a varchar, with the varchar size the maximum current length of the field (5) However, what I would really like is to have the…
asked 2021-03-31T19:16:23.257+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(307.2, 32%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
Yacovs
1
Reputation point
commented 2021-04-07T08:55:45.397+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
5 answers
SSIS and oracle provider for OLEDB
I am using Visual studio 2019 to create SSIS package. Since I want to do a data flow and I want to use the SSIS Import and export wizard so that it creates the destination table easily. But when I chose data source oracle provider for OLE DB, it gives me…
![](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, 18%, 24%)' 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)
![](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, 45%, 36%)' 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)
3 answers
One of the answers was accepted by the question author.
Routing messages from O365 to a domain.local
Hello everybody. we have a Domain.local running on Zimbra which is used for the temp personnel.. lot of users who change frequently during the year.. we don't want to give them a full O365 license because we don't have so much license. and anyway they…
![](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(153.6, 78%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Unable to set TargetPath when create shortcut for a file
I am trying to create a Shortcut .lnk file for a file. but I unable to set the target path. this is my target path C:\TeklaStructures\2020.0\nt\bin\TeklaStructures.exe -I "C:\TeklaStructures\DowFirm\TS2020\Imperial\EngBypass.ini"…
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.
11,306 questions
asked 2021-04-07T07:34:25.807+00:00
AnilkumarM
41
Reputation points
accepted 2021-04-07T08:42:40.083+00:00
AnilkumarM
41
Reputation points
1 answer
NPS- PEAP - certificate authentication failure
Hi, I have configured an NPS server in Server 2019 standard. PEAP/Secured Password (EAP-MSCHAP2 v2) is working perfectly. PEAP/Smart card or other certificate is not working. The test client workstation has the correct new domain computer/user…
![](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(166.4, 13%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
0 answers
_stat and _utime synchronization
Hi, I'm working on a project regarding time, and I 'm trying to read/write time data from different processes. I'm thinking of using _stat/_utime to read/write time data, and I was wondering if anyone knew how _Stat and _utime manages synchronization. …
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,737 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,856 questions
asked 2021-04-07T06:25:17.397+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(201.6, 40%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Daniel Choi
26
Reputation points
commented 2021-04-07T08:41:29.557+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(92.8, 12%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
David Lowndes
4,721
Reputation points
1 answer
VS Tabbed template NewItemPage...Background black, but no style to set it??
File new project, Xamarin.Forms, Tabbed project. Look at NewItemPage.xaml. The background is black, but I can't tell what is styling it that way. <?xml version="1.0" encoding="UTF-8"?> <ContentPage…
asked 2021-04-06T21:42:16.527+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, 65%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Terrence7
1
Reputation point
answered 2021-04-07T08:40:37.317+00:00
JessieZhang-MSFT
7,711
Reputation points Microsoft Vendor
0 answers
[Hardware API/Partner Center] Params to get all products by the newest
By default if I create GET method https://manage.devcenter.microsoft.com/v2.0/my/hardware/products/ I'm getting products but starting from the oldest. We have over 10000 products. By default I'm getting only 50, but max is 500 if I create this GET:…
asked 2021-04-07T08:40:04.877+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(92.8, 99%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Skorski, Arkadiusz
6
Reputation points
asked 2021-04-07T08:40:04.877+00:00
Skorski, Arkadiusz
6
Reputation points
1 answer
How does a new user get access to reporting?
New partner needs access, do I reach out to an administrator for that?
asked 2021-03-31T14:21:41.59+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, 57.00000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JBelk
1
Reputation point
commented 2021-04-07T08:24:25.637+00:00
Echo Du_MSFT
17,231
Reputation points
1 answer
Recorded Meeting
We recorded a meeting and the host slides do not appear in the recorded session, only a black box. I can only assume the host did not 'share' the correct screen for the recording. During the live presentation, all guests were able to view the…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,890 questions
asked 2021-03-26T20:20:29.133+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(230.39999999999998, 88%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Pearson, Mardy
1
Reputation point
commented 2021-04-07T08:20:07.73+00:00
Sharon Zhao-MSFT
25,126
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Custom Frame Binding Not Working
I copied/wrote a class that inherits from Frame public class Circle : Frame { //private double _radius; public static readonly BindableProperty RadiusProperty = BindableProperty.Create(nameof(Radius), typeof(double), typeof(Circle), 126.0,…
asked 2021-04-05T05:02:29.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(288, 8%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXN%3C/text%3E%3C/svg%3E)
Xamarin NewBie
121
Reputation points
accepted 2021-04-07T08:19:49.197+00:00
Xamarin NewBie
121
Reputation points
1 answer
One of the answers was accepted by the question author.
How to activate darkmode for the text changed in WkWebViewRenderer?
I was trying to resize the text in a webView in Xamarin.iOS with a webView-renderer. It works, but my problem is that the dark mode does not work anymore. I have already changed the background of the web view, so it is shown right, but I don't know how…
asked 2021-04-07T02:04:04.613+00:00
Xamarin NewBie
121
Reputation points
accepted 2021-04-07T08:18:50.473+00:00
Xamarin NewBie
121
Reputation points
6 answers
One of the answers was accepted by the question author.
Question on CASE in Order BY
Hello, After having read this example - SELECT BusinessEntityID, LastName, TerritoryName, CountryRegionName FROM Sales.vSalesPerson WHERE TerritoryName IS NOT NULL ORDER BY CASE CountryRegionName WHEN 'United States' THEN TerritoryName …
asked 2021-04-06T14:58:32.093+00:00
Mikhail Firsov
1,881
Reputation points
accepted 2021-04-07T08:16:12.037+00:00
Mikhail Firsov
1,881
Reputation points
2 answers
not able to get custom saml response
Firstly i'm not able to add http://schemas.microsoft.com/ws/2008/06/identity/claims/role as it says its a reserved claim secondly my custom values (role/user.role) are not seen in saml assertion
asked 2021-03-29T18:37:16.407+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(99.2, 18%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sai Prasanna sastry S S
1
Reputation point
commented 2021-04-07T08:14:59.19+00:00
Siva-kumar-selvaraj
15,691
Reputation points
1 answer
One of the answers was accepted by the question author.
Key Vault references with network restrictions not working in App Service
It was announced on March 31st 2021 that Key Vault references in App Services with VNet integration would now work but for us it isn't. VNet integration has been enabled to subnet A in VNet X in the App Service. Key Vault has been configured 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(291.2, 4%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
1 answer
Graph API availability from within China
Hi We are developing an application which uses Azure AD for SSO within our (global) organization. We have deployed it in the cloud outside of China without any issues. However, we are facing an issue with a separate stack we have set up in China using…
asked 2021-03-12T21:59:54.33+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(300.8, 53%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
David Hayek
1
Reputation point
answered 2021-04-07T08:10:32.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(185.6, 70%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nandeesh Swami-MSFT
1
Reputation point Microsoft Employee
2 answers
Create sql server stored procedure
I have a query to run as below and i want to run below as a stored procedure, how can i SELECT * INTO database.schema.table FROM database.schema.table delete from database.schem.table please assist
asked 2021-04-05T20:42:57.6+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(220.8, 32%, 31%)' 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)
HuuM
46
Reputation points
commented 2021-04-07T08:04:55.583+00:00
EchoLiu-MSFT
14,601
Reputation points
1 answer
demande d'aide pour crée une clés pour le tracduceur loca translate sur wordpress
Bonjour je recherche à crée une clés API pour wordpress pour le plugin loco translaté est je n arrive pas à la crées je voudrais savoir si une personne pourrais me venir en aide car j ai 19 site à crées vu que je suis webmaster je doit etre un peux…
asked 2021-04-07T05:22:24.56+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(304, 15%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
philippe torrent
1
Reputation point
answered 2021-04-07T08:04:12.4+00:00
Pramod Valavala
20,656
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
SCOM 2019 - Port Monitoring (interface utilization)
Hello Gents, I've came across following issue. I need to monitor utilization on certaion ports on network device (discover through SNMP). After device has been discovered, by default port 26 had heatlh status as green. In health explorer I could see that…
asked 2021-03-30T09:41:14.78+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, 27%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGV%3C/text%3E%3C/svg%3E)
GA Václav Jandek
191
Reputation points
commented 2021-04-07T08:02:55.677+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, 30%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Crystal-MSFT
51,976
Reputation points Microsoft Vendor
1 answer
Pausing 3rd party media players like Spotify or Youtube Music
I am very new to Xamarin and Visual Studios as I am kind of learning to code while I create this project. I am trying to make an app where you press a start button and it pauses any background media player such as Youtube Music, plays an MP3 file, then…
asked 2021-04-06T20:23:04.67+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(57.599999999999994, 52%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
JD Dayhuff
1
Reputation point
answered 2021-04-07T08:01:35.097+00:00
JessieZhang-MSFT
7,711
Reputation points Microsoft Vendor