Super User
Super User

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.

SQL is the common programming interface to almost all relational databases, though most vendors implement their own extensions on top of what is defined by the ISO standard, and many fail to implement the standard correctly.

574 questions
51
votes
8 answers

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 and put it into a SQLite database file that will be…
Brian T Hannan
  • 1,131
33
votes
21 answers

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 script to do an import of the CSV into a SQLite…
J. Polfer
  • 2,342
27
votes
6 answers

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 part of some greater software bundle that I have…
nairware
  • 433
24
votes
2 answers

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 or Shift doesn't seem to help. Any ideas?
sergionni
  • 765
22
votes
3 answers

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 = Cell.A2 The Cell.A2 does not work. But how can I…
Vaccano
  • 6,806
21
votes
7 answers

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?
coms
  • 313
18
votes
8 answers

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 close it down, when I open it again, it opens on the…
user218317
18
votes
6 answers

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 without much effort? If not, do you know any…
German
  • 318
14
votes
3 answers

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? I'm thinking something like: Download all my messages to…
MiguelitoCogito
  • 143
13
votes
6 answers

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 and running again? I've tried running MySQL 5.6…
Shaun Wild
  • 266
11
votes
1 answer

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://msdn.microsoft.com/en-us/library/mt204009.aspx
JohnnyO
  • 1,355
8
votes
5 answers

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 up automatically, and instead throws these two…
DaveTheMinion
  • 5,638
8
votes
2 answers

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), but I need Excel to have little to no data when…
Griffin
  • 93
8
votes
2 answers

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). Ideally when it is opened, the connection properties to…
Raymond
  • 2,850
8
votes
1 answer

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 497469155.776235 sometimes however, it is only one number…
Xaser
  • 956
1
2 3
…
38 39