<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang=EN-US link=blue vlink="#954F72"><div class=WordSection1><p class=MsoNormal>That sounds nifty. I will have to try that, when I get back to work. I have been fighting with the grid a lot. Your method sounds a lot nicer to work with.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Sent from <a href="https://go.microsoft.com/fwlink/?LinkId=550986">Mail</a> for Windows 10</p><p class=MsoNormal><o:p> </o:p></p><div style='mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='border:none;padding:0in'><b>From: </b><a href="mailto:nfbcs@nfbnet.org">Tracy Carcione via NFBCS</a><br><b>Sent: </b>Monday, November 23, 2020 12:38 PM<br><b>To: </b><a href="mailto:nfbcs@nfbnet.org">NFB in Computer Science Mailing List</a><br><b>Cc: </b><a href="mailto:carcione@access.net">Tracy Carcione</a><br><b>Subject: </b>Re: [NFBCS] SQL Server Management Studio and large amounts of data</p></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi Michael.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The command on my version of SQL Server Studio is control-shift-f. It can also be found by hitting alt to brin up menus, right-arrow to Query, down-arrow to Results, enter to bring up the submenu, then arrow up and down to find the option wanted.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I use results to file for testing, then change it back to grid for the real run so I can save to Excel. The output from the file option is a .txt file.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Tracy</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>From: NFBCS [mailto:nfbcs-bounces@nfbnet.org] On Behalf Of Michael Walker via NFBCS</p><p class=MsoNormal>Sent: Monday, November 23, 2020 1:29 PM</p><p class=MsoNormal>To: NFB in Computer Science Mailing List</p><p class=MsoNormal>Cc: Michael Walker</p><p class=MsoNormal>Subject: Re: [NFBCS] SQL Server Management Studio and large amounts of data</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thank you, Tracy. How do you set SQL output to a file, in the method you are referring to?</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Also, being new to this mailing list, does the NFB in Computer Science ever host virtual events over Zoom? If so, when is the next one? What topics are discussed?</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thank you,</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Mike</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>From: Tracy Carcione via NFBCS <mailto:nfbcs@nfbnet.org> </p><p class=MsoNormal>Sent: Monday, November 23, 2020 6:54 AM</p><p class=MsoNormal>To: NFB in Computer Science Mailing List <mailto:nfbcs@nfbnet.org> </p><p class=MsoNormal>Cc: Tracy Carcione <mailto:carcione@access.net> </p><p class=MsoNormal>Subject: Re: [NFBCS] SQL Server Management Studio and large amounts of data</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I usually know roughly what table I’m after, but I have paged down through long lists before, looking at what’s there.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Also, SQL has a name sysobjects, and another syscolumns, and you can use those to write a query to see what’s around. Don’t select all columns from all tables, though!</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I found this query to get some column names from a particular table, which perhaps you can modify:</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Select a.name as table_name</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>,b.name as col_name</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>From sysobjects a,</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Syscolumns b</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Where a.ID = b.ID</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>And b.name like ‘%depar%’</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I like to set SQL output to a file when I’m testing or looking at something. For me, it’s much easier to look at a file than to try to look at the grid in SQL.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>HTH.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Tracy</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>From: NFBCS [mailto:nfbcs-bounces@nfbnet.org] On Behalf Of Walker, Michael E. (UMSL-Student) via NFBCS</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Sent: Monday, November 23, 2020 2:16 AM</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>To: NFBCS@nfbnet.org</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Cc: Walker, Michael E. (UMSL-Student)</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Subject: [NFBCS] SQL Server Management Studio and large amounts of data</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi,</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>If you are using a screen reader, how do you most efficiently navigate large amounts of data? Suppose your database has over six hundred tables. One cannot use first letter navigation easily, since many table names begin with DBO. I might be browsing through the long list of tables, to get an idea of what the table name is, to write a query.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thank you,</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Mike</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>_______________________________________________</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>NFBCS mailing list</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>NFBCS@nfbnet.org</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>To unsubscribe, change your list options or get your account info for NFBCS:</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/michael.walker199014%40gmail.com</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> </p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>_______________________________________________</p><p class=MsoNormal>NFBCS mailing list</p><p class=MsoNormal>NFBCS@nfbnet.org</p><p class=MsoNormal>http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org</p><p class=MsoNormal>To unsubscribe, change your list options or get your account info for NFBCS:</p><p class=MsoNormal>http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/michael.walker199014%40gmail.com</p><p class=MsoNormal><o:p> </o:p></p></div></body></html>