SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,940 questions
2 answers
One of the answers was accepted by the question author.
conditional join
hello, table1 has columns - col1,col2, col3 table2 has columns - col1,col2, col3 in my sql, I join the tables together by col1 but I also want to join via col2 and col3 only if col2 and col3 are present in table2 otherwise only join via col1. for…
asked 2024-05-31T04:56:18.7066667+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(262.40000000000003, 97%, 35%)' 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)
arkiboys
9,666
Reputation points
answered 2024-05-31T06:34:42.9066667+00:00
CosmogHong-MSFT
24,026
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
"Remove Unused References" unavailable for UWP projects
I have enabled "Remove Unused References" but the context menu of a UWP app project does not have the option: Could anyone shed some light on this?
![](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, 0%, 34%)' 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)
1 answer
One of the answers was accepted by the question author.
how to fix The provided location 'centraluseuap' is not available for resource group
{"code":"LocationNotAvailableForResourceGroup","message":"The provided location 'centraluseuap' is not available for resource group. List of available regions is…
asked 2024-05-30T22:12:41.3266667+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, 60%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Ravindra Mankar
0
Reputation points
accepted 2024-05-30T22:37:54.9433333+00:00
Ravindra Mankar
0
Reputation points
1 answer
One of the answers was accepted by the question author.
How to unlock a resource in a Storage Account?
Hello, Could you please help me on how to delete a resource in my Storage Account? I tried to delete the selecting resource in the Storage Account but it keeps saying that I have a resource block. I don't know how to unlock the resource in order to…
asked 2024-05-30T21:27:14.2066667+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, 8%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
minh tran
96
Reputation points
edited the question 2024-05-31T05:02:28.1+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, 64%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EON%3C/text%3E%3C/svg%3E)
OMMI NAVEEN KUMAR
195
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to unlock a resource in a Storage Account?
Hello, Could you please help me on how to delete a resource in my Storage Account? I tried to delete the selecting resource in the Storage Account but it keeps saying that I have a resource block. I don't know how to unlock the resource in order to…
asked 2024-05-30T21:25:38.5966667+00:00
minh tran
96
Reputation points
edited the question 2024-05-31T05:10:39.7266667+00:00
OMMI NAVEEN KUMAR
195
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
If I found a spelling mistake or more than one in the videos, how can I help to improve these videos?
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,283 questions
asked 2024-05-30T21:22:22.34+00:00
Shefa'☀️ Yaqoup
0
Reputation points
accepted 2024-05-31T05:21:21.93+00:00
Shefa'☀️ Yaqoup
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Listview with Checkbox is not responding based on the enable condition?
<?xml version="1.0" encoding="utf-8" ?> <ContentPage xmlns="http://schemas.microsoft.com/dotnet/2021/maui" xmlns:x="http://schemas.microsoft.com/winfx/2009/xaml" …
asked 2024-05-30T19:48:38.0533333+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(22.400000000000002, 32%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sowndarrajan Vijayaragavan
350
Reputation points
commented 2024-05-31T05:32:28.6666667+00:00
Sowndarrajan Vijayaragavan
350
Reputation points
1 answer
One of the answers was accepted by the question author.
Microsoft Graph Functionalities
Can anyone explain what is the difference with changekey in calendar and a delta function in Graph APIs. Are they the same, or do they serve for different purposes.
![](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(73.60000000000001, 87%, 17%)' 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)
1 answer
One of the answers was accepted by the question author.
How to show 3 picture per line on pages Blazor.
@page "/" <PageTitle>Home</PageTitle> <h1>HOUSE</h1> @for (int i = 0; i < images.Count - 1; i = i + 3 ) { <img src=@($"/Images/{i}") /> } @code { // Define the list of image file names …
asked 2024-05-30T15:49:57.01+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(249.60000000000002, 46%, 34%)' 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)
MIPAKTEH_1
80
Reputation points
accepted 2024-05-31T02:16:45.3366667+00:00
MIPAKTEH_1
80
Reputation points
2 answers
One of the answers was accepted by the question author.
Benefits and disadvantages of WITH (NOLOCK)
Benefits and disadvantages of WITH (NOLOCK). Also is there other commands that can serve different use cases.
asked 2024-05-30T15:12:46.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(294.40000000000003, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
80
Reputation points
answered 2024-05-30T21:20:01.3066667+00:00
Erland Sommarskog
102.4K
Reputation points
1 answer
One of the answers was accepted by the question author.
AzCopy log file for MD5 mismatch
Hi, I'm using AzCopy version 10.17.0 to download files from storage account. I'm using --put-md5 and --check-md5 to validate the file integrity. However, on download, if there is an MD5 mismatch for one of the blob then how that will be logged in the…
asked 2024-05-30T14:19:17.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(198.4, 7.000000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZG%3C/text%3E%3C/svg%3E)
Zeno GH
20
Reputation points
edited the question 2024-05-31T04:34:21.56+00:00
OMMI NAVEEN KUMAR
195
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Creating App Service Managed Certificate before CNAME record
Hello, I'm trying to create an Azure Web App to supersede an existing Azure Web App. I've created the necessary TXT record to validate the domain name in the new App Service, however I'm unable to create an App Service Managed Certificate for the TLS/SSL…
asked 2024-05-30T13:36:36.1066667+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(70.4, 19%, 16%)' 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)
Steve Christy
20
Reputation points
edited the question 2024-05-31T04:23:27.2766667+00:00
OMMI NAVEEN KUMAR
195
Reputation points Microsoft Vendor
3 answers
One of the answers was accepted by the question author.
Can I figure out why my new computer is crashing?
I have a new Windows 11 computer which keeps unexpectedly restarting after showing the blue screen. I have looked at the Event Viewer and see that it shows a bug check of 26. I also saved a mini dump but don't know how to read it. Can anyone help with…
![](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, 2%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%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(83.2, 74%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Does PostQuitMessage(0) deallocates all the memory allocated for widgets in main thread?
Hi, I'm working on a CPP win32 application. We are developing a multi windowed application. When we want to force quit the application, we use PostQuitMessage(0) which stops the event loop and all the window visible will be closed. But by doing this will…
asked 2024-05-30T12:30:26.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(265.6, 44%, 35%)' 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)
Harshithraj1871
1,516
Reputation points
accepted 2024-05-30T13:23:00.38+00:00
Harshithraj1871
1,516
Reputation points
1 answer
One of the answers was accepted by the question author.
Can I Create an Azure Function App with a Free Tier Account? What Are the Limitations?
Hello, I'm exploring Azure's services and considering using Azure Functions for a project. I'm currently on the free tier (Azure Free Account) and I have a few questions: Can I create an Azure Function App using the free tier account? If so, what are…
asked 2024-05-30T12:12:18.35+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(153.6, 4%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Aadhil Imam
30
Reputation points
accepted 2024-05-30T16:34:27.37+00:00
Aadhil Imam
30
Reputation points
1 answer
One of the answers was accepted by the question author.
https://graph.microsoft.com/v1.0/devices?$filter=registrationDateTime not working
Hi, I am trying to build an automated flow which runs daily in the early hours of the morning that uses a excel table to run specified HTTP requests for sign ins by newly registered devices and alerts us by email with the results to check in the…
asked 2024-05-30T12:02:29.9766667+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, 91%, 17%)' 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)
TryingNotToBeLikeABullInAChinaShop
5
Reputation points
commented 2024-05-30T14:15:24.26+00:00
TryingNotToBeLikeABullInAChinaShop
5
Reputation points
1 answer
One of the answers was accepted by the question author.
503 service unavailable - keeps repeating
Hi, Service: OpenAI service, using chat completions. Region: Sweden Central Scenario: When making a request it consistently tells me a 503 Service Unavailable error. This started happening since an hour. Only occasionally it does come through…
asked 2024-05-30T10:36:29.21+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(83.2, 10%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Dirk Broenink
105
Reputation points
accepted 2024-05-31T06:42:19.68+00:00
Dirk Broenink
105
Reputation points
2 answers
One of the answers was accepted by the question author.
Upgrade windows server 2012R2 to windows server 2016, will the Exchange system be affected?
Our current system is installing Exchange 2016 on the Windows 2012R2 OS platform. We are planning to upgrade the OS to Windows 2016 -> I want to ask, will the Exchange system be affected? Do I have to reconfigure Exchange? Thanks to everyone for help
asked 2024-05-30T10:28:19.7866667+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(3.2, 52%, 10%)' 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)
Pham Tien Dung
40
Reputation points
commented 2024-05-31T02:16:41.6433333+00:00
Pham Tien Dung
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Cannot alter column because it is 'ROWGUIDCOL'
After restoring a database one of my columns was changed from NULL to newid(). I tried to run ALTER TABLE Table1 ALTER COLUMN Id uniqueidentifier NULL script and I got 'Cannot alter column Id because it is 'ROWGUIDCOL'
![](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, 89%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELG%3C/text%3E%3C/svg%3E)
5 answers
One of the answers was accepted by the question author.
Hash table creation issue in Sql server
I have created hash table in outer procedure with 2 columns and trying to create another hash table with same name but 3 columns. Now if i try to insert into hash table in inner procedure i get error saying not able to access third column (which was not…
asked 2024-05-30T09:15:06.0866667+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, 0%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYG%3C/text%3E%3C/svg%3E)
yashwin g shetty
20
Reputation points
answered 2024-05-31T05:31:24.8266667+00:00
yashwin g shetty
20
Reputation points