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.

learn more… | top users | synonyms

-1
votes
0answers
10 views

SQL — how many queries is too many? [closed]

I have access to an SQL server to help me complete a project. I am running a loop, looking an element up in the database each iteration. This seems to work just fine and without any slowdown, but I am ...
2
votes
3answers
48 views

Can't include an HTML link in PHP script, but works fine as MySQL query

I'm using the following as part of a PHP script: mysqli_query($con,"UPDATE table SET description='<a href="http://123456.biz/index.php/123/321/456/*/789">text</a>' WHERE description IS ...
0
votes
1answer
12 views

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 ...
1
vote
0answers
41 views

Windows 7 web browser cannot access localhost

I'm using windows 7 and installed xampp, but I can't access localhost from all web browser (IE, Chrome, Firefox), it always give me "ERR_CONNECTION_REFUSED". I already googling it and found many ...
1
vote
0answers
25 views

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). ...
0
votes
0answers
28 views

Remove extra blank line in the bottom of spool file

I am creating a spool file. Problem is that it creates a blank row in the bottom which i do not need. I am running the .sql in windows. Any suggestions? below is the sql : ...
1
vote
1answer
15 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 ...
0
votes
0answers
30 views

Are NOT equal JOIN a standard use? [migrated]

I have a table "Price" that should be filtered according to a value stored in an another table "CutPrice" (meaning only prices inferior to the parameter stored should be displayed). I experimented ...
0
votes
0answers
14 views

Query from SQL not outputting to Excel spreasheet [on hold]

So I'm trying to make a parameterized SQL query within Excel by following this tutorial, http://snippetsandhelp.blogspot.com/2013/05/excel-2013-getting-data-from.html and everything works fine with ...
1
vote
0answers
9 views

Why is sql server native client version “not marked” in odbc data source administrator?

Normally there's a version number in there:
1
vote
1answer
23 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
0answers
10 views

.bad file not generated in SQLLOADER

I am invoking sqlloader from windows batch script. I have a WHEN clause added in control file. Error record generates and log says that .bad file is generated at designated path. However, no .bad file ...
0
votes
0answers
33 views

Is there a lesser code to insert records to sql using ms access vba?

Is there a shorter way to insert records to sql more than 30 fields?I am using MS access vba and Linked tables from sql. Can we Insert records using like this Insert into Mytable Values (more than ...
-2
votes
2answers
35 views

Use of Index in Ms-Access Database

Why does an Index make a query run faster? What does an index do? Particularly in Access, if you declare a column as an index how does it affect the query? Any Ideas?
0
votes
0answers
18 views

MySQL Query to Select All and Convert Date [migrated]

How would I write a query in MySQL to select all and to convert 2 UNIX date columns to something readable, i.e. - from_unixtime(received_date) without needing to manually write out each of the other ...
1
vote
0answers
16 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 ...
0
votes
1answer
99 views

Executing SQL Stored Procedure through Excel (VBA) with multiple parameters

I am a newbie when it comes to VBA and so I am struggling to get my query to run with more than one parameter. I am using this macro as but when I run it it tells me the second parameter has not been ...
1
vote
0answers
23 views

Manual SQL install error

I am receiving the following error when trying to manually install my SQL: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right ...
0
votes
1answer
45 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 ...
0
votes
0answers
50 views

Installation error while Installing SQL Server 2014 Standard Edition

I have tried to install Microsoft SQL Server 2014 Standard Edition and it is giving the error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: ...
-1
votes
3answers
54 views

Repair a corrupt SQL database in SQL 2005

My server crashed. most stuff lost. I recovered the .mdf .ldf files through DaRT. I can not use the files. It advises that the header is corrupt. Please advise what the best way to resolve this ...
0
votes
1answer
21 views

Remove PostgreSQL database files

I've uninstalled PostgreSQL some time ago, but now I needed it again, and installed it. When running rcpostgresql I get the following: /usr/sbin/rcpostgresql Your database files were created by ...
0
votes
1answer
26 views

squirrel sql search all tables and fields - or any software

I want to find a string like "txstate" in a wordpress (or magento, etc) database and it could be in any table or field. Can this be done in SQuirreLSQL? I have searched on this and not getting ...
0
votes
0answers
22 views

SQL: Are Searches Faster at Identifying Distinct Rows If More Attributes Are Tested?

Given a large database table, and the foreknowledge that a unique row with qualities you know is in there, can the row be retrieved faster if more attributes are tested for known values? Or, will the ...
2
votes
1answer
41 views

Accessing a local SQL server 2014 from within a VM running vista using VS2005 fails

My laptop is running Win 7 (x64) and is part of a domain. I've installed SQL Server 2014 Dev and VS2012 on it as I want to use the laptop for development. Since some of my development has to be done ...
0
votes
1answer
78 views

Unable to make ODBC connection on Ubuntu 14.04

I usually access an ODBC connection through a CentOS server, and I'm trying to make the same connection locally on my Ubuntu Trusty laptop. So far as I can tell I've duplicated everything properly ...
0
votes
0answers
19 views

Error to install the SQL Server 2014 Express?

When I am installing the SQL Server 2014 Express, I get three messages saying: Saying the file helpexp.bmp cannot be found in directory ...
0
votes
0answers
35 views

Unable to connect SQL Server 2014 (time out)

I have followed this method (https://www.youtube.com/watch?v=VOUDdUJ5BLY) to set up my SQL Server on my computer A. My Computer B is able to connect to the SQL Server with my public IP within the same ...
0
votes
1answer
47 views

How do I host the PostgreSQL server locally? It won't let me run as SuperUser, and it won't let me log out of SuperUser

I've spent all day working on a Database project to try and teach myself how to use SQL and PHP. When I finally went to go and try to host it, the command prompt kept closing really quickly. I took a ...
0
votes
0answers
7 views

SSMS file tree does not match file tree on drive

I'm trying to add a database to my SQL server using a .mdf file, but the filetree displayed by SSMS does not reflect the filetree on my C drive, so I cannot locate my .mdf file when I try to add the ...
0
votes
1answer
91 views

Import image from MS SQL Database into Excel

I have a MS SQL Database where images are stored as byte[]. Is it possible to import these byte[] into Excel and convert them back into images? I already have a connection to the database in my Excel ...
-3
votes
1answer
36 views

i have three laptops with HD:500gb ,ram:4gb,OS:windows7 is it possible to form a cluster? If notwhy and How can I able to make use of cluster? [closed]

with HD:500gb , ram:4gb , OS:windows7 is it possible to form a cluster? If not why(i need more laptop or something) and How can I able to make use of cluster?
-1
votes
1answer
81 views

How can I translate SQL to Excel formulas?

I have an excel sheet with raw data and I want make a custom view on it in another table for reporting purposes. How can I translate the following pseudo code to Excel? select ColA, ColB, ColC from ...
1
vote
3answers
58 views

Can a database be too relational?

I have a question about database design. I'm asking here because I'm an enthusiast/hobbyist and not a "professional" so I don't want to post it on the "Database Administrators" stack exchange ...
0
votes
1answer
389 views

Microsoft Access Left Join Query Giving “Invalid Operation” Error

Here's the question: I'm getting an "Invalid Operation" error on a LEFT JOIN query and, although I think I can identify the field causing the issue, I can't figure out why and what to do to fix it. ...
0
votes
1answer
74 views

How do I check for command line parameters in sqlplus?

I am trying to write a sql file which will run under sqlplus. My goal is to create a mechanism by which sqlplus will prompt for password if no parameters are passed, and if &1 is present, continue ...
1
vote
1answer
81 views

How to find out MS SQL Server Enterprise Edition Expiration Date?

superusers. Don't blame me for asking a newbie question here :p I have MS SQL Server Enterprise 64bit Install on VMplayer, Version: 11.0.3128.0 Product LVL: SP1 Upon installed, there is ...
-2
votes
1answer
164 views

How to select first NOT NULL Value? [closed]

Eg : Table COL1 COL2 COL3 ADAM NULL AAA NULL EVE BBB NULL NULL CCC How to select first NOT NULL value? Please suggest. Thanks!!!
0
votes
0answers
27 views

How to reset pkuid in QGIS

I have a sqlite layer in QGIS with autoincrementing primary key on. Then if I delete some points I would like the option to reset the number that shows up in the pkuid column. I tried in DB manager: ...
-1
votes
1answer
180 views

Owncloud - where in the SQL database is the email stored?

I am searching and searching but still cannot find it. In what table does owncloud store the email addresses?
1
vote
3answers
55 views

Show All Results From One Table Not Listed In The Other (Junction) Table By :id

I have 2 tables I'm interacting with. The first table: acl_permissions (is just a normal table). +-----------------------------------+ | acl_permissions | ...
0
votes
0answers
195 views

Notepad++ custom folding keywords in existing language

I use notepad for sql code that has "REGION" blocks like the above that I would like to be able to fold -- REGION MODE 3 - DELETE MODE WHEN 3 THEN DELETE FROM EDMX.M1_BRIEF WHERE ID = TID ; SET ...
1
vote
3answers
551 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 ...
3
votes
0answers
323 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 ...
2
votes
0answers
77 views

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 ...
0
votes
1answer
143 views

Import external data connections into Excel 2013 for use in Excel 2003

I have a workbook in Excel 2013 that retrieves data from a SQL database via a query. However, the connection imports data as a table, which is incompatible with Excel 2003. Is there a way to convert ...
1
vote
1answer
111 views

Notepad++ syntax highlighting sql within php file

I love Notepad++, partly because of its syntax highlighting: in a .php file, it will highlight <script> blocks as javascript, <style> blocks as css and <?php blocks as php. Ideally ...
-2
votes
1answer
33 views

SQL Server Management Studio for sql server 2008 [closed]

Is there any other version of SQL Server Management Studio except EXPRESS one? I need one for MS SQL Server 2008 STD version. I've been trying to search almost everywhere, but it seems there is not. ...
3
votes
1answer
48 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 ...
-1
votes
1answer
33 views

What are the differences between LDAP and SQL?

I have read that LDAP is used to store information about users and many other objects. Since this can be done with any databases like SQL, why LDAP is used for this purpose?