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
6 views

PHP SQL Query with != Selection of multiple entries [migrated]

I have a PHP script that is calling the SQL database and telling it to select every row except for where the code column is free_checkout. $query = $this->db->query("SELECT * FROM " . DB_PREFIX ...
0
votes
0answers
19 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
5 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 out" ...
0
votes
0answers
5 views

MS SQL query with wildcard and select dont work… but why? [migrated]

Im new in sql and i try to debug this: This work: (SELECT TRY_PARSE((SELECT CONVERT(nvarchar, '12.02.2021')) AS DATE USING 'en-gb')) This work too: SELECT * FROM Employees WHERE BirthDay LIKE (...
0
votes
0answers
6 views

SQL SELECT AVG in Flask returns a 2D array [migrated]

(*) I am learning both Flask and SQL. I am cloning existing, working code. I am running my Flask code in the PythonAnywhere environment. The code I have modified starts @app.route('/print_my_dogs') ...
0
votes
1answer
51 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
0answers
10 views

How to pivot multiple rows into one by placing them next to each other in LibreOffice Calc?

Let's say I have data like this, showing what video games each person owns (not my actual data but that's sensitive information): Name Game Publisher ---- ---- ----...
0
votes
1answer
13 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
0answers
28 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
36 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
22 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
41 views

SQL Plus (Oracle XE Database): “Error Updating Shortcut” When Trying to Change Properties

I am learning SQL with SQL Plus as part of a college class and I cannot change any of the SQL Plus prompt's properties because of the following error: I checked the file location it mentions and ...
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
18 views

Debian 10 Mariadb libmysql client version update not possible

we are running an MariaDb Database and using php5.6 I just want now to upgrade the old Database Client version libmysql - mysqlnd 5.0.11-dev - 20120503 to a newer. So I can't see one in my Debian 10 ...
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
26 views

How do i update an Excel Sheet based on the results of an SQL query that draws criteria from another sheet?

I am looking to build an Excel document that allows you to list some ID numbers on a certain sheet, and when you "refresh all", an SQL query is run with those IDs as the criteria, and the second sheet ...
0
votes
0answers
28 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
22 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
0answers
254 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
30 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 ...
0
votes
0answers
59 views

I want to retrieve old viber messages from the viber.db file. Ive ran an sql query but I receive an error saying its not a database

I've recovered the viber.db file using recovery software, and have tried viewing it using different applications but I keep receiving the error 'its not a database'. Can you help me? Thanks.
1
vote
0answers
202 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
43 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
157 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
19 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 ...
2
votes
1answer
167 views

SQL Server (SQLEXPRESS) Service cannot start. It's referring to a file that doesn't exist

I'm learning how to create an application in Visual Studio and following a tutorial to create a service-based database. When I try to add the new item (service-based db) in Visual Studio, I got the ...
-2
votes
1answer
131 views

installing sql server management studio 2017

i want to install ssms2017 but it get error code 0x800b0003 here is the log file [3744:1E78][2019-10-27T16:43:04]e310: Failed to verify payload: HelpViewer2_3 at path: C:\ProgramData\Package Cache\....
1
vote
0answers
305 views

SQL Server Management Studio: Exception has been thrown by the target of an invocation. (mscorlib)

I am using Microsoft SQL Server Management Studio 11.0.7001.0 Microsoft Data Access Components (MDAC) 10.0.17763.1 Microsoft MSXML 3.0 6....
0
votes
0answers
5 views

Visual Studio Code No Longer Showing Number of Results for SQL Queries

This just started the other day, perhaps after the most recent update. Visual Studio Code was showing the number of results in the message section under the results. Now it is just showing Success/...
0
votes
2answers
35 views

SQL with an error

I am trying to create a table using SQL STUDIO and keep receiving this syntax error: Incorrect syntax near 'CourseNo'.
0
votes
1answer
124 views

why am i getting a bool returned instead of sql variable

i have stored ip addresses in a table and am trying to print them out on my webpage http://freegifts.virtualworker.online/verify.php but i get this error Warning: mysqli_num_rows() expects ...
0
votes
1answer
43 views

ASP.NET/C# web app cannot 'find' Azure SQL server database

I've done similar web apps in the past and I've never had an issue with the SQL connection string. I've tried several variations and still I get the following error: iisexpress.exe Error: 0 : ...
0
votes
0answers
26 views

SQL - connecting data from multiple tables, over foreign key

I'm breaking my head over following problem that I can't figure out. I have three tables containing data about: students (table students), courses (table courses) and studies (table studies). ...
0
votes
0answers
10 views

Microsoft SQL Server Management Studio 2016 Save Changes popup

Any word if Microsoft will ever update the Save Changes popup to not appear in SQL Management Studio? It is spectacularly annoying. I have heard someone argue this is similar to all other Office ...
0
votes
0answers
16 views

spark left join which caused cartesian product

I have two dataframes,one has more than 100 rows,and the other one has only one row.The two dataframes have a same column names "period",and the value of period in two dataframes are all the same,as ...
0
votes
0answers
101 views

convert Firebird stored procedure to MySQL

I have trouble converting a stored procedure from Firebird to MySQL. Here is my existing code from Firebird: SET TERM ^ ; CREATE OR ALTER PROCEDURE "ActPerHour" ( days integer) returns ( "...
0
votes
0answers
9 views

Teradata SQL Editor - Execute Query results in mouse moving to top of screen

This may be a very simple question for this community, but it has been bothering me and I find no solution for it online. Does anyone know what configuration or setting in Teradata Studio v16.20.00....
0
votes
1answer
28 views

SQL Developer - how to assess change to data model

I'm working with a schema I'm not familiar with and am trying to find out if there is a way to do a diff between the state of the data in the schema instance between transactions - does anyone know if ...
0
votes
0answers
15 views

Not Receiving SQL Profile Emails from Certain Profile but Others Are

I'm not receiving SQL emails on my Outlook from a specific profile, but I do receive emails from other Profiles. Others are receiving emails from the profiles just fine. Is it an Outlook setting that ...
0
votes
0answers
55 views

sqlplus not getting connected to host or target on linux box

I have a shell script which runs sql. I have set the oracle home and bin path. I have oracle instaclient though. I have checked the tnsora file and it has necessary details for the host. Now I am ...
0
votes
0answers
20 views

SQL Query Connected Excel Report Hanging on Saving

I have a MS Excel 17 sheet with multiple SQLDB queries connected for reporting. This is called by a python script that opens, puts in the PW, refreshes the queries, saves the report, and closes excel. ...
0
votes
0answers
53 views

SSRS Error :Could not find stored procedure 'IsSegmentedChunk'

Open SSRS Reports we receive this error (sometimes) (When opening reports or developing reports) An error occurred within the report server database. This may be due to a connection failure, timeout ...
0
votes
0answers
28 views

Web UI for SQL like ArangoDB

I recently came across ArangoDB and I really like the GUI. It is simple, intuitive and powerful. Now, I don't really need or have time to learn nosql but could use something like it. Is anyone aware ...
0
votes
0answers
9 views

Specific data was not retrieved from RDS database

I have uploaded my laravel application on AWS, the site loads fine but no data is retrivied from RDS. Only one table in a page are working well. I would like help and ideias for configure database in ...
0
votes
1answer
132 views

Integrate Apache Drill with Apache Superset

I installed Apache Drill through the link in the Drill Documentation. Apache Drill works fine. I also installed and got Apache Superset running using docker. Superset also works totally fine. But my ...
0
votes
0answers
663 views

SQL Developer on MAC - Test failed: no ocijdbc18 in java.library.path

I am new to using MAC and trying to connect an Oracle database with SQL developer but I have some issues. When trying to test my new connection (Database Type: Oracle, Connection Type: TNS) I get the ...
0
votes
1answer
48 views

AutoComplete menu Manipulation in Microsoft SQL Server Management Studio 18.2(2019)

when writing a query And Autocomplete menu Appears, is it possible to go up or down on the list without using the arrow keys? they are so far away from where my hands are. maybe by a key near the ...
0
votes
0answers
40 views

GNUCOBOL with embedded sql runtime error : module 'OCESQLConnect' not found

I am currently trying to run a cobol pgm with embedded sql that calls database in postgresql. I am running (GnuCOBOL) 2.2.0 on cygwin. I have followed steps in https://github.com/opensourcecobol/Open-...
0
votes
0answers
6 views

Disconnect from Reshift on SQLworkbench J

I am using SQLworkbench J to connect to redshift server. During the connection the team realized that the connection stayed alive for long period of time even when not queried. Is there a way to ...
0
votes
0answers
36 views

Procedure sp_xp_cmdshell

Getting the following message when I run my stored proc... can anyone get me around this? Msg 229, Level 14, State 5, Procedure sp_xp_cmdshell_proxy_account, Line 1 [Batch Start Line 0] The ...

1
2 3 4 5
12