Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,640 questions
5 answers
One of the answers was accepted by the question author.
Execute the query in one server with different database
Hi, I want to execute the Select query in all databases of Server_A. Will I have to write 'USE' command 4 times with databases name of Server_A. Currently I have 4 database so I have written 4 times but it could be more. Is there a way to run query in…
![](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, 39%, 22%)' 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
Retry logic
Hello, I am communicating with a device via UDP, I send a message and I receive the response. Code in the attachement 69509-class-code-without-retry-mecanism.txt I want to add a retry mechanism if the equipment does not respond in the event…
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,962 questions
asked 2021-02-18T12:52:42.937+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, 14.000000000000002%, 31%)' 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)
LKHaSSeR
21
Reputation points
answered 2021-02-19T03:01:59.327+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, 7.000000000000001%, 11%)' 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)
Daniel Zhang-MSFT
9,626
Reputation points
3 answers
Gameloop not installing on my surface pro 7
I've tried to install Gameloop app (an android emulator) on my surface pro 7 ,but there are several errors popping up as soon as i start the installation,and most of them are ".dll" related.i've tried to download the required dll files…
asked 2020-11-13T20:36:03.603+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(51.2, 36%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
ali forghani
1
Reputation point
answered 2021-02-19T02:56:06.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(278.4, 10%, 36%)' 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)
Saeed Ahmed
1
Reputation point
1 answer
Wsus Patching for External Client PC
Hello Friends, I'm desiging a WSUS solution for my company. We have many users who carry laptops and don't connect to the domain very often. I want those client PCs get updated from our Internal WSUS server. So pls suggest the solution.
asked 2021-02-18T15:32:43.263+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, 38%, 38%)' 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)
Amit
1
Reputation point
answered 2021-02-19T02:53:15.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(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
Azure Active Directory P2 License Question
Hi, As an admin I would like to use the additional features that come as part of AADP2 like Azure Identity Protection etc and I would like to know the following. I assume that we have to purchase a P2 license for each of our admins in order 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(156.8, 79%, 25%)' 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)
![](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(160, 50%, 25%)' 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)
1 answer
Application Compatibility Test Tool for Windows Server 2019
Want to understand can get our Product Certified by Microsoft for Windows Server 2019 rather than just limiting to self-validating for the compatibility. Do we have any test tool associated with validations or not ? What are the charges associated with…
asked 2021-02-18T09:11:25.473+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, 33%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jay Prasad
21
Reputation points
answered 2021-02-19T02:51:31.21+00:00
AliceYang-MSFT
2,091
Reputation points
1 answer
Search emails from central app without requiring individual user consent
I'm building an app for my company that will allow users to search their Outlook emails (messages) from an internal company page. I'm trying to avoid having each person at my company auth into the app, and instead would like to just get permission from…
![](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(118.4, 96%, 21%)' 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)
2 answers
How to restore File Groups to retreive the data lost in SQL
Example: We have created file Groups in P4 Database. We have created another File Groups with Index in P5 Database, both file groups having same files, Is there any possibility to set all filegroups in one name.
asked 2021-02-05T10:50:06.81+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, 48%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Parameswara Reddy
1
Reputation point
commented 2021-02-19T02:42:01.103+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,631
Reputation points
1 answer
Windows Server 2016 RDS farm Event ID 5937, Windows Shell Experience Host
Good Afternoon All, We have an RDS farm that has suddenly this week started hanging at a Black screen during login for around 5 minutes. Once the desktop is displayed, the start menu does not work. I have traced through EventViewer and have found…
asked 2021-02-18T11:29:23.8+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(278.4, 50%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tatyana Saar
1
Reputation point
answered 2021-02-19T02:41:17.253+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, 30%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEY%3C/text%3E%3C/svg%3E)
Eleven Yu (Shanghai Wicresoft Co,.Ltd.)
10,756
Reputation points Microsoft Vendor
1 answer
Action bar height
How I can set the height of the action bar The page is called from MasterDetailPage <?xml version="1.0" encoding="utf-8" ?> <MasterDetailPage xmlns="http://xamarin.com/schemas/2014/forms" …
asked 2021-01-29T15:16:24.177+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(275.2, 56.00000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Asher Cohen
1
Reputation point
commented 2021-02-19T02:35:12.283+00:00
JessieZhang-MSFT
7,711
Reputation points Microsoft Vendor
3 answers
Replacing Every Other Occurrence of String
Hi, Running SQL Server 2017. I have the following HTML snippet contained in a varchar(MAX) variable: <tr> <td>Cell 1</td> <td>Cell 2</td> </tr> <tr> <td>Cell 1</td> <td>Cell…
asked 2021-02-13T18:02:42.897+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(140.8, 2%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV7%3C/text%3E%3C/svg%3E)
VDT-7677
121
Reputation points
commented 2021-02-19T02:32:23.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(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
0 answers
OpenSSH Private Key
How to open an OpenSSH private key file and read its content data to a buffer? There is no private key file extension. is there any way to verify that the selected file is a private key file? I am using the following method. But I am not sure that if…
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,742 questions
asked 2021-02-18T22:03:41.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(92.8, 64%, 18%)' 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)
kmu123
6
Reputation points
commented 2021-02-19T02:23:46.627+00:00
Jeanine Zhang-MSFT
9,756
Reputation points Microsoft Vendor
2 answers
VBA Vlookup Left part of range
I have the left 9 characters that I want to Vlookup in a range in VBA, but in the range lookup, I want to only search for any instances where it finds the exact same 9 characters in sequence then return the location of that cell. Can someone help me?
asked 2021-02-18T02:50:20.567+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(150.4, 16%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ryu
1
Reputation point
commented 2021-02-19T02:23:29.16+00:00
Erin Ding-MSFT
4,461
Reputation points
5 answers
How to show Parent Child Hierarchy without CTE
Here i use CTE to show parent child Hierarchy but curious to know without CTE how can i display parent child hierarchy? ;WITH DirectReports as ( SELECT CSM_ID, ID, ParentID, DisplayInCSM, …
asked 2021-02-12T17:31:10.25+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, 33%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETZ%3C/text%3E%3C/svg%3E)
T.Zacks
3,996
Reputation points
commented 2021-02-19T02:17:10.417+00:00
EchoLiu-MSFT
14,581
Reputation points
1 answer
SSRS 2016- Custom form authentication and related configuration in SSDT Visual studio 2019
Hi All, Greetings of the day! In our project, we are migrating ssrs 2008 reports to ssrs 2016 env. Technical Environment details - SQL Server 2016, SSRS 2016 SSDT - Visual Studio 2019 Datawarehouse - Oracle 11g SSRS authentication - Custo…
asked 2021-02-18T09:02:08.857+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, 84%, 15%)' 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)
Sudhakar Chavan
6
Reputation points
answered 2021-02-19T02:16:12.767+00:00
ZoeHui-MSFT
36,666
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server Express 2019 Architecture
Is SQL Server 2019 Express edition available in 32-bit or is it 64-bit only?
asked 2021-02-18T19:19:56.927+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, 52%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Adler, Ben
21
Reputation points
answered 2021-02-19T02:07:48.96+00:00
Cris Zhan-MSFT
6,631
Reputation points
0 answers
Establish connectivity between edge device and IoTHub Private Link endpoint over Azure P2S infrastructure
I have done the following steps: Have provisioned Azure P2S VNET infrastructure. Have provisioned IoTHub and created a private link endpoint on the virtual network. Requirement: Want to ingest data from edge device connected to VPN gateway…
asked 2021-02-05T14:27:47.067+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(54.400000000000006, 74%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK7%3C/text%3E%3C/svg%3E)
KumarKalambettuGanesh-7003
1
Reputation point
commented 2021-02-19T02:01:08.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(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache
20,271
Reputation points
1 answer
One of the answers was accepted by the question author.
PowerPoint math equation in table compatibility issues [macOS -> online version]
I am creating PowerPoint files on macOS and then publish them for students in Microsoft Teams. Unfortuantly, there are recurring issues with math formulas not being displayed. I attach two screenshots to this thread. How would I report such a bug to…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
10,184 questions
asked 2021-01-28T21:24:26.713+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(313.6, 66%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
wizthis
21
Reputation points
commented 2021-02-19T02:00:44.47+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, 24%, 20%)' 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)
JimmyYang-MSFT
53,291
Reputation points Microsoft Vendor
1 answer
Help me please! I cannot access my outlook on canvas. AADSTS90020: The SAML 1.1 Assertion is missing ImmutableID of the user.
Hello, I am trying to access my email on my canvas (university) i use outlook. AADSTS90020: The SAML 1.1 Assertion is missing ImmutableID of the user. I am getting this message. Please help me! what should I do?
asked 2021-02-13T06:29:29.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(156.8, 12%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Dr.Gargi B
1
Reputation point
commented 2021-02-19T01:58:43.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(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
1 answer
Create Event (4) in Microsoft flow creating multiple calender requests in the senders oulook calender.
Hi, In the flow, the action create event (V4) adds an event in the sender's outlook calendar automatically when the recipient accepts the invite through a power app button. The power app button triggers the flow which contains the create event(4). This…
asked 2021-02-16T12:36:50.2+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, 17%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKV%3C/text%3E%3C/svg%3E)
K Vijetha
41
Reputation points
commented 2021-02-19T01:57:04.407+00:00
Jade Liang-MSFT
9,976
Reputation points Microsoft Employee