The sql tag has no wiki summary.
0
votes
1answer
28 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 ...
-3
votes
0answers
41 views
How can I improve the speed of this SQL query? [closed]
select a.err,a.msgal,a.id,a.lista_id,a.sms_id,a.msg_id,b.numero
from sms_envios a,sms_numeros b
where a.lista_id=b.lista_id and ((a.err=1 and a.err=b.err) or a.err=0)
order by a.id asc,b.id asc
...
0
votes
1answer
48 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
37 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
1answer
48 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 ...
2
votes
5answers
187 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
45 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 ...
0
votes
1answer
125 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
1answer
127 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
0answers
50 views
How to start with the SQL queries in the QC 10.0?
I understood that for generating reports and troubleshooting in QC we can use SQL queries from backend of the QC 10.0.
Please guide me through any any tutorial websites,cookbook's or workbook's ...
0
votes
1answer
34 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
2answers
37 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
37 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 ...
0
votes
1answer
283 views
Microsoft SSIS Service: 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
237 views
Excel: 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
1answer
27 views
How can I get autocomplete to work (with a keyboard shortcut) with Sequel Pro?
If I type in a table name or part of a table name and wait a few seconds, a popup box will show up and allow me to choose a table or column. Is there a way to get this box to pop up without waiting - ...
0
votes
0answers
122 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
votes
1answer
41 views
Desktop SQL clients for PostgreSQL [closed]
Are there any desktop clients that I can use to connect to my web hosting PostgreSQL database?
This is so that I can run test queries without having to use the web interface.
1
vote
0answers
29 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
11 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
79 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
112 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 ...
0
votes
0answers
28 views
Compare “Date” field in Oracle [closed]
I have 2 questions:
I want to compare a field whose data type is "Date" against a given date.
The DB is oracle and being a mysql guy I'm finding it difficult to come up with simple queries.
The ...
0
votes
1answer
784 views
How can I split a large SQL file into smaller chunks? [closed]
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
130 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
1answer
60 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
63 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
478 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
50 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
169 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 ...
0
votes
1answer
36 views
SQL server is disabled when trying to connect database to .net
Generating user instances in SQL Server 2005 is disabled when I am trying to connect my database to .net. I used sp_configure ' user instances enabled' to generate user instances.
What should I do?
-1
votes
3answers
67 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
0answers
40 views
SQL table Referential Integrity
SQL 2008 - could someone please direct me in creating Referential Integrity in SQL Server mgr studio. The front end is MS Access, I now understand this cannot be done in Access when the tables are ...
0
votes
1answer
146 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
55 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
0answers
77 views
Need suggestions how to create dynamic service map (diagram)
The idea is to create service map ( reference link ), where could be seen all the services like mail, file server, exchange and the dependent software, hardware also workers which are responsible for ...
0
votes
1answer
84 views
Start database in Fedora 13
How can I start to create, delete, etc., a table in Fedora 13? How can I initiate to create a basic table in Linux, what are the commands? Will I have to install firstly a database like ORACLE in my ...
0
votes
2answers
64 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 ...
0
votes
0answers
191 views
filemaker to sql server, odbc authentication problem
I'm having trouble with FileMaker SQL authentication and I hope I can articulate it correctly:
In my FileMaker client, I can enter SQL commands in script steps -- the script works with my network ...
0
votes
0answers
49 views
Advice pls for Best HD/RAID Config for Rack server for SQL with limited drives
I have a Dell R710 with dual processors , 32 GB of memory and 6 15K Drives with an H700 controller. Current config that it shipped in is all six(6) 15K 600GB SAS drives RAID5 with 2 virtual drives.
80 ...
0
votes
0answers
37 views
Find material for improvement of my SQL ability [closed]
I need lots of training in SQL coding in MS SQL server
The following part that is needed to be improved is:
script
T SQL
Procedure
Function
Problem:
Where can I get material to improve my ...
0
votes
1answer
440 views
SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server
SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server.
Here's a screenshot of the error:
1
vote
2answers
2k 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
69 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™êÃÔ ...
1
vote
2answers
135 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
108 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
262 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 ...
0
votes
0answers
65 views
Log into another XP machine's SQL Server with a different userid? (WORKGROUP, not domain)
I have two machines at home, both XP Pro SP3. I have no domain controller, so they're both just in WORKGROUP.
How can I, using Windows Authentication, log into an instance of SQL Server running on ...
4
votes
2answers
347 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
127 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 ...
