Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,617 questions
2 answers
How to update status where nothing retturn from select cross apply function?
I work on SQL server 2012 I face issue I can't update status with No data returned where no result returned from select statement cross apply function meaning where nothing returned from select statement then update status to nothing data…
asked 2020-08-23T23:26:02.117+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, 77%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
ahmed salah
3,216
Reputation points
commented 2020-08-28T06:30:53.747+00:00
MelissaMa-MSFT
24,196
Reputation points
1 answer
One of the answers was accepted by the question author.
Is ASR replication possible for VMs hosted in a third party site integrated with a customer's data center (via a VPN tunnel)
Hi, Is ASR replication possible for VMs hosted in a third party site which is fully integrated with a customer's data center (via a VPN tunnel)? If the replication is not possible, what are the factors which are making it not possible? Could you…
![](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, 25%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV8%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
How do we ensure data consistency with the results of azcopy
Hi Team, Can anyone confirm how do we ensure data consistency with the results of azcopy. How do we ensure that data has copied without any issues (without opening any file, as there would be thousands of files)? Regards, VJ
1 answer
One of the answers was accepted by the question author.
Failure of office365 API connection authentication/authorization due to cross api connection in logic apps
Hi Team, I am facing issue of re-authentication and authorization issue into logic app deployment using ARM template. I have found several solutions but none of them worked for me. Actually my requirement is slightly different, which I am writing…
asked 2020-08-20T09:49:19.983+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, 74%, 11%)' 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)
Ashish Jain
21
Reputation points
accepted 2020-08-28T06:29:12.883+00:00
Ashish Jain
21
Reputation points
0 answers
IPAM Failover DHCP scope access denied
Hello! I have a trouble with scope on DHCP failover server in IPAM. 1) Server 1 - IPAM role + DHCP 2) Server 2 - DHCP role on Server 1 and server 2 create failover load balance dhcp scope Go to IPAM - Monitor and manage - DHCP SCOPE - edit DHCP scope…
Windows DHCP
Windows DHCP
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.DHCP: Dynamic Host Configuration Protocol (DHCP). A communications protocol that lets network administrators manage centrally and automate the assignment of Internet Protocol (IP) addresses in an organization's network.
1,039 questions
asked 2020-08-27T11:51:32.14+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(105.60000000000001, 55.00000000000001%, 20%)' 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)
Сергей Габов
41
Reputation points
commented 2020-08-28T06:28:57.077+00:00
Candy Luo
12,701
Reputation points Microsoft Vendor
4 answers
String Change in T-SQL
Hi All, I have a requirement, i want to replace string with id value from another table value. Another table id's: 4698,50470,50490,4698,5047 ID NAME 4698 ABC 5047 DEF 5049 GHI Source String :…
asked 2020-08-23T09:25:55.697+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(182.40000000000003, 17%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
BHVS
61
Reputation points
commented 2020-08-28T06:28:56.713+00:00
MelissaMa-MSFT
24,196
Reputation points
2 answers
Need Windows 10 Client Management Pack
Hi, I'm using SCOM 2019 to monitor our servers and applications. We have some Windows 10 Client machine as well to be monitored for CPU, memory & disk space. I could not find a management pack for Windows 10. While searching, I got this link…
asked 2020-08-27T19:47:07.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(41.6, 52%, 14%)' 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)
Sajid Ansari
1
Reputation point
answered 2020-08-28T06:27:28.65+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(166.4, 66%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AlexZhu-MSFT
5,631
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure Webjobs sdk version 3.x is not overriding cron expression for function trigger from application settings of azure
Hi, I'm trying to run Microsoft.Azure.WebJobs version 3.x from .Net framework 4.7.2 environment. I'm not using appsettings.json but have used Name resolver and reading my application settings from app.config. I'm able to override the values in…
asked 2020-08-26T05:23:30.403+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(259.20000000000005, 6%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
Kumar Desai, Vivek (SHS TE DC IND DI-DH TPA NI)
21
Reputation points
accepted 2020-08-28T06:26:53.18+00:00
Kumar Desai, Vivek (SHS TE DC IND DI-DH TPA NI)
21
Reputation points
3 answers
How to rewrite query to take small time when executed ?
I work on SQL server 2012 it take too much time to enhance it so how to enhance it to take small time how to write query this best enhance to take less time ? it take too much time near to half hour to return 50000 rows execution plan …
asked 2020-08-27T14:12:25.687+00:00
ahmed salah
3,216
Reputation points
answered 2020-08-28T06:25:37.29+00:00
MelissaMa-MSFT
24,196
Reputation points
1 answer
TFS 2019 to Azure Migration
Hi, Would like to know TFS 2019 to Azure Migration limitation. Thanks! AG
asked 2020-08-26T18:47:47.497+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(134.4, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
Gupta, AmitKumar 12/31/2022
1
Reputation point
answered 2020-08-28T06:23:21.217+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, 96%, 32%)' 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)
Fan Fan
15,326
Reputation points Microsoft Vendor
2 answers
Is Azure Storage the tech we need for allowing website users to upload and download files?
We have an Azure AppService/Website that allow users to upload and download files from the site. Right now those files are just stored in our SQL server instance. However, this is getting unwieldy (very large database). We assume there must be file…
asked 2020-08-12T22:27:45.227+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(35.2, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Joe Reddy
1
Reputation point
commented 2020-08-28T06:23:15.683+00:00
Sumarigo-MSFT
45,686
Reputation points Microsoft Employee
3 answers
When purchasing a Visual Studio Professional 2019 standalone license, can I use it to run Visual Studio Professional 2017?
When purchasing a Visual Studio Professional 2019 standalone license, can I use it to run Visual Studio Professional 2017? Or do I need a separate License? If so, can I still get a Visual Studio Professional 2017 standalone License directly from…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,998 questions
asked 2020-08-19T13:18:55.977+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, 28.999999999999996%, 18%)' 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)
Carina
1
Reputation point
commented 2020-08-28T06:18:55.697+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, 11%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
Dylan Zhu-MSFT
6,411
Reputation points
1 answer
How to query sql server 2019 graph database in .NET Core 3.1
How can I query and add/modify a SqlServer 2019 Graph Database in .NET Core 3.1. Is it possible to do a code first implementation (migrations)? Is the graph database accesable via entityframeworkcore? Is documentation / example code available?
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,998 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,565 questions
asked 2020-08-27T13:52:01.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(80, 27%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXV%3C/text%3E%3C/svg%3E)
Xander Valenkamp
6
Reputation points
answered 2020-08-28T06:03:46.913+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(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,626
Reputation points
1 answer
unable to connect local db in linked service in data factory
make sure the SQL Database firewall allows the integration runtime to access. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance…
asked 2020-08-26T09:20:51.777+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, 38%, 24%)' 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)
JasperJoshua
1
Reputation point
commented 2020-08-28T06:02:37.163+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Updates not showing in Software Center after installation
I have a bit of a strange issue which I'm hoping someone will be able to assist me with. I have a site with SCCM setup with SUP and everything is working perfectly well, including updates getting installed as I want them to. However, I've had a request…
asked 2020-08-27T16:29:32.83+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, 74%, 39%)' 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)
A.J. Armstrong
1
Reputation point
answered 2020-08-28T05:57:57.593+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(297.6, 24%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Rita Hu -MSFT
9,641
Reputation points
1 answer
Data warehouse features in SQL server versions
Hi, A was comparing SQL server versions and features and i noticed that in versions 2017 and 2016 Data warehouse features there is a feature: -Create cubes without a database …
asked 2020-08-17T11:55:19.783+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, 0%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aleksandar Stojanovski
1
Reputation point
commented 2020-08-28T05:53:40.4+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(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT
5,821
Reputation points
1 answer
Calculate cost per product per user from budgeted data
Hi, I have a requirement where i have the following data model and unable to arrive a correct measure for calculating cost per product per user.I want to be also able to slice by date and empl dim. Can someone pls correct and post ideas to…
asked 2020-08-17T12:16:35.453+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, 7.000000000000001%, 12%)' 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)
PV
21
Reputation points
commented 2020-08-28T05:51:57.583+00:00
Lukas Yu -MSFT
5,821
Reputation points
2 answers
Can WinUI Desktop App (C++) access MFC classes such as CString, CArray etc.
In an MFC application, there will be logic implemented in event handlers and those logics may contain MFC classes. While migrating an MFC UI to WinUI application, is it possible to re-use those logics containing MFC classes CString, CArray etc? Is…
asked 2020-08-27T14:27:53.52+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, 57.99999999999999%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Denson P D
6
Reputation points
answered 2020-08-28T05:51:17.803+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(73.60000000000001, 61%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFW%3C/text%3E%3C/svg%3E)
Fay Wang - MSFT
5,211
Reputation points
1 answer
mdx issue for multilevel dimension hierarchy
I have a requirement where i had to apply dimension security to one of the dimensions "CompensationItem". But the problem was it has dependency on another dimension "Scenario". We have a mapping table/measure (COMP SECURITY) with…
asked 2020-08-19T09:54:10.52+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, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
sudipta sen
1
Reputation point
commented 2020-08-28T05:50:08.457+00:00
Lukas Yu -MSFT
5,821
Reputation points
1 answer
Windows 10 1909 启用 TLS 1.3 后出现的问题
Windows 10 1909 企业版（内部版本：18363.1016）在 Internet 选项中启用 TLS 1.3（实验性）功能并在注册表中做如下设置： [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS…
