Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,692 questions
4 answers
One of the answers was accepted by the question author.
SQL - Selecting data between specific data rows
How do I select specific data rows from a table? Example: Table_A has 1,000,000 data rows and data columns VAR_1, VAR_2, VAR_3. I want to select all data between data rows 100,000 and 125,000
asked 2020-10-08T18:45:46.303+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(284.8, 67%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
David Smith
21
Reputation points
commented 2020-10-09T08:31:17.143+00:00
Ronen Ariely
15,201
Reputation points
0 answers
video non visible
Bonjour, Lorsque je charge une nouvelle vidéo celle-ci n'apparait pas dans liste. Je la voie seulement en utilisant firefox!!! Impossible de la voir sur IPad, Galaxy Note ou chrome sur PC! Pouvez vous me venir en aide?
asked 2020-10-05T17:11:02.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(259.20000000000005, 3%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDJ%3C/text%3E%3C/svg%3E)
DELAUBERT Julien
1
Reputation point
commented 2020-10-09T08:28:39.043+00:00
Sharon Zhao-MSFT
25,361
Reputation points Microsoft External Staff
1 answer
One of the answers was accepted by the question author.
Azure sql database and Azure sql MI , Failover group in the same Azure region
https://learn.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell it talks about in different regions for failover group . ? What about the implementation with the same region ?? (Sync replica .)
![](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, 40%, 23%)' 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)
3 answers
One of the answers was accepted by the question author.
Azure VM : kernal dump/ full memory dump
do we still need kernel dump/ full memory dump for azure VM ? how to set kernel dump/ full memory dump for azure vm ? and how to test it ?
1 answer
all users can send email but no one recieve email exchange 2019
Hi i've recently recover exchange 2019 and i noticed that user can send email (i test it with my gmail ) but non of them receive email both from same server or gmail... here is what i checked : checked all receive connectors with newly installed…
asked 2020-10-04T07:12:12.69+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, 39%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
admin admin213
96
Reputation points
commented 2020-10-09T08:24:21.393+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,696
Reputation points
2 answers
not able to update windows 10 pro
not getting updates on windows it shows 'try to reopen settings' using iso file my all data is getting deleted as I am in the innsider program
asked 2020-09-29T06:47:21.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(92.8, 14.000000000000002%, 18%)' 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)
aayash jain
1
Reputation point
commented 2020-10-09T08:23:36.4+00:00
Jenny Feng
14,221
Reputation points
2 answers
Windows 10 Version in Sys Info does not reflect latest install
I was asked to download Windows 10 Version 2004 in early September 2020 and I did. It was successfully installed. "Feature update to Windows 10 Version 2002 successfully installed 9/7 2020" and KB4571756 installed on 9/9/2020. But Sys Info…
asked 2020-09-29T20:19:09.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(201.6, 78%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Natarajan Neelakantan
1
Reputation point
commented 2020-10-09T08:23:07.04+00:00
Jenny Feng
14,221
Reputation points
2 answers
Touchpad reference guide
I apologize for the very basic question. A customer is replacing desktop PCs with Windows 10 laptops (in the specific case, HP laptops). They need to provide to users a guide to the use of the touchpad, as complete and simple as possible, in order…
asked 2020-09-30T06:30:47.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(268.8, 89%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Marius - Roma
371
Reputation points
commented 2020-10-09T08:22:11.81+00:00
Jenny Feng
14,221
Reputation points
1 answer
Copmuter doesn't update to OS version 2004, and doesn't support windows OS version 2004 even through Windows 10 Update Assistant
I am trying to migrate my old computer's info to my new computer, but I cannot due to my new computer being on OS version 1909 and my old computer being on OS version 2004. I can't force the 2004 update with the Windows Update Assistant (it says my…
asked 2020-10-09T01:41:32.073+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, 55.00000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGH%3C/text%3E%3C/svg%3E)
Grandma Hand
1
Reputation point
answered 2020-10-09T08:16:59.297+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, 57.99999999999999%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECF%3C/text%3E%3C/svg%3E)
Carl Fan
6,876
Reputation points
4 answers
SharePoint O365 document library Browser jumps up when clicking on ellipsis on an attachment
At SharePoint O365 document library, click on ellipsis open up the document preview, click on another ellipsis should open the menu to download, delete etc. The browser jumps up to top to display the menu, instead of display the menu but stay in place. …
asked 2020-09-24T00:26:11.337+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, 87%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWF%3C/text%3E%3C/svg%3E)
Wan Feng
1
Reputation point
commented 2020-10-09T08:15:28.913+00:00
Echo Du_MSFT
17,256
Reputation points
2 answers
Protecting VM with Premium SSD
Hello all, I've been doing some research and are still a bit confused about this... I'm a bit lost in VM with Premier SSD. I'm not trying to achieve better SLA by putting VMs to AS or AZ, I'm just wondering in what situation I may loose the VM and…
asked 2020-10-01T14:23:36.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(220.8, 77%, 31%)' 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)
Michal Sumega
41
Reputation points
commented 2020-10-09T08:10:21.687+00:00
Michal Sumega
41
Reputation points
1 answer
unexpected excel autoclose with error(Refer screenshot)
unexpected excel auto close
asked 2020-10-07T10:50:47.337+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' %3EAK%3C/text%3E%3C/svg%3E)
Ashok Kumar
1
Reputation point
commented 2020-10-09T08:07:35.997+00:00
Emi Zhang-MSFT
28,746
Reputation points Microsoft External Staff
1 answer
Windows Server 2016 - Upgrade Office 2010 to 2019 - Licensing options
Hello everyone, I'd like upgrade from Office 2010 to Office 2019 in Windows Server 2016. I have about 20-25 users total and there are two servers (local and remote) which are actually both on the same server hardware, as these are installed as virtual…
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,324 questions
asked 2020-10-04T07:24:34.283+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, 97%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
neuropathy
1
Reputation point
commented 2020-10-09T08:07:18.227+00:00
Emi Zhang-MSFT
28,746
Reputation points Microsoft External Staff
asked 2020-10-08T05:41:28.237+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, 35%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPI%3C/text%3E%3C/svg%3E)
Pass It Pawward
1
Reputation point
commented 2020-10-09T08:05:18.263+00:00
Emi Zhang-MSFT
28,746
Reputation points Microsoft External Staff
1 answer
Office for nonprofit organization
Hi I have free nonprofit account through my nonprofit organization. I would like to know if MS Office installs are free, and how many such installs are available for my organization. Thanks Bharad
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,324 questions
asked 2020-10-05T01:35:27.66+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(172.8, 99%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Contact SaiAashraya
1
Reputation point
commented 2020-10-09T08:04:42.43+00:00
Emi Zhang-MSFT
28,746
Reputation points Microsoft External Staff
1 answer
Using Excel in office 365 as web app
Working with large excel files using office 365 web app - Anyone please feedback on performance improvement ( compare to using shared drive option and offline MS Excel app)
asked 2020-10-07T07:03:09.333+00:00
Alexei Pereiaslov
1
Reputation point
commented 2020-10-09T08:03:52.493+00:00
Emi Zhang-MSFT
28,746
Reputation points Microsoft External Staff
1 answer
How to install an environment on my computer for Visual Foxpro applications
Hi, sorry I couldn't find an appropriate forum for this question as there's no Visual Foxpro forum available in the forum category list. But I just wanted to ask if there are still any Visual Foxpro developers out there that could help me out. I've never…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,448 questions
asked 2020-09-29T09:57:48.77+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, 36%, 17%)' 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)
Mike
1
Reputation point
commented 2020-10-09T08:01:23.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(249.60000000000002, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAX%3C/text%3E%3C/svg%3E)
Anna Xiu-MSFT
30,926
Reputation points Microsoft External Staff
2 answers
How to resolve performance issues arising in an application developed in Dot Net framework and being run on Windows 10?
Hi, I am an IT Infrastructure guy (MSCE certified). I am working as a network admin in an very small company whose actual work is related to Sales of engineering instruments, however, they also have a small team for developling software which are…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,448 questions
asked 2020-09-29T17:36:49.223+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(268.8, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Manoj Kumar
1
Reputation point
commented 2020-10-09T08:00:10.263+00:00
Anna Xiu-MSFT
30,926
Reputation points Microsoft External Staff
4 answers
Installation of SSIS extension for Visual Studio 2019 fails
I have installed VS Professional 2019 v. 16.6.0 . I could install Microsoft Analysis Projects extension but the installation of the SQL Server Integration Services Extension failed. I have restarted twice the workstation, but every attempt to…
asked 2020-09-24T08:50:43.657+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, 41%, 15%)' 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)
Alexe, Mihai
46
Reputation points
commented 2020-10-09T07:58:27.607+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,421
Reputation points
3 answers
exchange server 2010 public folder latency
hello guys, i need your advise with the below: i have one exchange server 2010 with many public folders under one pf database. all the pfs are configured the same way, the only difference is the users permissions. im facing the following issue on…
asked 2020-09-21T12:51:51.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(233.6, 26%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
eg1995
1,151
Reputation points
commented 2020-10-09T07:54:12.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(252.8, 22%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Lucas Liu-MSFT
6,181
Reputation points