The sql tag has no wiki summary.
0
votes
0answers
16 views
T-SQL save individual rows to text files
I have a table containing some HTML content in an ntext column, which I wish to extract. Is there any way to save the individual rows from query results to text files? I had attempted to use a cursor, ...
0
votes
1answer
23 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
42 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 ...
-1
votes
0answers
16 views
Counting the number of people in a team with an SQL Stored Procedure [closed]
I am wanting to create a stored procedure that accepts the team name and year and returns the number of players in that particular team for that particular year. I am working with MYSQL and listed ...
0
votes
0answers
57 views
Show DB2 Tables in Oracle SQL Developer
(Yes, this is a duplicate question from SO. I made it long ago, and it's still unanswered. I think it may get better results here?)
I'm connecting to a DB2 database with Oracle SQL developer. There's ...
1
vote
2answers
95 views
Will this network layout work?
I need to make a network in my office so I can have a company come and install software for me. They are going to setup my front office computer so I can perform normal tasks on it and it will ...
0
votes
0answers
11 views
Transfer Error Message Task in unable to Configure
I am using an Transfer error message task in ssis 2008 edition to transfer error messages from
my local machine to another machine via LAN.but when i am configuring the task Error message list is ...
0
votes
0answers
27 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
1answer
38 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
0answers
108 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
0answers
69 views
How to generate MYSQLWorkbench formated XML with mysqldump
I am trying to create a script that automatically dumps xml from certain tables in the databases. The problem is we developed our xml parser around the XML format that MYSQLWorkbench uses when you ...
0
votes
0answers
345 views
importing CSV data in Oracle (trying Apex/SQL Developer) [closed]
I am using recent versions of APEX (4.1.1) and Oracle (11.2.0.3).
I am uploading CSV data to a set of tables.
I have been trying it out and am encountering some problems which I haven’t seen before.
...
0
votes
1answer
19 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 ...
-1
votes
3answers
98 views
Using pirated software sysadmin perspective [closed]
This is just a moral question for sysadmins and IT Techs. I seen a similar thread on SO however this provided a perspective from a programmers view. IN their job the pirated software is used to make ...
0
votes
1answer
304 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
46 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
83 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
98 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
84 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
71 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
179 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
210 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
112 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
305 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
475 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
133 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
66 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
87 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
64 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
682 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
1k 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
54 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
1answer
228 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
79 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
60 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
37 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
131 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
154 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
68 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 ...
1
vote
1answer
2k 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
304 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
90 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
98 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
877 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
76 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
274 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
55 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
89 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
254 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
69 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.
