Super User Stack Exchange
Super User Stack Exchange

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.

577 questions
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
  • 1
  • 2
  • 7
7
votes
2 answers

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 Event Viewer; I suspect that it's closing…
Smithers the Wizard
  • 71
3
votes
1 answer

IO Error: The Network Adapter could not establish the connection : Vendor code 17002

I have installed ORACLE SQL on my Manjaro Linux. But after restarting my PC getting below error in SQL developer: An error was encountered performing the requested operation: IO Error: The Network Adapter could not establish the connection Vendor…
Animesh Koley
  • 31
  • 1
  • 1
  • 3
2
votes
1 answer

Sql based on dynamic where condition

I have a query, in this there are multiple conditions based on parameter select a,b,c,d from xyz where case p='Closed' then (q-r)=0 case p='Pending' then (q - isnull(r,0) )>0 case P='All' then all records to be display It gives Incorrect Syntax…
curious K
  • 23
1
vote
1 answer

Handle Multiple entries in Fact table in Data Cube

We have been constructing data cube for our project in which we are facing a problem like 1 to many relationship in the dimension tables and making entries in fact table (duplication). EmployeePersonalInfo Table: …
selva
  • 133
1
vote
1 answer

How to select first NOT NULL Value?

Eg : Table COL1 COL2 COL3 ADAM NULL AAA NULL EVE BBB NULL NULL CCC How to select first NOT NULL value? Please suggest. Thanks!!!
user408568
  • 33
1
vote
0 answers

50.000 rows created when querying small table in google sheets. Working as designed or bug?

Querying a small table (11x4 cells), results in sheet expanding to 50.000 rows. Is this expected behaviour or a bug? Shared example spreadsheet here. Spr is read-only, because experimenting with this will quickly create more than 1 million cells. To…
Jack Rambling
  • 27
1
vote
1 answer

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 this one? delete from sap_user_type_details…
tintincutes
  • 1,237
1
vote
0 answers

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 methods inside Python. However, RAM inevitably runs…
condosz
  • 111
1
vote
1 answer

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 datasbase, i try to connect with SQL Management…
RAN55
  • 53
1
vote
0 answers

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 Microsoft Internet Explorer …
MountainMJ
  • 11
1
vote
0 answers

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: select trans.user_id, user.tag1 from trans inner…
user1068169
  • 11
1
vote
1 answer

How to move the "find" box in SQL 17?

Apologies if this is out of bounds since it refers to programming, but it's not really a programming question. I recently upgraded to SQL 17 and I can't work out how to move the "find" box (Ctrl + F, etc). The old "find" box could be dragged…
Statsanalyst
  • 127
1
vote
0 answers

SQL History in SAP HANA Studio

Is there is possible to retrieve the SQL History in SAP HANA Studio? If so where? So far I didn't find in in the menus. Neither did an internet research result to a solution. The only work-around I have in mind is to use either SQuirreL Or is there…
Thorsten Niehues
  • 1,741
0
votes
1 answer

null values aren't returned unless specified - Oracle SQL

When attempting to run a select statement that simply excludes some data, null values are wrongfully (?) being excluded as well. Using table a: ID NAME 1 Foo 2 Bar 3 (null) The following statement: select * from a…
root
  • 3,730
1
2 3