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.
576
questions
1
vote
1
answer
3k
views
mysqldump not on wamp server
I am trying to use mysqldump on my wamp server mysql console however, it doesn't seem to have mysqldump included. I found the mysqldump.exe file in this location:
/cygdrive/c/wamp/bin/mysql/mysql5.6....
1
vote
1
answer
448
views
Windows 8 & Server 2012: SQL Server Connection Delay
When connecting from a Windows Server 2012 or Windows 8 box to a SQL Server machine, it takes 2 sec to open a SQL connection and .5 sec for any SQL command to execute. Connecting to the same SQL ...
1
vote
1
answer
552
views
Upload .SQL Files to Wiki
Changes to my team's database are recorded in our internal wiki. Currently, in addition to a brief description, the .sql scripts are added as text. This is becoming bulky and making the page difficult ...
1
vote
1
answer
1k
views
How to input date range in word for SQL query?
I have an Excel file that uses an SQL query to pull inventory usage of the medications in our pharmacy over a period of time.
I currently just have to go to Data > Connections > Properties > ...
1
vote
1
answer
162
views
How to create a condition clause using a current computer time
I have an SQL View which contains a column with dates of the '2012-06-21 19:44:50.543' format. I need to entre the condition to show only lines with dates starting from the beginning of the previous ...
1
vote
1
answer
8k
views
How to run a SQL select query in Oracle database through a shell script?
I need to run a SQL select query in an Oracle database and have to capture the list of retrieved records in a shell script. Also I would like to modify the query for certain conditions and need to ...
1
vote
1
answer
662
views
Display corrupted with repeated scrollbar in SSMS Microsoft SQL Server Management Studio
Microsoft SQL Server Management Studio (SSMS) corrupts the display results and query window in both versions 2005 and 2008 as shown in the screenshot. It seems like the window drawing / re-drawing ...
1
vote
1
answer
2k
views
deleting a row in dbvisualizer
I would like to delete this one in the db visualizer and not sure if I am writing the correct syntax:
I also see that the idsapusertype 25 is also linked to idsapusertypedetails 75 and 76.
Can I use ...
1
vote
2
answers
2k
views
SQL authentication not authenticating in MS SQL Server 2008
When I try to connect to the SQL Server running on localhost using Windows Authentication in SQL Server Management Studio, I am able to connect but when I try to connect using SQL authentication, it ...
1
vote
1
answer
4k
views
How to solve The following signatures couldn't be verified because the public key is not available: NO_PUBKEY EB3E94ADBE1229CF
I am trying to install SQL server on Linux using Ubuntu from this link: https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver16&tabs=ubuntu2204
And, in ...
1
vote
1
answer
730
views
How to test in VSCode a postgreSQL SQL expression in Python's interactive notebook (= Jupyter Notebook, iPython) in a venv with package manager conda?
How to test in VSCode a postgreSQL SQL expression in Python's interactive notebook (= Jupyter Notebook, iPython) in a venv with package manager conda?
1
vote
1
answer
220
views
Search the contents of a SQL file without extracting it from an archive
I have a 128GB .sql file that's located in a .7z archive.
For reasons of storage space, I can't extract the file.
Is there any way to search for a specific line within that .sql file, without ...
1
vote
1
answer
179
views
Combine one set of time series data with another when some dates are missing in one data set
I have a LibreOffice Calc spreadsheet which contains two sets of time series data e.g.
|Date-A |A | | | |Date-B |B |
|2020-01-01|101| | | |2020-01-01|201|
|2020-01-02|102| | | |2020-01-02|202|
...
1
vote
2
answers
2k
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 ...
1
vote
3
answers
4k
views
How to determine the Server Name after installing SSMS v18?
I have just installed Sql Server Management Studio v18. In launching for the first time, the Server Type "Database Engine" appears automatically (which is fine).
However, I do not know the ...
1
vote
3
answers
15k
views
Oracle: How to export/dump a table with blob data in a plain text .sql?
I am trying to dump a database whose one of its tables have a BLOB field.
I tried SQL Developer and toad but none of them was able to generate "insert into" including the binary data like a ...
1
vote
1
answer
22
views
SQL query to find 3 consective records and rspective data
Need to pick the data where values are >=0.7 and appearing at least 3 consecutive times then
hourly recorded per day
Hours 00 0100 0200 0300 0400 0500
ValueNumber .7 ...
1
vote
1
answer
2k
views
SQL Sever Management Studio 2008 does not let me back up my database
I tried to back up a server I created in SQL Server, but I received the following message:
TITLE: Microsoft SQL Server Management Studio
Backup failed for Server 'LAPTOP-6D0L83DV\SQLEXPRESS'.
...
1
vote
1
answer
5k
views
How to change edition of SQL 2012 from express to standard
I have a Windows Server 2012 R2 Standard that is running SQL 2012 Express.
How do I go about changing it to be SQL 2012 Standard?
I have the media (and ISO image) and it is currently mounted.
I ...
1
vote
1
answer
2k
views
Azure SQL connection check
I want to build a database connection test for my CircleCI pipeline, this database is located on Azure and I've found out that pinging this server won't work.
How can I build a test in my CircleCI ...
1
vote
1
answer
247
views
PHP Query to SQL Server through IIS 7.0 on Windows Server 2008 R2
So I am building a webpage on my Windows Server 2008 R2, I have IIS 7 configured to work on the intranet so I can access the site locally from any machine within my Active Directory/Local Network. ...
1
vote
1
answer
987
views
Using SQL to merge .xlsx file and over 1,000,000 rows?
I'm having trouble with an operation that I believe is limited by the shear size of the data - the operation is a merge and filtration of two Excel workbooks, each with over 1 million rows.
Perhaps ...
1
vote
1
answer
237
views
Add column in SQL
I am currently learning SQL, and my current question is. Is it bad practice to have the word "COLUMN" after add when you want to add a column in SQL code?
ALTER TABLE FICTION
add COLUMN Best_Seller ...
1
vote
1
answer
601
views
Sorting in SSRS 2008
I am trying to sort a column from largest value to smallest in SSRS 2008. These values are derived from an expression, not an actual data field. So I am wondering if there is a way to sort this ...
1
vote
1
answer
2k
views
Dynamic data sheet combined with one static
I am using a sheet in excel which pulls data out automatically SQL from a database. Fills in maybe 20 or so columns with orderinfo.
In column A i have a unique order no.
What i want to achieve is ...
1
vote
1
answer
4k
views
Is there any chance Workbench has a case sensitive setting for Queries?
So I have been using MySql workbench for an online database I was able to set everything up but to my suprise and my boss' amazement, Workbench was actually case sensitive. We wrote two select ...
1
vote
1
answer
5k
views
Why can't I connect to my local SQL Server Express (2014)?
After I installed Microsoft SQL Server Express (2014) on my local computer (for testing while building a web interface which uses databases), I could connect just fine, but for some random reason, now ...
1
vote
3
answers
29k
views
Microsoft SQL. SELECT FROM WHERE query with varchar type column
Inside the SQL Server Management Studio I am trying a query like this:
In human words:
Give me all rows from the table where the string in the column "name" is "alice".
My not working attempt on ...
1
vote
1
answer
108
views
Is it possible to access any databases other than MySQL using phpmyadmin?
I heard that phpmyadmin is a GUI used to access MySQL DB. I wish to know whether any other databases are compatible to work with phpmyadmin.
1
vote
1
answer
811
views
Missing arguments in SQL 2012 command line installation
I am new to SQL installation through command line.
We are developing an application and using Installation Shield.
I need to install SQL server on clients pc, so I am using command line silent ...
1
vote
1
answer
110
views
excel / open office - append an incrementing value to all non-unique fields
I have a large table of about 7500 store names. I need to search through those names and, if they are not unique, append an incrementing value, for example:
store_1
store_2
etc.
Anyone know how to ...
1
vote
1
answer
1k
views
How to use the current date as an argument?
I have a batch script which extract SQL data to CSV file:
bcp Database.dbo.MyTable out C:\Reports\Output.csv -s ServerName -T -c
I need the name of the output file to contain the current date.
For ...
1
vote
3
answers
666
views
PHP / SQL development environment on USB flash drive (OS independent)
I am looking for a way to set up a development environment for web applications (using PHP and either MySQL or SQLite) on a USB flash drive: that means at least a web server, a database manager and ...
1
vote
1
answer
5k
views
Upload sql database to remote server using Terminal on Mac?
I have a large local SQL database. When I try to upload the file to the remote database I get a message saying the file is too large.
My hosting provider told me I need to upload the SQL database to ...
1
vote
1
answer
2k
views
Notepad++ opening sql files with characters not text
Initially when using Notepad++ it was opening my sql files no problem as text so that I could edit them, now it's opening them and showing characters instead of text for example;
"‚©§*ÐÊçrQ™êÃÔ ¬™;...
1
vote
0
answers
39
views
Is SQL a good way to optimise data access to just one huge table?
TLDR; Is SQL the way to go when trying to access one huge data table?
As title. In astronomy we often must deal with huge data files. Usually, we can manage to do it using different optimisation ...
1
vote
0
answers
123
views
influxDB v1.8 : InfluxQL : Continous Query in a bash script
I wrote a bash script for inserting the summary of the daily energy database "xxx_d" into the monthly database "xxx_m" - triggered on every 1st day of the month at 02 o'clock by a ...
1
vote
0
answers
254
views
Is it possible to connect a SQL file in VS Code to a .mdb database in MS Access?
Is it possible to connect the .mdb database file open in Microsoft Access with a .sql file that you edit in Visual Studio Code?
I want to be able to create seperate queries in a .sql file that I edit ...
1
vote
1
answer
1k
views
SQL Can connect by server name but not by instance name
I just install SQL 2017 in two servers with default options. I also have configured the cluster role in both servers and activated the Allways On option.
Testing the enviroment before beging creating ...
1
vote
1
answer
2k
views
How to find a character in a string using Powershell?
Using Contains to find a value using PowerShell is not working.
Full Story:
I have to get the PartNo, Ver, and Rev values from an SQL DB, and check if these values occur in the first line of the text ...
1
vote
1
answer
3k
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, ...
1
vote
0
answers
332
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
0
answers
168
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
0
answers
1k
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
0
answers
70
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
vote
0
answers
4k
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....
1
vote
1
answer
398
views
Syntax for SQL IN when using Excel database connection
I'm using a number of Excel files to connect to an SQL Server database, fetching sales data for a particular product number which is specified in a cell in the Excel sheet.
This was set up by ...
1
vote
0
answers
323
views
SQL Server 2017 - Support for old SQL Server ODBC Driver (SQLSRV32.dll)?
I have a legacy application that currently uses an ODBC connection to an instance of SQL Server 2008. However, we are migrating to a new server running SQL Server 2017. It seems I am not able to ...
1
vote
0
answers
39
views
Is it wrong to import an sql file like this?
I was trying to import the the known database "northwind" to my workbench via mysql command line. I just copy-paste the database and it seemed to be working.
I execute the command 'show databases' and ...
1
vote
0
answers
35
views
Kylin derived dimension is empty
I’m using apache-kylin-2.6.2-bin-hadoop3, in Insight query, I find derived dimension column is always empty in result. But using the same SQL in hive shows that the column has value. The SQL like:
...