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.
575
questions
51
votes
8
answers
104k
views
Is it possible to open a SQLite database from within Microsoft SQL Server Management Studio?
Is there a way to open a .db file (SQLite database file) from within Microsoft SQL Server Management Studio?
Right now we have a process that will grab the data from a Microsoft SQL Server database ...
- 1,111
33
votes
21
answers
48k
views
Querying a CSV file
Does anyone know of a simple tool that will open up a CSV file and let you do basic, SQLesque queries on it? Like a graphical tool of sorts, one that is easy to use.
I know I could write a small ...
- 2,342
26
votes
6
answers
39k
views
Where can I obtain the SQLpackage command-line utility?
I am trying to use the SQL Package command-line utility (sqlpackage.exe) on a SQL Server, but I cannot find it anywhere online.
Is it something that I can download as a standalone utility, or is it ...
- 423
23
votes
2
answers
34k
views
How to open several tables in different tabs in SQL Developer
I have several schemes and need to open different tables in different tabs from different schemes at the same time.
SQL Developer opens the table view in the same tab.
Clicking whilst holding Ctrl ...
- 745
22
votes
3
answers
159k
views
Run an SQL Query With a Parameter from Excel 2007
I have a query in an Excel table. I followed this to do it.
But how can I add a parameter from a cell into my query?
I am looking for a way to do this:
select *
from dbo.Customers
where CustomerID ...
- 6,726
21
votes
7
answers
26k
views
Search via all Skype history
How to search given string at all chat histories?
СTRL+F - search inside one chat, but I have a lot them, so I want find something in all saved chats?
- 313
18
votes
6
answers
272k
views
How to open sql file as a table?
Someone gave me a file with extension sql, but I don't know what should I use to open it. I can open it with a text editor, but I would like to view it as a table. Is there any software that can do it ...
- 318
18
votes
8
answers
32k
views
SQL management studio hangs when opening after being closed down on dual screen
I have a dual screen set-up. I'm running windows 8.1. I have had this issue with Management studio 2008 R2, 2012 and 2014.
If I drag the management studio screen across to my 2nd display, and then ...
user218317
12
votes
6
answers
172k
views
How do I start a MySQL server on Windows?
I've installed a MySQL server onto my computer and when I first installed it, it ran automatically. Now I've restarted my computer it is no longer running. What file do I need to run to get it back up ...
- 256
11
votes
2
answers
2k
views
How to find which senders use the most space in my Gmail account?
How could I sort email senders (distinct "from" addresses) by the total amount of space each sender's cumulative messages (including bodies and attachments) are occupying in my Gmail account?...
- 113
11
votes
1
answer
26k
views
When will SSDT-BI be available for Visual Studio 2015
From Microsoft's download page, SSDT-BI (SQL Server Data Tools Business Intelligence) for Visual Studio 2013 is available but not for 2015. When will Microsoft release SSDT-BI for VS 2015?
https://...
- 1,305
8
votes
5
answers
11k
views
MySQL - "Root Element is Missing"
Something has happened to the MySQL server installation on my computer. Normally, the MySQL notifier program, which is supposed to start automatically and run in the system tray has stopped starting ...
- 5,568
8
votes
2
answers
50k
views
How can I make Excel fetch data from a database automatically when I open the spreadsheet?
I want to have an excel spreadsheet, that when it opens will automatically populate from a SQL database, using specific queries. Each Workbook would use a different query (or multiple queries). ...
- 2,680
8
votes
1
answer
460
views
Identify SQL time format
I found this representation of a date (and time?) in an SQLite database. I don't recognize it as anything standard like UNIX timestamp, can anybody help me to identify it?
498586831.475129 or ...
- 876
8
votes
2
answers
52k
views
Dynamically filtering data before importing from SQL Server in Excel
I'm trying to figure out whether there is a way to filter the data from an SQL Server connection before it is imported into Excel. The initial import doesn't matter (when the connection is set up), ...
- 93
7
votes
14
answers
37k
views
PostgreSQL Install Fail in Windows 10 (icacls error / access denied)
I am getting the following error when trying to install PostgreSQL on my Windows 10 Machine (x64). Can anyone help me troubleshoot? Many thanks! Error screenshot below:
https://i.sstatic.net/bvOGU....
- 71
7
votes
2
answers
7k
views
SSMS 2018 shows splash screen then closes
We installed SQL Server Management Studio 2018 (v18 GA) on a Server 2012. The SSMS program presents the splash screen then closes immediately. After reviewing the logs, there isn't any entry in the ...
7
votes
2
answers
29k
views
How do I check for SQL injection in cookie?
I am using sqlmap to test my website for vulnerabilities. However rather than testing for vulnerable variables in URL, I would like to test if cookie values are subject to SQL injection. Is there a ...
- 73
6
votes
3
answers
7k
views
How do I run multiple instances of SQL Workbench on Windows?
I use SQL workbench (not mysql-workbench) to connect to Redshift clusters. I might need to query tables from different clusters at the same time. Since one instance can only be connected to a single ...
- 61
6
votes
1
answer
18k
views
How can I get sql server profiler installed
I have Sql Server 2008 R2 installed. But in Management Studio, under Tools menu, I don't see Profiler. What feature do I need to install in order to get profiler?
- 221
5
votes
3
answers
3k
views
How to use Microsoft SQL Server 2008 as a simple database for testing
As a student, I get Microsoft SQL Server 2008 R2 for free through MSDNAA. I installed it, but I seem to be at a loss for how to use it to test database queries, and how to construct a database with ...
- 51
5
votes
4
answers
12k
views
Login to Oracle database without username and password
I want to login to a database by running an SQL file from a Unix script without supplying username and password (as root). Is this possible?
The database is Oracle.
- 51
5
votes
2
answers
8k
views
SQL Server Management Studio print in color
I am using SQL Server Management Studio 2012. I am trying to print a stored procedure in the color-coded syntax that it loves showing me, but cannot find an option to enable this. Any ideas?
I know ...
- 439
5
votes
1
answer
8k
views
how to connect to pervasive sql through odbc?
I am trying to add a linked server to a sql server 2012 database using ssms 2012.
the linked server is pervasive sql. here's how i am trying to do it:
EXEC sp_addlinkedserver
@server = 'kslap208'...
- 733
5
votes
1
answer
843
views
Can I change GROUP_CONCAT Limit in SQLite?
I am thinking about switching from MySQL to SQLite,
but in the MySQL Server I set the variable group_concat_max_len = 1000000;
Before I switch everything to the SQLite engine I want to know if there ...
- 83
4
votes
1
answer
4k
views
SQL Installation hanging on windows 10
I've tried installed every version of SQL Express I can get my hands on (And I've got the MSDN SQL 2016 CTP 2).
Everythings hangs, and always at this point.
I've a feeling its a .net related issue ...
- 151
4
votes
3
answers
12k
views
How to export data from Excel to SQL Azure?
I know how to import data from SQL Azure into Excel
From Excel go to:
- Data
- From Other Sources
- From SQL Server
I want to manually edit data and post it back to SQL Azure. What is the ...
- 375
4
votes
2
answers
13k
views
Event log warning Registry setting specifying configuration file does not exist
Microsoft SSIS Service:
Registry setting specifying configuration file does not exist.
Attempting to load default config file.
For more information, see Help and Support Center at http://go....
- 141
4
votes
2
answers
5k
views
Can I use SQL to build an Excel data table from other Excel files?
I know SQL well enough to perform basic queries and manipulate data split into multiple tables in a database. I know Excel 2007 a bit better and use it frequently to manage my mechanical engineering ...
- 3,157
4
votes
1
answer
6k
views
Running multiple SQL files at once
I feel like I've run commands like the following in the past, but I'm getting an error trying it right now. Maybe I'm just having a brainfart, and my syntax is off.
mysql -u root -p db_name < *....
- 1,299
4
votes
2
answers
21k
views
"Edit" command in SQL Developer
In Toad, you can use
edit tablename where ...
and then simply edit the data in DB. Is there any equivalent in Oracle SQL developer?
- 41
4
votes
2
answers
19k
views
I am using DBeaver and go the error 'FATAL: database "postgres" does not exist'
I was using DBeaver and all of the sudden, I could no longer access my previous PostgreSQL databases or create new ones. I got the error 'FATAL: database "postgres" does not exist' when trying to open ...
- 41
4
votes
1
answer
5k
views
How do I fix a corrupt calendar cache?
I was tailing /var/log/system.log and noticed a sudden wall of text. Looking closer, I saw it was an error CalendarAgent got while trying to save something:
Nov 18 11:42:45 rainbow-dash.local ...
- 2,398
4
votes
1
answer
10k
views
Can not find port in netstat for a specific PID in tasklist
I have trouble finding the port for a running SQL Server (SQLEXPRESS):
The command tasklist in CMD shows PID = 3376 for sqlservr.exe.
It's the same PID as in the Properties of this SQL Server (...
- 207
4
votes
1
answer
2k
views
How to associate visual studio 2012 with SQL files in Windows 8?
I'm using Windows 8 and I'm trying to make Visual Studio 2012 the default program with which to open my .sql files.
I have right-clicked on a .sql file and chosen: Open with... > Choose default ...
- 1,260
4
votes
1
answer
2k
views
Excel VBA : SQL query handles error
I have SQL that I can use in Excel 2013 to get the info from the Access database and it works using the SQL directly in a connection, but now I want to run it from VBA instead so I can use some ...
- 41
3
votes
10
answers
2k
views
Warm-up .NET application
We have speed problems in corporate enviroment.
Most of the notebooks are strongly loaded: the start-up time of Excel is 3-5 minutes, Outlook 10-15 minutes etc.
Our application has the same start-up ...
- 185
3
votes
5
answers
6k
views
Excel formula - querying a Range that results a Range
I have a Range in Excel (B3:C8) from which I want to filter out the English persons. In SQL this would be dead simple:
SELECT Persons FROM [myTable] WHERE Nationality = 'English'
How can I apply a ...
- 293
3
votes
2
answers
2k
views
How to properly delete all page content in MediaWiki?
I found this page that explains how to delete all pages in MediaWiki but I'm not at all convinced that running DELETE FROM page; is a good idea. The MediaWiki schema is pretty complex and just ...
- 2,829
3
votes
1
answer
198
views
SQL import size
I'm in the process of importing a couple of SQL dumps into my own mySQL server. The size of these dumps, from Wikipedia, are 2.3 GB and 22 GB. Is the size of an SQL dump file approximately the same ...
- 281
3
votes
2
answers
4k
views
excel - generate a username from a full name field
I'm trying to generate a username using a single name field in excel which has the person's first name and last name. I'm open to what the username would be, as long as its intuitive for the user. The ...
- 237
3
votes
2
answers
39k
views
How can I get a list of fields AND respective tables used in an MS Access 2010 database?
I know this is how you get a list of all the tables in the database (and more if you modify the critieria:
SELECT *
FROM MSysObjects
WHERE (((MSysObjects.Type)=1) AND ((MSysObjects.Flags)=0));
But ...
- 257
3
votes
2
answers
2k
views
How to flush Firefox storage SQLite database files to eliminate large SQLITE-WAL files?
I've noticed that the WAL (Write Ahead Log) files (*.sqlite-wal) associated with the SQLite databases (*.sqlite) used by the Firefox web browser often get quite large. They literally can get over 150 ...
- 8,439
3
votes
1
answer
8k
views
Append a record's field value with a string in MS Access SQL
I would like to run a query that updates a field's value with whatever is already there but with an "n" appended in the end.
For example say there's a field called AccountNumber and for a certain ...
- 391
3
votes
3
answers
20k
views
Real-time graphing application for SQL data [closed]
I am looking for a free data graphing application that can pull data from MySQL and display it on a trend graph without any programming. It should use a GUI to select the data to be plotted, start ...
- 31
3
votes
2
answers
3k
views
SQL Server 2012 bare minimum config for normal usage?
I would like to install SQL Server 2012 with the bare minimum required. I just want a local database and to be able to create/edit/query tables/write queries in the GUI editor.
Which of the ...
- 31
3
votes
3
answers
732
views
opening sql file hangs most of the editors but not notepad++
I sometimes need to modify url in big sql files. I usually open it up in some editor and do search and replace. On windows machine notepad++ works perfectly, it never hangs and feels snappy to show ...
user98645
3
votes
1
answer
8k
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: ...
- 385
3
votes
1
answer
6k
views
Convert DateTime with Decimal Time Longer Than 3 digits?
I'm trying to import some data from CSV into MS SQL 2008 Server. I'm using PowerShell's Invoke-SQL, and an SQL script that utilizes BULK INSERT.
CSV fields get imported as VarChars and I'm trying to ...
- 113k
3
votes
1
answer
74
views
SQL Result to excel file
In Microsoft SQL Service Management Studio, there is an option to send results to file when a query is executed.
Is it possible for that result to be changed to excel format?
Are there other ways to ...
- 199