Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql]

Structured Query Language (SQL) is a declarative query language for relational databases. Consider also using the tag for the specific database software if your question involves vendor extensions or language quirks.

0
votes
0answers
12 views

Access view SQL ad hoc query & output side by side

In MS Access, is there a way to view the sql query window and the related output side by side? I want to be able to write / run sql ad hoc queries and view the output simultaneously so I don't have ...
0
votes
1answer
38 views

How to get rid of Cold Turkey (website-blocker) / get around the block?

I'm using Cold Turkey for blocking distracting websites, but I unfortunately put it to 20 days and it now gets really annoying. Many "solutions" on the internet I have stumbled upon are for Cold ...
0
votes
0answers
34 views

How to install DBATools

I want to install on my Desktop DBAtools utility. I expect that it will help me to explore SQL more .. I found reference to it at this location https://dbatools.io/commands/ I downloaded the package ...
0
votes
0answers
9 views

Export attached(type) files from MS Access to SQL

I want to export database from MS Access database to SQL server. The problem is that when it comes to attached files than sql doesn't recognize it, because there is no such type of data in SQL. I ...
0
votes
0answers
35 views

How to display Oracle SQL code of MATERIALIZED VIEW using DDL command of SqlCl product?

Using Oracle SqlCl tool, when I try to display SQL code of a materialized view using following command DDL mv_address Oracle SqlCl display following message Multiple objects exist with the name ...
0
votes
0answers
33 views

Batch Error SQL Server BULK INSERT

I am attempting to have a script in my batch file that runs a SQL Server Stored Procedure. The Stored Procedure bulk inserts data from a .CSV file into a SQL Server table. When I run the Stored ...
1
vote
0answers
11 views

Intermittent issues connecting to a SQL CE Database

I'm trying to work on a local development copy of a website in Visual Studio 2017. This website uses a SQL CE database in an .MDF file, and I run the site locally through VS using IIS Express. When I ...
0
votes
0answers
17 views

How to do I make NPS properly create its SQL database?

NPS (Windows Server role) natively supports writing authentication logging events to a SQL database. Running through the wizard is supposed to create the database, the table, and the stored procedure(...
0
votes
1answer
14 views

Grouping by status then priority and extracting the earliest start time and latest end time if they exist in different rows

In MySQL, how can I group by status, then priority, and take the start time and latest end time if they exist in different rows? This is how my data looks right now: This is what I'd like the data ...
0
votes
0answers
143 views

Referencing a cell in an SQL query?

I have a workbook that takes a date the user types in cell A1 and generates a simple SQL query in cell B1 using string concatenation. For example, if a user enters the date 3/1/2018 into cell A1, ...
0
votes
1answer
87 views

WSUS WID Database recovery

My WSUS server, a Hyper-V VM running on a Window Server 2012 R2 Host, after a host power failure and later boot-up, showing error: Application: 3414 Source: MSSQL$MICROSOFT##WID An error occurred ...
0
votes
1answer
56 views

Server Hardware slower than Workstation Hardware (Same Software)

I made my Database Sync. Software multi-threaded. On my own workstation CPU : i5 2500 RAM : 8 GB HDD : 2x WDC WD5003ABYZ (Software Mirror) OS : Windows 10 Ultimate SQL Server : SQL 2008r2 it ...
1
vote
1answer
29 views

selecting non matching records from full outer join

I have two tables tb1 ------- 1,ali 2,ana 3,kim 6,git 8,sen 9,pam tb2 ------- 2,joy 3,fin 4,roy 5,dina 9,tim output ------- 1,ali 2,joy 3,fin 4,roy 5,dina 6,git 8,sen 9,tim I need to join two ...
2
votes
0answers
30 views

SQL Server 2017 cannot connect to remote databases

I tried to uninstall some old versions of SQL Server I had installed just to free up hard drive space, and along the way I corrupted my SQL Server 2017 such that SSMS could no longer connect to any ...
0
votes
0answers
59 views

Run an MS Query query from the command line to do and SQL join between two xlsx sheets in Office 2010?

I dispise excel formuals but I really love SQL. Is there a way to use MS Query from the command line to generate another excel file or csv with the results of an SQL Querybrun between two sheets ...

15 30 50 per page
 Microsoft office activator |  windows activation crack |  windows product key |  windows 10 product key |  windows 7 ultimate product key |  windows 7 keygen |  activate office 2010 |  office Project keys |  project professional product key |  office 365 office 2016 office 2013 key |  office 2016 office 2013 key |  windows 7 professional product key |  windows 8 professional product key |  windows 10 professional product key |  office 2016 professional product key |