Structured Query Language, or Structured Query Language or SQL is a declarative query language for relational database.

learn more… | top users | synonyms

0
votes
1answer
36 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 ...
1
vote
1answer
10 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 ...
13
votes
2answers
75k views

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 ...
0
votes
1answer
22 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 ...
-1
votes
0answers
17 views

Struggle to get SqlSrv to work on Windows 2012r2

I need to connect to a SQL Server database from PHP. I'm given a Windows 2012r2 machine and installed XAMPP on it and then continued to copy php_sqlsrv_56_nts.dll into php/ext and modified my php.ini ...
0
votes
1answer
22 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
4 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
18 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
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 ...
-3
votes
1answer
32 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?
0
votes
1answer
155 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. ...
-1
votes
1answer
55 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
55 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
1k views

Append a record's field value with a string in MS Access SQL

I would like to run a query that updates a field's value with whatever is already there but with an "n" appended in the end. For example say there's a field called AccountNumber and for a certain ...
0
votes
1answer
46 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
0answers
544 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. ...
1
vote
1answer
47 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
63 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
18 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
vote
3answers
44 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 | ...
-1
votes
1answer
92 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?
4
votes
4answers
43k views

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

Windows 8 & Server 2012: SQL Server Connection Delay

When connecting from a Windows Server 2012 or Windows 8 box to a SQL Server machine, it takes 2 sec to open a SQL connection and .5 sec for any SQL command to execute. Connecting to the same SQL ...
0
votes
0answers
104 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
1answer
112 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 ...
1
vote
2answers
969 views

How to swap first and last names in MS Access

I have an Access database where a column of fields contain names where the first name is first and the last name is last. Id like to be able to swap then around so they are Last name first, first name ...
0
votes
1answer
2k views

How can I specify rules for foreign keys in Microsoft Access using SQL?

I have to create some tables in Microsoft Access using SQL sentences, and some of the tables have foreign keys. I would like to specify the constraints and rules for foreign keys using SQL: Whether ...
0
votes
1answer
332 views

Oracle local database product (like MS Access)

Is there a Oracle, local database product (which I can run on my laptop like MS Access) which is free for developers, and in which I can Create tables, Load data from file, Run SQL (oracle's syntax) ...
0
votes
0answers
12 views

Is there any way I can access an access database I set to read only from other computers on another computer?

Basically I secured the database to only open fully on one system but now I need to change it from another system. Is there anyway I can do this? Thanks Edit: The database is a .accdb I changed the ...
0
votes
1answer
462 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, ...
1
vote
0answers
448 views

“Compacting” a SQL database after deleting records with SQLiteMan

I'm using SQLiteMan to edit/delete Skype message history, as described in numerous guides on the Net. I.e. I open Skype's main.db file in my profile folder using SQLiteMan and selectively delete some ...
-1
votes
1answer
126 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 ...
9
votes
2answers
10k views

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 ...
4
votes
2answers
3k 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
3answers
308 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 ...
1
vote
2answers
9k views

Text values in a pivot table?

I have a table (in MySQL) with 3 columns: Location Category Supplier A Computers Company X A Printers Company Y B Computers Company X B ...
2
votes
0answers
62 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
109 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 ...
3
votes
0answers
973 views

How to associate visual studio 2012 with SQL files in Windows 8?

I'm using Windows 8 and I'm trying to make Visual Studio 2012 the default program with which to open my .sql files. I have right-clicked on a .sql file and chosen: Open with... > Choose default ...
2
votes
3answers
245 views

opening sql file hangs most of the editors but not notepad++

I sometimes need to modify url in big sql files. I usually open it up in some editor and do search and replace. On windows machine notepad++ works perfectly, it never hangs and feels snappy to show ...
0
votes
1answer
86 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
890 views

Sql Server Managmenet Studio Alternative - Are there any?

I am looking for lightweight MS SQL Server Managmenet Studio (2005) alternative (open source/freeware is a bonus). Something more like HeidiSQL for MySQL. LINQPad is not an option (although it's ...
-2
votes
1answer
30 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. ...
-1
votes
1answer
27 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?
0
votes
1answer
79 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
12k views

SQL Server Express 2008 R2 Installation error at Windows 7

I created an install script that will install SQL Server 2008 R2 on Windows XP SP3, Windows Vista and Windows 7. One of the command that I used in the installation is for silent installation of SQL ...
3
votes
1answer
45 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
vote
1answer
464 views

How to input date range in word for SQL query?

I have an Excel file that uses an SQL query to pull inventory usage of the medications in our pharmacy over a period of time. I currently just have to go to Data > Connections > Properties > ...
1
vote
1answer
38 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
24 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 ...