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
vote
1answer
78 views

Is it possible to access any databases other than MySQL using phpmyadmin?

I heard that phpmyadmin is a GUI used to access MySQL DB. I wish to know whether any other databases are compatible to work with phpmyadmin.
0
votes
1answer
34 views

Why do URL parameters pose a security threat?

I know with SQL Injection attacks on the rise, websites have to tighten up on security. I understand that 'Dorks' are usually how they get in. Why does e.g. php?id=x pose a possible threat to the ...
0
votes
1answer
46 views

Sql Server 2012 Replication Report

We have about 30 users with local installs of SQL Server that have to replicate merge their local data once a month with a central SQL Server 2012 repository. Is there a SQL Server first-party or ...
1
vote
1answer
179 views

Missing arguments in SQL 2012 command line installation

I am new to SQL installation through command line. We are developing an application and using Installation Shield. I need to install SQL server on clients pc, so I am using command line silent ...
2
votes
1answer
38k views

Execute SQL Query with VBA and fill sheet with data

Very new to any form of code. Attempting to run a script in VBA that will pull data from an access database using SQL and put it into an excel spreadsheet. Code is similar to below. Runs clean but I ...
-1
votes
1answer
392 views

Missing MySQL Database after Windows Upgrade

First of all, please bear with me as I am quite new to HeidiSQL, MySQL, and the concept of relational databases as a whole. I recently started using HeidiSQL in order to create tables for import into ...
0
votes
1answer
272 views

Microsoft Query in Excel Returning Blank

In this post I was given a solution that relies on the following SQL: SELECT `S1`.DATES , `S1`.NAMES , MAX(`LS`.DATES) FROM `C:LOCATION`.`Sheet1$` `S1` LEFT OUTER JOIN `C:\LOCATION`.`LargerSheet$` ...
0
votes
1answer
658 views

SQL Code Error `Characters found after end of SQL statement`

I have the following SQL code that I am trying to run in Microsoft Query, but I keep running into the error Characters found after end of SQL statement. I understand this might be happening because ...
1
vote
1answer
594 views

Oracle SQL Select: If not exist, leave blank

I have two tables: Table1 [ID] [Number] 1 40 2 100 3 7 and Table2 [ID] [Number] [Name] 1 40 A 3 7 C Data originates in Table1, then gets copied to ...
0
votes
1answer
293 views

SQL Developer 4 Toolbar

Recently my SQL Developer toolbar became messed up. I'm not sure what I did, and I can't change it back. When I got to View-->Show toolbars-->Customize Main Toolbar, it just says ...
0
votes
1answer
38 views

what this datetime is used for in DB query [closed]

I acme across a db query @retVal = (DATEDIFF(s, '19700101', GETUTCDATE()) - dateTime) what this datetime used for ?? n what this query returns
0
votes
0answers
56 views

command for running script?

I was wondering what command would get the batch file to read a seperate text file and use all of that code in a database.. if that didn't make sense I'll do my best to explain: I have a text file ...
-1
votes
1answer
9k views

'sqlcmd' is not recognized as an internal or external command

(I know this isn't really meant for here, but I can't ask questios on Stack Exchange) I'm creating a batch file and I get this error message: 'sqlcmd' is not recognized as an internal or external ...
0
votes
1answer
43 views

Creating tables in SQL [closed]

I'm trying to create a table using SQL and being a beginner I have no idea where I'm going wrong.. This is my code: CREATE TABLE 'test_11' ( `Company_Name` varchar(160), `Company_Number` ...
2
votes
2answers
4k 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 ...
0
votes
2answers
234 views

How to perform sql query on sheets of excel

I have two tables in excel(sheets) . One has 10,000 entries , another has 1000 entries . Both of them have account number column in common . I want to select only those row in 10,000 entries which ...
-1
votes
1answer
377 views

SQL remove everything behind a comma in string [closed]

I have a mysql table storing some data. One column stores strings containing a comma. I want to get rid of everything (including the comma) in this string and save it, but I don't get it to work. I ...
1
vote
1answer
676 views

How to connect to SQL database with Windows 7

I have a third party database program on one of our servers. With Windows XP we simply create a desktop shortcut which starts the application (\apps-server\icad\msassets.exe). When I attempt to run ...
-1
votes
1answer
427 views

getting error in mysql— #1064 error while creating trigger

I need to create a trigger for a table called try.. which will execute after something is entered into the table..(I am using phpmyadmin mysql) But i am getting #1064 error while creating it.. My ...
0
votes
2answers
2k views

How do I connect to some local DB server in MS SQL Server 2012? [closed]

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
0
votes
1answer
55 views

How to create a database from psql user (not linux user)

I' ve studied some PostgreSQL. In the principle i' ve been teach to create a postgress's user with same name of my linux's user. Now i want to try to make an application, and for this reason i would ...
2
votes
1answer
2k views

How to import Dates from Excel into Access with text in some cells?

I am attempting to import a date column from Excel into Access. The problem is that over the years, users of the Excel spreadsheet sporadically inserted text notes into this date column a few ...
0
votes
1answer
24 views

Join 2 mssql queries

I need to join to MSSQL queries, but I am not getting anywhere with this. Both queries return a single value: SELECT COUNT(*) FROM sysjobhistory WHERE run_status <> 1 AND step_id = 0; ...
1
vote
1answer
215 views

Oracle database block diagram or map

I have an Oracle database. It has multiple schemas, and each schema has many tables. Is there a way to generate a tree diagram or block diagram, such as this image, to visualize the database? I ...
0
votes
1answer
1k views

SQL 2012 in Hyper-V. Why are my queries slow until I drop and create any spatial index?

I have a spatial application that queries several tables (layers) each time the user pans/zooms the map. When I moved the SQL server into Hyper-V, I noticed that there was a several second delay when ...
10
votes
6answers
9k 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 ...
1
vote
1answer
34 views

Possibiliy to display results SQL query in windows (monitoring purposes)

Case (one example) #1: Our business application processes documents in the background. Using MS SQL Management Studio I can create/run a query to display results. For example the current queue of ...
3
votes
1answer
3k 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 ...
0
votes
1answer
171 views

Error in installation of SQL Server 2008 Management Studio

I have installed SQL Server 2008 Express on my machine but I can't find the Management Studio. I downloaded two versions of SQL Server Management Studio, 2008 and R2 This is the result I don't ...
0
votes
2answers
887 views

Numbers are not displaying properly in excel report

n excel report generation, numbers are displaying 7.70225E+11 but it should display like 770225145579 . Any one please help to solve this issue. My code is, <?php include("connection.php"); ...
0
votes
2answers
3k views

Can't detach database in SQL Server Management Studio after accidentally deleted mdf file

I'm working with a bunch of *.mdf files which I'm attaching on my local computer. After I accidentally deleted the a folder containing some of the *.mdf files, I'm unable to view the databases in SQL ...
0
votes
1answer
333 views

Can i give foreign key relationships of ODBC tables from ms sql to ms access

I have a question regarding the ODBC relationships between SQL and MS ACCESS as i have migrated several tables from SQL to ms access and i performed some operations but the problem occured in ...
0
votes
1answer
875 views

Is there a function in Excel or Access to reshape a table to First Normal Form, or a way to do it in SQL?

Very often tables are presented in Excel files in a non-normalized form. I have one such table which I wish to take into (somewhat) First Normal Form using either SQL commands in Access or, ...
0
votes
1answer
295 views

Cascade combo box query sorting

I have a question regarding ms access 2007 query sorting for the cascade combo box. As i have initially 3 tables with names country,state and city and i want to have a combo box such a way that if i ...
0
votes
1answer
4k views

Syntax highlighting for sql files on sublime text

I want to install syntax highlighting in my sublime text program for those extensions : .plpgsql .sql .plsql Somebody know how to do it ? I have installed some packages but there was no results. ...
0
votes
1answer
48 views

SSMS query editing: possible to remove a field and have the matching value removed?

I work with large queries in SSMS. It would be fantastic if I could easily match up the comma-separated values with the comma-separated field names. I often delete a field, and then have to hunt for ...
1
vote
0answers
811 views

SQL Server 2008 R2 - Process 6 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process

I am running Microsoft SQL Server 2008 R2 (SP2) - 10.50.4302.0 (X64) (Latest CU11, Feb 2014) on Windows Server 2012 R2. I have a simple database and a website that runs on the same machine using IIS. ...
0
votes
2answers
601 views

Where are Google chrome passwords stored in windows?

I know that Google Chrome stores the login data at LocalAppData\Google\Chrome\User Data\Default\Login Data but this doesn't shows the password, password value shows as the single special character. I ...
0
votes
1answer
36 views

OpenOffice showing syntax eror

Here's what I have so far: SELECT DISTINCT Min("gpa"."current_gpa"), "students"."lastname", "students"."firstname" FROM "students", "gpa" WHERE ...
1
vote
1answer
7k views

What is the difference between MySQL, SQLite and other SQL servers?

I was digging around in my server and I started to wonder what the difference is between MySQL and SQLite and other SQL servers. If anyone can make this clearer, could you also explain if they have ...
0
votes
1answer
348 views

Transpose data at particular row w python,r,sql?

Lets say I've got following data (about 50k of rows in real example) A B C D E X A B C D E F G H X And I want it to look A,B,C,D,E,X A,B,C,D,E,F,G,H,X So technically I want to transpose ...
-1
votes
2answers
577 views

SQL Server Database Encryption [closed]

Let's say two programmers are working on a website for a store. They've created a small database for an online store. Users would have to register and provide a username(e-mail address) password,home ...
0
votes
1answer
172 views

How to access SQLite database?

I have run BinDiff on two binary files, and stored the results in a .BinDiff file. (Which the manufactures assure me is just an SQLite database. How would I open and access this database?
4
votes
5answers
3k 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 ...
0
votes
0answers
57 views

Stanford Wrangler ideal, but imposes limits, what are other options?

Stanford Wrangle tool is quite amazing, and I solved a giant problem with it, but it limits me to very small size. My file is about 500MB, and it allows me to process less than 1MB, the remaining data ...
1
vote
0answers
43 views

Website unable to connect to SQL Server

I have a very specific problem which has been plaguing me for months now. The issue is this: Every once in a while, the website will lose all connection to the SQL Server with the following error A ...
1
vote
1answer
976 views

mysqldump not on wamp server

I am trying to use mysqldump on my wamp server mysql console however, it doesn't seem to have mysqldump included. I found the mysqldump.exe file in this location: ...
0
votes
2answers
5k views

SQL Server 2012 configuration manager not opening in windows 8.1

I run SQLServerManager11.msc in apps to search but nothing happen. Need Help. It is install and showed in control panel.
2
votes
1answer
4k views

Writing typical MySQL query in excel

I'm trying to run a MySQL query in excel. I've set up ODBC in excel and the connection to database is solid. Is there a way to input my usual query (e.g. select * from table where date= 20131212) to ...
0
votes
1answer
470 views

cascading combo boxes and queries in access

I am using access. I have queried a table using a form to trigger the query, with three combo boxes(cascading) the results how ever are not based on the three criteria, only the first. The code below ...