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.

Filter by
Sorted by
Tagged with
0
votes
0answers
5 views

SSIS Runs package correctly in visual studio, deployed to sql server fails in job execution

SSIS Runs package correctly in visual studio community 2019, deployed to sql server 2014 fails in job execution. SSIS package contains two connnections. first connection to data warehouse used in t-...
0
votes
0answers
18 views

Is it possible to specify a range in an Excel data connection string?

I have a connection in my excel sheet to an access database which specifies the data to retrieve based on an SQL query. I'd like to modify the SQL so that the WHERE clause is limited to a range on an ...
0
votes
0answers
36 views

Unable to install MS SQL Server or SSMS due to missing DLL, how do I find and install this DLL?

I have the exact issue as the OP of this question but their fix did not work for me: Related Stack Overflow Question I need to install MS SQL Server and SQL Server Management Studio on my computer. No ...
0
votes
1answer
35 views

selecting from SQL with LEFT JOIN and multiple conditions

I am trying to fetch posts with multiple filters, my database is as below, "Meta" Table id meta_key meta_value object_name object_id 2 location new city post 2 1 post_type section post 2 ...
1
vote
1answer
30 views

How to put a comment in a SQL query of JSON items from Azure Cosmos DB?

For an existing Azure Cosmos DB, I am testing SQL queries following this guidance. I would like to insert comments in my query, but the following fails, SELECT * FROM c /* Example comment */ While ...
0
votes
1answer
66 views

bash - passing an sql query as an argument to psql

I have the following SQL query that executes correctly in the psql shell: SELECT c.component_name AS "Component", c.component_version_name AS "Component Version", c....
0
votes
0answers
22 views

How to open .bin SQL file

I'm stuck and not sure if somebody had similar issue. I have an old database stored as .bin files. It relates back to 2012. I can see an xml catalogue file which indicates to me that it is sql data ...
0
votes
0answers
13 views

Continuous windows events 4648 and 4624 generated when ODBC driver is configured with Integrated windows authentication

We are running a C# application in my VM,which is configured to run as a windows service. The service runs as local system account and talks to a locally installed SQL database server. I have access ...
1
vote
2answers
45 views

Select statement using 'EXISTS' and 'IN' operator

I hit an issue to get data using 'IN' operator from another database. I need help fixing this please. My query looks like this: SELECT i.EXTERNAL_CODE, tc.SITE_NAME, tr.TRANSACTION_DT FROM ...
0
votes
1answer
26 views

How can I create a custom view in outlook that searches shows emails in all folders that have been unresponded to in the past 3 hours?

I currently have the following SQL line in the view filter to search for unresponded emails but need the remaining two pieces, can someone help? Unresponded emails: http://schemas.microsoft.com/mapi/...
0
votes
1answer
14 views

MS Access 2019 - questions about editing and running SQL queries

In the past I've worked with SQL Server and PostgreSQL, using SQL to run queries. At the moment I'm trying to get more familiar with MS Access, and I run into some problems. I prefer to write queries ...
1
vote
2answers
96 views

Notepad++ split line at variable characters preceding symbol

I am looking to split one line of data into a line for each state regarding a senate nomination vote. I have truncated all fifty states' data into two states' worth for the purposes of this question. ...
0
votes
1answer
71 views

Solve Error without installing PostgreSQL on Mac? dyld: Library not loaded: libpq.5.dylib

I am using a Mac OS X software called TablePlus which throws an error when trying to perform a backup of a PostgreSQL 13 database that is running inside a Docker container. dyld: Library not loaded: ...
0
votes
1answer
19 views

mysql report multiple values on same line

I have a bunch of temperature sensors in my house. I poll the sensors every minute and store the data in a mysql database that looks like this: +------------+--------------+------+-----+---------+----...
2
votes
1answer
683 views

Turn .sql file into a table

I have an sql file (from the following link). I need to get the table which is supposedly encoded in that file. I have no SQL experience and tried several things that have been suggested elsewhere: I ...
0
votes
1answer
59 views

From Powershell, Open Multiple SQL files in a single SSMS Instance

I have an automated Powershell process that ends with an Invoke-Item command to open multiple SQL files (currently 4 SQL files) for the testers, so they can run their scripts. Keep in mind, I am not ...
0
votes
0answers
11 views

Usage of pl sql developer tool

There is a developer-friendly feature in Toad for oracle tool that is if i double click on the table alias it will highlight where that alias is used in sql joins. This feature is a common one in ...
0
votes
0answers
251 views

unable to install sql server 2019 on window 10

after downloading and installation I got this error Opps Unable to install SQL Server (setup exe) Exit code (decimal): -2068052294 Error description : there is a problem with this installer package, ...
0
votes
0answers
35 views

SQL Server generating 1G dump files

I have a SQL Server generating large dump (mdmp) files, some of them are 1 GB in size, these are generated daily, sometimes 2 or 3 in a single day. This server is used heavily for PowerBI reports. ...
0
votes
1answer
21 views

MS Access how to show records where in Field is “XYZ”

I Have a Query to show me records. I want it to show me all records when in a Field (lets name it Letters), is "XYZ". The thing is some entries start with XYZ, in some it's somewhere in the ...
2
votes
0answers
136 views

Can not connect to SQL DB: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 0uery

I am trying to connect with HeidiSQL to the SQL DB which is running on the remote server to which I connect through the VPN. I am receiving an error message: Lost connection to MySQL server at '...
0
votes
0answers
15 views

Connecting to a remote server in a distanced computer

A couple of months ago, I have established a server which consists of a database server(VM) and a domain server. However, my goal is to able to manage the warehouse and biometric fingerprint scanner. ...
0
votes
0answers
32 views

Extract data from excel, based on one column condition SQL query should get the values and table name from excel sheet in python

Read the excel if column K9= pass through then read n,o,p and a,b,c /* TARGET */ 4.select count(*) from A9.B9 where column='C9'; /SOURCE/ select count(*) from N9.O9 where column='P9'; connect to ...
0
votes
1answer
25 views

Understanding versioning with MySQL and MariaDB?

I'm trying to understand the relationship between MySQL versions and MariaDB versions and hoping someone can clarify? I was under the impression that MariaDB was forked from MySQL many years ago and, ...
0
votes
1answer
64 views

How can I make SQL Server 2017 retry to start if startup fails?

We have a SQL Server that is used internally for testing. We shut down the server every night to save on Azure costs. Sometimes it fails to startup due to the paths it uses not being available like ...
0
votes
1answer
105 views

Virus / malware stored inside database

I have a small network of several Windows 10 machines (all protected by BitDefender 2020 Total Security), one of which acts as server with Firebird database. For some time the database is ...
0
votes
0answers
78 views

How can I access a postgreSQL database from an android device?

I am designing a database in pgAdmin4 and postgreSQL. I am new in it, and I would like to know if there is a way to access and modify this same database from my mobile phone. I am trying with RemoDb ...
0
votes
1answer
34 views

On an VDI that allows multiple users to connect at a time, how can I configure SQL to run with a different port for each user?

I am trying to launch an application named Aura, which uses SQL as its database engine, in a VDI that allows multiple users to connect at the same time. When the program is first launch, it works fine,...
1
vote
1answer
29 views

How can I delete multply rows from a table with another condition?

I have a table like this: 1 Apple 1 2 Apple null 3 Apple 2 4 Orange 1 5 Orange 2 6 Pear null 7 Lemon 1 8 Lemon null I want to delete a row if it's ProductId is ...
1
vote
1answer
451 views

Microsoft Access: Query to delete duplicate data but keep most recent

To my surprise, I've been having trouble finding an answer to this question for my specific case. I have a table with ID and date and I would like to keep only one ID, and that is the most recent one. ...
0
votes
0answers
27 views

Qgis 3.14 can not make mssql connection OK button grey out

I want to make a MSSQL connection but i can not press the OK button. This is grey out. Can someone help me out ???? Make new mssql connection screen:
0
votes
0answers
32 views

Failed to reconfigure MySQL server

Configuration succeeded when installing MySQL server in installer. However, the MySQL installer told that I still need to reconfigure it. I tried to uninstall both the server and installer, then ...
0
votes
1answer
113 views

The SQL statement to check “~ is in or not”

I'd like make the right table from the left table on MySQL. enter image description here SELECT A.id AS id, B.name AS name, A.name as loca FROM tst A, tst B WHERE A.id = B.loca; But, This can not ...
0
votes
0answers
29 views

Firewall is preventing internal communication and I can't get windows to open the firewall

We are having issues with our firewall causing several devices to not be able to communicate. Let me give you a rundown of our setup. We have a server running windows server 2016. It has several VM'...
0
votes
0answers
39 views

SQL Server XML field

I have an XML field in a database that stores the XML response from a service. Every now and then, the service times out and what actually gets stored in the XML field is a non-XML value "Time ...
0
votes
1answer
682 views

Change date format in PowerShell Export SQL to CSV script

I have a PowerShell script which exports several tables at once. The script works as a charm, but only i can't change the date formatting of the dates. A few fields concern dates as defined in SQL, ...
0
votes
1answer
16 views

Connecting to an SQL database

When I am using the database connection wizard to connect to the database I type in DB server IP & credentials but it does not display any available database in list to select. Are there some ...
0
votes
1answer
597 views

Sql Server 2014 Setup Stuck on Feature Selection

I think this problem is due to windows 10 bug due to which we can't click anywhere and this forum should be suitable for it. I am installing SQL server 2014 on my other PC which has little ...
0
votes
0answers
173 views

Executing SQL query through VBA

I am new here, but I always check this website whenever I have issues with excel and so far you've always helped me! Now I have a problem with VBA: I want to "call" an SQL query through a macro, so ...
0
votes
1answer
107 views

Take backup of SQL database from remote server to local computer across domains

So in this scenario there are two computers: A remote server hosting SQL that is not connected to a domain. A local computer that is connected to a domain. SQL Server Management Studio is installed ...
0
votes
0answers
28 views

.NET application seems not to be executing some operations when left to sit idle - laggy after sitting idle

I have a .NET application which basically does the following: Is connected to a bunch of serial devices (~32) via COM ports, and is processing data coming from those devices When a message is ...
0
votes
0answers
21 views

Required Auto select Date between with mannual intervention

Please help me on this issue I like to run this command thru batch so I want to change the date accordingly today without manual intervention Eg: SELECT XYZ,DFG,FGR,FHRT,Date_109,ABC from MY_TABLE ...
0
votes
0answers
30 views

Send an image to my database server

I am currently working on a webscraper that downloads an image and its title, description etc. from a website. The device that runs the scraper programm is my raspberry pi. I want to store the image ...
0
votes
0answers
23 views

Why is SQL Management Studio Stored Procedure breaking my rows into new lines?

I have a stored procedure that is set up to run once a week. However, it seems to be breaking up my lines if the length of the row is over 224 characters, right in the middle of words. The procedure ...
0
votes
1answer
1k views

I can't connect to my SQL server using my public IP

As of now, I am currently using SQL Server Management. I can connect to my SQL Server hosted on a different computer on the network. For explaining purposes, my computer is computer A and the computer ...
0
votes
1answer
68 views

sql server management studio 2017 (v.17.8.1) - how to open multiple .sql files at once in same instance

I would like to be able to multi-select stored procedures in SSMS then right click > open and have all the selected files open in different tabs of the same SSMS window. Looking online I can find ...
1
vote
0answers
265 views

Problems running R from SQL Server

I am running a standard piece of code from the MS SQL manual to test R functionality and am getting the error below. I'm thinking this is a setup issue of some kind since I am running code used as an ...
1
vote
0answers
81 views

Windows Server Firewall, How to block network traffic to a specific IP address

For some reason I cannot explain my SQL server is sending a bagillion 'EXEC sp_exec' calls to another DB on the network and I cannot find out why. I cannot restart either servers so in the meantime I ...
1
vote
0answers
583 views

How to improve postgresql query execution time

Problem Statement: we have a Enterprise product with Postgresql db as a backend. one of the tables has 5 columns and respective data type is (bigint time , bigint store_time , varchar category, ...
1
vote
0answers
20 views

SMTP- IIS Email Delivery Issues

We have a WEBAPI that uses SQL Database and customers use it to create a report or pull the info from it. Now the customers want the notifications whenever they have the data available or the reports ...

1
2 3 4 5
11