Showing results for databases - Scripting Blog [archived]

Hey, Scripting Guy! How can I create a table in a SQL Server database?-- FD Hey, FD. And thanks: you’ve saved the Scripting Guys! Or, at any rate, you’ve saved the Scripting Guy who writes this column. As it turns out, this Scripting Guy is getting ready to leave town and attend his nephew’s wedding. Before he can leave, however, he needs to do ...

Hey, Scripting Guy! How can I delete a record – or a set of records – from a disconnected recordset?-- SM eHy sm.,. Sorry; let’s try that again: Hey, SM. We apologize for the poor typing the first time around; the Scripting Guy who writes this column is trying to adjust to typing with just one hand and just one eye. Last night this Scripting G...

Hey, Scripting Guy! How can I tell whether a specified table exists in a SQL Server database?-- LL Hey, LL. Well, as it turns out it’s absolutely impossible to tell whether a specified table exists in a SQL Server database. So, sorry, time to go back to watching the Major League Baseball playoffs. By the way, who else out there hates the Dodgers...

Hey, Scripting Guy! How can I use Windows PowerShell to pull records from a Microsoft Access database?-- SB Hey, SB. You know, you’re lucky to get this question answered; after all, this looks as though it’s going to be the very last Hey, Scripting Guy! column ever. To be honest, that came as a bit of a surprise to us, too: we hadn’t planned on ...

Hey, Scripting Guy! How can I get a list of all the databases on a SQL Server computer?-- ER Hey, ER. Before we answer your question, we’d like to take a moment to offer our opinions on all the major – and controversial – issues of the day. We can do that because the Scripting Editor is on vacation and, well, you know what they say: when the cat...