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

learn more… | top users | synonyms

0
votes
2answers
18 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"); ...
-1
votes
0answers
11 views

Is there a software similar to SQL Doctor for Oracle Database [closed]

Is there a software similar to SQL Doctor for Oracle Database? I really like SQL Doctor, but it only works for MSSQL product.
0
votes
0answers
4 views

ORA-01219: database not open: queries allowed on fixed tables/views only [migrated]

I Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting error message as :- ORA-01219: database not open: queries allowed on fixed tables/views only) I looked ...
0
votes
0answers
12 views

Publish a local SQL database to existing database on remote server

I am trying to publish my MVC website with two SQL databases from Visual Studio 2013 Web Express to an Arvixe server. I have followed this tutorial: ...
0
votes
1answer
17 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
23 views

How to repair .mdf file?

My sql databases in SQL Server 2014 has the status "suspend" as I saw in SQL Management Studio. I can't restore to serviceable condition sql databases through standard procedures. I need to restore ...
0
votes
1answer
16 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
0answers
77 views

What services to disable to stop sharepoint in sbs 2011

So, I'm looking to disable sharepoint in sbs 2011. I don't want to uninstall it because I've read that it will cause update errors, but It's throwing a lot of errors itself and we don't use it, so I ...
0
votes
1answer
28 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
35 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
25 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
30 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
82 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
95 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
0answers
15 views

Software for creating DB alter script that ONLY uses DDL scripts

I am looking for a software which can compare two databases by ONLY using DDL script (i.e. I dont want to create a schema but rather do it on the fly). Is this possible ? Any ideas ?
0
votes
1answer
11 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 ...
0
votes
0answers
16 views

Automatic regenerating of report on update excel document

I have one file in xls format in Excel program. Usually I upload this data to sql in some created table, and regenerate the report, then export it. Sometimes it is updated through svn and I need to ...
0
votes
0answers
15 views

Change data source from SQL to local worksheet in Excel

We have some PIVOT table which connects to SQL data base table. Now I want to change the data source of that PIVOT table to worksheet which has same sql table data. But When I click Change Data ...
1
vote
1answer
250 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
84 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
73 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 ...
4
votes
1answer
49 views

Copying out color theme background from SQL management studio to Outlook

I have a color theme set in SMS 2012, where the background is dark and some of the syntax is white, when I copy and paste this out into an email (white background) the dark background of management ...
0
votes
1answer
43 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?
0
votes
2answers
208 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
35 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
25 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
102 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
1k 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.
0
votes
0answers
11 views

SQL server- Solid state hard drive transfer

I have a 4TB hard drive that contains my current database. Is it possible to allow my solid state to act as a buffer between HD and RAM? Other option- Is it possible to allocate my entire Solid state ...
0
votes
1answer
120 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
87 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 ...
0
votes
1answer
31 views

SQL : swap 2 values in a column without using an intermediate value

Given a table with a single column containing only 2 values, say 'A' and 'B', is there a way to swap them in a single statement Ex: A B A B to B A B A It is a trivial process if we use a bit ...
0
votes
0answers
30 views

Accessing the columns of a form in an sql query

i have table I would like to query the data using a form which has three columns but with the code below i can only access the first column. the three columns i wish to include are - course_no, ...
1
vote
0answers
207 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 ...
0
votes
0answers
51 views

Cannot open SQL files in VS2010 on Win7 x64

If I try to open SQL files in Visual Studio 2010 on Win7 x64, VS just hangs and I have to kille the process. This is happening with both local files and files on TFS. I have no problem with opening ...
0
votes
0answers
76 views

Using SQL to join spreadsheets in excel

Based on the explanation here: How do I join two worksheets in Excel as I would in SQL? I tried to join two excel sheets from different files into the same sheet. However, I keep getting this error ...
1
vote
1answer
70 views

How can I connect to an InterBase database using Excel?

There is an InterBase database that I'd like to connect to using Excel. I have the database name, address, and login info. IB, as I understand it, is a form of SQL. Using the SQL connect mode under ...
1
vote
0answers
25 views

best way to rename a database field to given pattern if it already exists? [closed]

I have a database table that contains id, filename, userId id is unique identifier filename should also be unique table may contain >10000 records When a user uploads a file it should be ...
1
vote
3answers
1k views

How do I start a MySQL Server in Windows ?

I've installed a MySQL server onto my computer and when I first installed it, it ran automatically, now I've restarted my computer it is no longer running, what file do I need to run to get it back up ...
0
votes
1answer
127 views

Deployment Fail During Generate Star Schema

I am Using SQL Server Data Tools for Visual Studio 2012 for Generating Start Schema.I am using one Database with four Tables.When i am Click on Start Button. I Got This Error The project could ...
2
votes
2answers
236 views

understanding Microsoft Download Center naming convention

The following are the download names for SQL Server Express Editions. SQLEXPR_x86_ENU.exe SQLEXPR_x64_ENU.exe SQLEXPR32_x86_ENU.exe The machine I have is a 32 bit intel machine. Which one should ...
0
votes
0answers
21 views

automatically type the fields when creating a table / loading data from file?

Very often I use mysql and sqlite in an ad hoc manner: quickly create a few tables, retrieve the information I need, then delete the tables beause I will never use them again. I wonder if it is ...
0
votes
2answers
425 views

255 Max character size in Excel cell when cell data is linked/fetch from external data source

I have one bug tracking system which export bug data as Excel file. I would like to create a report based on this exported excel file. what I did is create a office data connection file which link ...
0
votes
1answer
30 views

Scan a SQL Server for Stored Procedures with Dynamic SQL evaluations

Is there a procedure which I can use to scan a database's stored procedures for dynamic query evaluation? This is in the interest in providing some assurance against SQL injection.
0
votes
0answers
38 views

SQL 2005 doesn't let me to copy and paste the a big query result, what can I do?

I am doing a local query through a remote desktop of a server. It is Management Studio 2005 and the result is large. Somehow it doesn't let me to copy and paste the result. -csv format doesn't work ...
0
votes
0answers
9 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
2answers
687 views

Remote access sql server 2005 over internet

I find so many similar question/problem and go through but unable to solve my problem. As so I am repeating the question again. I would like to connect my sql server 2005 remotely over internet. I ...
0
votes
0answers
36 views

How to cancel all sql server jobs without starting ms sql server process

I am using ms sql server 2012, at the midlle of huge query execution, my system crash so i decided to end task ms sql server process. Now, each time i want to start ms sql service my system crash ...
0
votes
0answers
18 views

Is it possible to show several tables in SQLYog at the same time but in different tabs?

For now when I click on some table in tables list on the left the content of that table appears in the Table Data tab on the right. When I choose another table the content of the previous table in ...
1
vote
1answer
111 views

Install sql server management studio API only

I have already installed sql server 2008 R2 , but now i need to install sql server management studio also ( i mean just that API ony ) is it possible to install only this instead of uninstall sql ...