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

0
votes
1answer
19 views

How to restore MS SQL logon password

I am running MS SQL Server. The SQLSERVICE logon password was changed incorrectly and now I'm getting a logon failure warning when starting it. Is there any way to restore previous used password?
1
vote
1answer
11 views

Invalid field count in CSV input on line XX in phpmyadmin?

I have a 16MB CSV file with 50,000 lines that I want to import into my database. I go to the PHPMyAdmin-Interface, choose IMPORT and set the correct options. The import fails with the error Invalid ...
0
votes
1answer
8 views

Error when trying to SET field in MySQL

I am trying to set the field block, in the table h8cyw_users, to 1 where the email field in both tables are the same. I am using the following script: UPDATE UPDATE table1 SET block='1' WHERE email ...
0
votes
1answer
22 views

Is there a database that speaks pure SQL?

My understanding is that SQL is the standardized basic framework for quite a variety of different SQL flavors like MS SQL, MySQL, PostgreSQL, ... But all of these different flavors introduce a ...
2
votes
3answers
76 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
17 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
59 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
1answer
28 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
44 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
2answers
28 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 ...
1
vote
0answers
18 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
28 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
13 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
46 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
45 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?
1
vote
0answers
21 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
207 views

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

Thanks for your help, @FreeMan. However, I am still lost with this. Let me just start from scratch. This is my query in summary ( I hope it is clear) SELECT DISTINCT Q1,Q2,Q3 from(SELECT A,B,C) ...
1
vote
0answers
28 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
89 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
65 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
62 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
24 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
35 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
49 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
103 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
21 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
42 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
56 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
8 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
111 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
37 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
101 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
59 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
462 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
90 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
96 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
216 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
32 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
188 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
60 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
221 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
662 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 ...
4
votes
0answers
357 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
88 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
157 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
125 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
34 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
51 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
36 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?