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

learn more… | top users | synonyms

2
votes
1answer
117 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
374 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?
1
vote
2answers
1k 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
10k 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
5k 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 ...
0
votes
0answers
2k views

SQL server 2008 R2 installation error

I have a windows 7,32 bit laptop. I am the administrator with all permissions. when I click on the SQL server 2008R2 set up file,it says : SQL server set up has encountered the following error: ...
4
votes
3answers
4k 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
838 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
108 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
118 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
1k 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
68 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
149 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
1k 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
599 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
249 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
380 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
1k 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
3k 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
2k 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
3k 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
208 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
612 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
162 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
4k 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 ...
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 ...
0
votes
2answers
1k views

DataStage Client 8.5 Installation Error on Windows 7

I am trying to install Datastage Client 8.5 on Windows 7 x64 and getting the below error: com.ibm.is.install.exception.ActionException: CDIIN5032E: Exception caught by ExecuteProcessAction.: ...
1
vote
0answers
285 views

Mirror a Microsoft Access 2007 file as a SQL database?

We have a Microsoft Access 2007 database that we would like to mirror as SQL database (typically MSSQL or MySQL, but we are flexible here). The mirrored database is only used for read-only purposes. ...
1
vote
0answers
307 views

Benchmarking for Windows 2008 R2

Does somebody know products to benchmark new hardware for servers 2008 R2 ? The goal is to validate server for future purpose like Exchange,SQL, ... and secondly perform a stress test to assure it ...
1
vote
2answers
300 views

PHP / SQL development environment on USB flash drive (OS independent)

I am looking for a way to set up a development environment for web applications (using PHP and either MySQL or SQLite) on a USB flash drive: that means at least a web server, a database manager and ...
4
votes
3answers
1k views

How to use Microsoft SQL Server 2008 as a simple database for testing

As a student, I get Microsoft SQL Server 2008 R2 for free through MSDNAA. I installed it, but I seem to be at a loss for how to use it to test database queries, and how to construct a database with ...
1
vote
1answer
7k views

How can I split a large SQL file into smaller chunks? [duplicate]

Possible Duplicate: How to split large file on Windows? I have a 100MB SQL file which my host won't let me upload all at once (2MB per upload). The database is on a different server so I ...
2
votes
1answer
1k views

Embed microsoft query in excel with multiple parameters from spreadsheet

I am trying to embed a microsoft query within an excel spreadsheet, that passes several parameters from the spreadsheet to the query. I would like the microsoft excel query function to find a few ...
1
vote
2answers
329 views

How to pull huge table (80 millions rows) from Oracle into SQL DB or SQL dump via VPN

I have the task to pull a huge table from an Oracle DB into a SQL DB or SQL dump via the internet. The source DB (Oracle) is in an enterprise setting which I access via Cisco VPN (Split tunneling is ...
0
votes
2answers
444 views

Run a SQL Script on a timer through DBVisualizer

Using DBVisualizer is there any way to run a SQL Script or Command on a timer? I am using MySQL
1
vote
1answer
2k views

Upload sql database to remote server using Terminal on Mac?

I have a large local SQL database. When I try to upload the file to the remote database I get a message saying the file is too large. My hosting provider told me I need to upload the SQL database to ...
0
votes
2answers
156 views

Microsoft Excel duplicate formula in column

I have this formula in an excel column and want to duplicate it in all the rows after the current row. ="INSERT INTO MyTable (ISAM_ID, ENTITY, CUSTOMER_MEDIA,STATUS,IIN,OID,FVC) VALUES (" & A2 ...
0
votes
1answer
963 views

Using ssh port tunneling to connect to mysql server from home

I'm using SqlYog and PUTTY in order to connect to a MySQL server sitting on a remote server. I'm able to the MySQL server sitting on the host I connect to through PUTTY, but the thing is I use PUTTY ...
-2
votes
3answers
191 views

Where can i download SQL server express 2008 from?

I have windows xp (sp3, i think). I tried to download the sql express version, but it says that it is invalid win32 application. ...
0
votes
1answer
784 views

Linked Query in MS Access 2007 to SQL database - ODBC error - How do I see the linking details?

I am converting an old Access 2003 database to 2007. It has a query linking to a SQL database. How do I look at the link, e.g., whether it using a DSN, etc.? The query has the globe to the left of ...
0
votes
2answers
133 views

SQL/DB browser for DB2

I'm looking for a simple SQL browser which supports DB2. I just want to be able to connect to a DB and try some queries.
0
votes
2answers
114 views

Can an in-use computer be cloned

I am looking to clone several servers periodically as part of a backup scheme. Is it possible to clone a server that is in use using clonezilla or other foss product? One of these servers is running ...
1
vote
2answers
23k views

Creating a new user in Oracle Enterprise Manager 11g

I downloaded the Oracle VirtualBox VM containing Oracle SQL Server 11g and all their dev tools. (There's not much documentation along with it and I had to find fragments of info here and there.) ...
0
votes
1answer
591 views

Notepad++ opening sql files with characters not text

Initially when using Notepad++ it was opening my sql files no problem as text so that I could edit them, now it's opening them and showing characters instead of text for example; "‚©§*ÐÊçrQ™êÃÔ ...
2
votes
3answers
711 views

Running Windows Powershell Scripts simply opens it in the editor

I have a Windows powershell script that works fine in the interactive editor. The script is a simple one line sql cmd: sqlcmd -S servername -d dbname -E -W -w 999 -s "," -Q "SELECT select ...
0
votes
1answer
376 views

How can I give psql a variable instead of an sql file as input?

So I have some sql in a varible. I could put that in a file and give it to psql as input but I wonder if there is an easy way to do this without the file ?
0
votes
1answer
790 views

Why can't my bulk loadable CSV file be opened?

This is my error: Cannot bulk load because the file could not be opened. Operating system error code 5 (Access is denied.) I've checked permissions and everything seems fine. The auto bulk ...
5
votes
2answers
13k views

How can I make Excel fetch data from a database automatically when I open the spreadsheet?

I want to have an excel spreadsheet, that when it opens will automatically populate from a SQL database, using specific queries. Each Workbook would use a different query (or multiple queries). ...