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

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
225 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
702 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
165 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 ...
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
2k 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
357 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
342 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
326 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 ...
5
votes
3answers
2k 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 ...
2
votes
1answer
8k 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
2k 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
372 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
508 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
3k 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
161 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
1k 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
194 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
827 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
136 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
25k 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
702 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
811 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
404 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
854 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
16k 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). ...
0
votes
2answers
2k views

Having problems with connecting to/seeing the local SQL server with Microsoft SQL Server Management Studio

I'm having some difficulties when I'm trying to connect to my local SQL Server. I'm pretty sure the server is running (many of the other topics on this subject suggests that the services might not be ...
1
vote
1answer
420 views

Display corrupted with repeated scrollbar in SSMS Microsoft SQL Server Management Studio

Microsoft SQL Server Management Studio (SSMS) corrupts the display results and query window in both versions 2005 and 2008 as shown in the screenshot. It seems like the window drawing / re-drawing ...
0
votes
3answers
4k views

Recommended utility to import .csv files into Microsoft SQL Server 2008 R2?

I'd like a better method to import .csv files into Microsoft SQL Server 2008 R2. The default import wizard maps everything, by default, to a varchar(50), even when its quite obvious that its a columm ...
1
vote
0answers
38 views

SQL Windows authentication from Web application?

Is it possible to use MSSQL Windows authentication to connect from one server to another using web application? Both servers are in the same VPN.
1
vote
1answer
379 views

deleting a row in dbvisualizer

I would like to delete this one in the db visualizer and not sure if I am writing the correct syntax: I also see that the idsapusertype 25 is also linked to idsapusertypedetails 75 and 76. Can I ...
1
vote
4answers
13k views

SQL Server Management Studio - First Time Setup

I'm on Windows 7 and using free version of SQL Server Management Studio. I try connecting to DB server for the first time. I run the program as administrator. I go to Connect > Database Engine and ...
5
votes
1answer
7k views

How can I get sql server profiler installed

I have Sql Server 2008 R2 installed. But in Management Studio, under Tools menu, I don't see Profiler. What feature do I need to install in order to get profiler?
3
votes
2answers
2k views

Can I use SQL to build an Excel data table from other Excel files?

I know SQL well enough to perform basic queries and manipulate data split into multiple tables in a database. I know Excel 2007 a bit better and use it frequently to manage my mechanical engineering ...
0
votes
1answer
2k views

Starting a SQL server on fedora

I am a total databases noob, hence please be gentle. I am looking for tutorials how to create a SQL table, how to start a SQL server, and what software to use on fedora. Would anyone share links to ...
2
votes
2answers
657 views

Connection Issues with SQL Server Express

I have windows 7 Ultimate, 64bit. I have installed SQL Server 2008 Express and have created a database in it. I have a jar that helps me create a connection file to connect to this database. I have ...
15
votes
2answers
81k 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
2answers
6k views

How do I write a query in Microsoft SQL Server Management Studio and then use that Query in Excel

I have an Excel file that I want to open up, hit refesh, and it pulls in the data from the SQL server and then I manipulate the data and create some dashboards. I actually have this but I'm pulling ...
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 ...
0
votes
2answers
42 views

How to install SQl for the first time in XP

I ve downloaded mysql-essential-5.1.49-win32 for their site and installed. After Installing, i tried some internet stuffs(mysqld --console) to verify the installation. I cant get the correct output. ...
0
votes
1answer
79 views

How do i pass a variable to a function thats already being escaped?

What i want to do is create multiple informix sql statements & later run them via a bash script. Here is what i have so far (this works) but is meant to be run from a cron job so it only does ...
1
vote
2answers
1k views

SQL authentication not authenticating in MS SQL Server 2008

When I try to connect to the SQL Server running on localhost using Windows Authentication in SQL Server Management Studio, I am able to connect but when I try to connect using SQL authentication, it ...
9
votes
2answers
11k 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 ...
0
votes
1answer
146 views

Looking for program to export data from MS SQL database

I need to export some tables in a MS SQL database. The ASP.NET Enterprise Manager provided by the host doesn't offer much functionality. Can someone recommend a good program for doing this? I only ...
0
votes
4answers
800 views

Tool to copy SQL Server Database

I am looking for a tool to copy a sql database tables, stored procedures, functions etc and also the data contained within the database from a server to my local pc. Both have sql server management ...
0
votes
1answer
566 views

Graphical Decision Engine Framework - Any ideas?

Is there an open-source decision framework I could use? What I am looking to create is some kind of graphical interface to allow people to visually build a query based on a set of parameters, ie. ...
0
votes
1answer
5k views

SQL Server 2008 Management Studio x64

Is there a 64bit version of SQL Server 2008 Management Studio? I downloaded the 32bit/64bit version of SQL 2008 Developer R2 and it still installed into the Program Files (x86)\ file location.
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 ...