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
23 views

Running a query with conditions

i have a system with dew version. any version has 5-9 upgrade scripts. in order to upgrade version 1 to 5 i have to run each script in any version in the correct order (01_script, 02_script, ...
1
vote
1answer
96 views

excel / open office - append an incrementing value to all non-unique fields

I have a large table of about 7500 store names. I need to search through those names and, if they are not unique, append an incrementing value, for example: store_1 store_2 etc. Anyone know how to ...
0
votes
1answer
49 views

Cannot connect to database

I created a php file to connect to my database hosted on ipages.com with the following simple code: <?php mysql_connect('hostname', 'username', 'password'); ?> When I load this page, I get ...
0
votes
1answer
2k views

How do I fix a corrupt calendar cache?

I was tailing /var/log/system.log and noticed a sudden wall of text. Looking closer, I saw it was an error CalendarAgent got while trying to save something: Nov 18 11:42:45 rainbow-dash.local ...
0
votes
1answer
2k views

Conver .frm(SQL Data files) into text Files

I am trying to convert .frm (sql data files) to text files, The reson for this is becouse i want to see how doe's the sql engine storage the data "behind the scenes", For example: when using "ENUM" ...
4
votes
2answers
3k views

SQL Server Management Studio print in color

I am using SQL Server Management Studio 2012. I am trying to print a stored procedure in the color-coded syntax that it loves showing me, but cannot find an option to enable this. Any ideas? I know ...
0
votes
1answer
2k views

Display vs Value in a Microsoft Access Form's dropdown box

I'm a n00b at Access, so I might not be approaching this in an Access-y way. Say I have two tables, A and B. Every A belongs to a B, so A has a column B_id which is constrained to match the id ...
1
vote
1answer
2k views

How to use CREATE TABLE queries in LibreOffice Base?

I'm using LibreOffice 3.5.4.2 (from Ubuntu 12.04 packages) and trying to create tables using SQL's CREATE TABLE statement. For the first few attempts I got a message saying that the query must be a ...
14
votes
5answers
10k views

Search via all Skype history

How to search given string at all chat histories? СTRL+F - search inside one chat, but I have a lot them, so I want find something in all saved chats?
0
votes
1answer
425 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
1answer
783 views

Possible SQL injection

I have a desktop based software that's built on top of SQL 2005. The SQL server is hosted inside my office, and there is 1 public facing website which displays some of the content from this database. ...
0
votes
1answer
168 views

Fastest light-weight method of executing and displaying results of SQL query [closed]

Many if not most applications can display the results of SQL queries in some human readable format. However, they typically either must be open with an active window (SSMS or excel for example, both ...
0
votes
1answer
304 views

How to completely remove MySQL from a windows 7 machine

I'm new to MySQL struggling to find a version and workbench which works stably on my 64 bit windows 7 machine. I've decided to attempt to completely remove MySQL from my machine and to restart the ...
1
vote
1answer
1k views

Record Matching Software to Compare two tables and match on % Based [closed]

So I have some table with Name, Address, and Zip with no record data attached; and I have a table which has all the same, but has more information and I need a way to merge the tables when they don't ...
1
vote
1answer
540 views

Log of SQL queries to ODBC driver?

I have an application on my Windows XP SP3 machine that's querying and returning data from a database through the SQL Server Native Client. Is there a log file being kept that would show me the SQL ...
2
votes
2answers
5k views

“Edit” command in SQL Developer

In Toad, you can use edit tablename where ... and then simply edit the data in DB. Is there any equivalent in Oracle SQL developer?
1
vote
3answers
602 views

Automated Remote SQL Backup

I'm looking for a program that can be scheduled(weekly) to back up a SQL database on a server and download it to my local machine, does anyone have any suggestions? Thanks EDIT: i should have ...
2
votes
1answer
2k views

I can't install SQL Server on my PC

I have a PC with Windows XP Professional x64. And I'm trying to install a SQL Server Express x64 version. All goes well until the setup builder try's to set the necessary setup files. At this point ...
1
vote
1answer
638 views

How to use the current date as an argument?

I have a batch script which extract SQL data to CSV file: bcp Database.dbo.MyTable out C:\Reports\Output.csv -s ServerName -T -c I need the name of the output file to contain the current date. For ...
1
vote
1answer
147 views

How to create a condition clause using a current computer time

I have an SQL View which contains a column with dates of the '2012-06-21 19:44:50.543' format. I need to entre the condition to show only lines with dates starting from the beginning of the previous ...
1
vote
1answer
8k views

How do I automate the exporting of a result set from an SQL Server database?

I have a View in an SQL Server 2008 database which I need to be exported into a CSV file automatically at the beginning of each month. As I understand, two procedures are needed: The SQL script to ...
3
votes
1answer
5k views

Importing specific date format to Excel from Microsoft SQL Server

I've already asked the question at: StackOverFlow and got sent to this place here. I'm importing dates from a German SQL Server table into a German Excel file via the built-in Excel connection tool. ...
3
votes
3answers
317 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 ...
1
vote
3answers
8k views

Real-time graphing application for SQL data [closed]

I am looking for a free data graphing application that can pull data from MySQL and display it on a trend graph without any programming. It should use a GUI to select the data to be plotted, start ...
3
votes
1answer
157 views

SQL import size

I'm in the process of importing a couple of SQL dumps into my own mySQL server. The size of these dumps, from Wikipedia, are 2.3 GB and 22 GB. Is the size of an SQL dump file approximately the same ...
1
vote
1answer
542 views

SQL syntax highlighting and code completion in Eclipse PDT

Is there a way of enabling highlighting (and/or code completion for SQL) for SQL syntax in PHP strings variable while developing some PHP works related to SQL using Eclipse PDT?
2
votes
2answers
2k views

excel - generate a username from a full name field

I'm trying to generate a username using a single name field in excel which has the person's first name and last name. I'm open to what the username would be, as long as its intuitive for the user. The ...
2
votes
2answers
18k views

How can I get a list of fields AND respective tables used in an MS Access 2010 database?

I know this is how you get a list of all the tables in the database (and more if you modify the critieria: SELECT * FROM MSysObjects WHERE (((MSysObjects.Type)=1) AND ((MSysObjects.Flags)=0)); But ...
2
votes
1answer
6k views

How do you create a SQL query in Excel 2007 with a dynamic date range?

I am trying to create a reporting spreadsheet that can print reports for a given time period. The query below works, but when I try to use a ? parameter in place of the date, I get an error after ...
9
votes
4answers
12k views

Where can I obtain the SQLpackage command-line utility?

I am trying to use he SQLpackage command-line utility (sqlpackage.exe) on a SQL server, but I cannot find it anywhere online. Is it something that I can download as a standalone utility, or is it ...
0
votes
1answer
1k views

Import a local SQL File To a Remote Server Using SSH Tunnel

I have a connection between my localhost and a remote server using putty SSH tunnel. Thats fine. Now I need a command to get the sql file on my local machine i.e. c:\folder\test.sql and import it ...
0
votes
0answers
115 views

What enterprise tools exist for exporting from a database into a set of files?

I'm looking for software that's designed to select/query data from a database (SQL or NoSQL), and export it into files (CSV, XML). Ideal characteristics: Manage very large datasets (petabytes), ...
0
votes
2answers
128 views

How can I set up a database (SQL?) for literary annotations?

I'm a literature student and I'd like to be able to annotate literary texts (originally stored in HTML or as text files) on a word-by-word or line-by-line basis. I hear databases like mySQL or SQLite ...
0
votes
1answer
2k views

Can LibreOffice Base odb databases migrate to SQL server?

If I make a LibreOffice Base database in its native ODB format, is it possible to later migrate the database to a SQL server such as PostgreSQL??? If so, how? Thanks!
0
votes
1answer
77 views

SQL Server Installation issue

i have installed ms sql server 2005 properly but there isnt option to open sql management studio.. in start--> all program --> sql server 2005. shows only configuration tools and no option like sql ...
0
votes
1answer
2k views

How do I connect to a MySQL database from another computer in VB.NET?

How do I connect to a database of another computer in the same local network using VB.NET? We have already enabled remote connection in the SQL Server configuration and the SQL browser, and we already ...
0
votes
1answer
156 views

What SQL can be used to extract a first and last name from a mixture of name fields

Name field can be a mixture of formats, for example: Mr. First Last, Mr First Last, First M Last, First M. Last, First Last Snr, First M Last Snr, First Last-Last, etc.
1
vote
1answer
2k views

Is there some issue in have bigint column as primary key on mysql?

I need to know if i can set a bigint column as primary key?
0
votes
1answer
810 views

How To Replacing/Emulating Microsoft SQL Server on Linux?

I'd like to use a database-enabled version of a particular application (http://idimager.com), but it requires Microsoft SQL Server. My home ecosystem is powered by a Gentoo Linux server, and I'm ...
0
votes
1answer
313 views

How To Get Adjacent Data Back? after using “Remove data from the external data range before saving the workbook” -

I have a spreadsheet with an external data table coming from SQL Server with a query that returns data specific to each user. I have put instructions in this file to allow it to download once and then ...
-3
votes
2answers
458 views

Can I install SQL Server 2005 on the Windows Starter Edition? [closed]

Can I install SQL Server 2005 on a netbook running the Windows Starter Edition?
0
votes
2answers
2k views

Select multiple processes to terminate in XP via -.vbs

I am trying to do a script that'll allow me to kill a few processes when I need a maximum of resources. Things I don't mind starting up when I start XP (dropbox, PowerISO, OpenOffice-tray, etc.) but ...
3
votes
5answers
5k views

Excel formula - querying a Range that results a Range

I have a Range in Excel (B3:C8) from which I want to filter out the English persons. In SQL this would be dead simple: SELECT Persons FROM [myTable] WHERE Nationality = 'English' How can I apply a ...
1
vote
2answers
3k views

Free Database Browser for PostgreSQL?

Does anyone know of a free PostgreSQLdatabase browser that I can use besides RazorSQL since It has a 30 day trial? It would be great to have something similar to the SQlite Database Browser, light ...
1
vote
1answer
4k views

Running Oracle script from Notepad++

Can we configure Notepad++ to run an Oracle script? I mean, once we wrote some script (assume a PL/SQL script containing a procedure), can it be compiled from Notepad++ editor itself? If it is ...
3
votes
2answers
4k views

SQL Server 2008 R2 (x86) and the Access Engine

All, I have set up the Access Database Engine for SQL Server 2008 R2 (Service Pack 1) on many machines running x64 Windows 7 without any problems running as 'Administrator' (and setting up SQL Server ...
0
votes
1answer
255 views

Is there a mysql substitue for Infosystems Cache?

I have an ERP with a flat file "database" written in PL/B. We use Intersystems Cache to read those flat files into MSQL tables. The Cache scripts are vendor provided and we have zero direct access ...
0
votes
3answers
872 views

SQL command for selecting multiple records within range

I'm relatively new to SQL and am looking for a command that I can run in order to find all records within a database within .5 of a calculated value. For example: SELECT X, (Y/Z) AS ZZ FROM Table ...
0
votes
1answer
170 views

preparing large data sets for analysis [closed]

I have a fortran program that simulates a lot of ascii text file output. These are quite large to load the entirety of any single file into common data analysis programs (Matlab, R, SciPy). I think ...
2
votes
1answer
5k views

Event log warning Registry setting specifying configuration file does not exist

Microsoft SSIS Service: Registry setting specifying configuration file does not exist. Attempting to load default config file. For more information, see Help and Support Center at ...