Structured Query Language, or Structured Query Language or SQL is a declarative query language for relational database.
-1
votes
0answers
22 views
what software can I use to show mapping of 2 database? [closed]
I have 2 database server main database A and other database B.
Database B is same as A but the name of tables and some of the field name are different, but data inside is almost the same.
Database B ...
0
votes
2answers
27 views
Combining two Excel sheets
I ship a lot of items to a lot of stores and I have two Excel sheets. I have one sheet showing how many items I have shipped to each store and another sheet showing how many I have sold in each store. ...
0
votes
0answers
9 views
Access Query Designer Woes — select by multiple values not working
Table 1 Names
Table 2 Services
If I do a simple select of both tables together, I get a list as follows:
Name1 Service X
Name2 Service X
Name2 Service X
Name2 Service Y
Name3 Service Y
Name3 ...
1
vote
2answers
79 views
Dynamically filtering data before importing from SQL Server in Excel
I'm trying to figure out whether there is a way to filter the data from an SQL Server connection before it is imported into Excel. The initial import doesn't matter (when the connection is set up), ...
2
votes
1answer
21 views
What are the risks for logging across databases via a trigger?
I've searched for this online and had mixed or unclear responses.
On SQL Server 2005, we currently log certain table changes via triggers using the inserted/deleted tables. Currently, our log ...
-1
votes
1answer
22 views
SQL Data types for Time [closed]
What is the data type for hours in sql(i.e. timesheet hours)?
Appreciate your help
Examples
For field containing a word (ie Flower)the data type is CHAR and in xs:string
For field containing a ...
0
votes
1answer
41 views
Upload .SQL Files to Wiki
Changes to my team's database are recorded in our internal wiki. Currently, in addition to a brief description, the .sql scripts are added as text. This is becoming bulky and making the page difficult ...
1
vote
0answers
27 views
Pull Data From Web Database With Excel 2007
I have a web based database that I work with regularly that uses 802.1x authentication (Smart Card with password). From the website you can pull premade and custom reports that are ultimately stored ...
1
vote
0answers
81 views
What's the best way to get a MySQL database into SQL Server 2012 Reporting Services?
I'm trying to get a MySQL database into SQL Server 2012 reporting services as a shared data source, and getting absolutely nowhere after a day.
I've tried a couple of options. First, my specs:
...
1
vote
1answer
37 views
How can I connect to sql server from a different domain/network
I installed SQL Server 2008 R2 on 6 machines. They are to be placed in 2 offices, 3 in each.
I created a database instance and I used VB6 and was able to link both perfectly.
I was also able to ...
1
vote
1answer
33 views
PostgreSQL installed from source, no pg_config alias
So I installed pgsql 9.0.10 on Ubuntu 12.10 from source (./configure, make, make install). It all went well, created /usr/local/pgsql/ and everything that it should contain, but I have encountered one ...
0
votes
2answers
95 views
Is it possible to put a wildcard search into a parameter query in LibreOffice Base?
I am using Base in LibreOffice 4.0 (still using the HSQL that comes with Base but looking at moving to HSQL 2.2.8) and I would like to do a query that asks for parameter input like:
SELECT * FROM ...
0
votes
0answers
21 views
SQL Server Management Studio 2005 SQL dump
How can i create a SQL dump (structure and data) with the Management Studio 2005 or the MS SQL server?
0
votes
0answers
31 views
Records repeat for SSRS 2005 report
When I run a report for a purchase order, the report duplicates records for product codes.
For example, the purchase order is: P000976, the report displays the product code twice when it should only ...
0
votes
0answers
36 views
importing text strings with “+” in them to excel from sql query
Any version of Excel, in Windows 7. if I import a string such as 90003/6+3AQx-z it imports as
I would love to substitute characters to simplfy this, but they are product ids I didn't create
I ...
0
votes
0answers
96 views
Automated SQL query into excel file
Is there a software or app that will be able to get data from my MySQL database, based on the same query every day (e.g. select name from table where bla bla), write that data to a XLS file (not CSV), ...
2
votes
0answers
163 views
How to represent m:n relationships in a form in Libre Office base?
I have an embedded database in Libre Office. I am building a form in it, and got into a problem.
I have a table called "Author" and another table called "Publication", connected by a third table ...
1
vote
0answers
86 views
how to connect to pervasive sql through odbc?
I am trying to add a linked server to a sql server 2012 database using ssms 2012.
the linked server is pervasive sql. here's how i am trying to do it:
EXEC sp_addlinkedserver
@server = ...
1
vote
0answers
39 views
Splitting One Data Set Across Multiple Columns in Report Builder
I am using report builder to generate letters. What I'm trying to do is have one column of values but when it reaches the end of the page, instead of creating a new page I want it to overflow to a new ...
0
votes
0answers
77 views
Is there a Mac SQL/DB browser for DB2
I'm currently using Sequel Pro to access MySQL and I love it. Is there a good Mac OS X graphical interface for IBM's DB2 Database?
I can type queries, but I'm working with a large complex schema and ...
0
votes
1answer
32 views
SQL Server 2012 bare minimum config for normal usage?
I would like to install SQL Server 2012 with the bare minimum required. I just want a local database and to be able to create/edit/query tables/write queries in the GUI editor.
Which of the ...
1
vote
0answers
80 views
Row is not deleted in PHPMyAdmin
I am having problem deleting a row in PHPMyAdmin. I click the 'Delete' button to delete the row, at the top it says
Showing rows 0 - 0 ( ~1 total , Query took 0.0004 sec)
SELECT *
FROM ...
0
votes
1answer
96 views
Append a record's field value with a string in MS Access SQL
I would like to run a query that updates a field's value with whatever is already there but with an "n" appended in the end.
For example say there's a field called AccountNumber and for a certain ...
0
votes
0answers
30 views
Error 1045 access denied
In my VM CentOs, I created another user 'sheilay'.
As sheilay, I created a project PUPAIS and as I enter the command python manage.py syncdb, there was an error (1045, "access denied for user ...
0
votes
1answer
128 views
Does Excel have an equivalent to the SQL “UNION” statement?
I have an SQL query with two SELECT statements and am using a UNION statement between those two to get a unique result. I need to use this query in Excel but I believe Excel does not accept a UNION ...
2
votes
3answers
1k views
How to open sql file as a table?
Someone gave me a file with extension sql, but I don't know what should I use to open it. I can open it with a text editor, but I would like to view it as a table. Is there any software that can do it ...
0
votes
1answer
33 views
Can't seem to figure out how to install and what I actually need
I just started a course on databases and I seem to need some sort of database interaction program, I was pointed towards SQL but I know nothing of it. I do have access to over 180 free programs from ...
0
votes
1answer
159 views
ms sql select data after specific date of the year regardless of year
I want to select a data from column 'Birthday' which format is 'yyyy-mm-dd 00:00:00.000' but I need to skip year, and pull out data from range yyyy-01.01 to yyyy.05.01 ?
Tryed underscores and percent ...
-2
votes
1answer
105 views
Ceridian HR-Payroll Source SQL error
We are using an old piece of software from Ceridian called Source this is a HR Payroll piece of software. I cannot phone their support as we no longer have a contract but use the software for archive ...
1
vote
1answer
175 views
How to input date range in word for SQL query?
I have an Excel file that uses an SQL query to pull inventory usage of the medications in our pharmacy over a period of time.
I currently just have to go to Data > Connections > Properties > ...
0
votes
0answers
90 views
Merge multiple sqlite databases containing duplicates
I have a series of multiple backups of an sqlite database, and I wish to merge them into one single file but removing the duplicate entries.
How could I go about doing this on linux?
1
vote
0answers
102 views
Change date in a SQL query to reference a cell in Excel
I have the following code that returns the needed data into excel and manually changing the date will change the returned data; however, I'd like to reference a cell with a formula that will make the ...
1
vote
1answer
368 views
How to write an SQL query for SQLite Manager for Firefox places.sqlite?
I am using SQLite Manager which is an extension for Firefox. I use this to inspect the places.sqlite database. I am trying to find the earliest visit date for a specific URL in the Firefox history.
...
0
votes
1answer
132 views
How do I install SQL Server Reporting Services for my version of SQL Server?
I believe the version of SQL Server 2012 that I have installed is a developer version. It is version 11.0.3000. I would like to install Reporting Services and Report Builder. I tried this link: ...
0
votes
1answer
22 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
44 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
30 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
0answers
90 views
Safe to truncate core_sessions in Magento [closed]
I recently noticed that my core_sessions table grows exponentially large so I was wondering if it's safe to truncate it? I generally truncate all my log_ and report_ tables on a weekly basis but ...
0
votes
1answer
343 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
0answers
65 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" ...
1
vote
1answer
303 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
169 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
500 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 ...
0
votes
0answers
160 views
Sql server installation SQLEXPR32_x86_ENU.exe not working
When I double click on SQLEXPR32_x86_ENU.exe, a dialog box opens and it shows it is extracting autorun.inf, but it is not proceeding.
0
votes
0answers
45 views
Storing the result of a calculation? sql server C# [closed]
Hello I'm new to C# and SQL server and I've been creating a simple game for the last 3 weeks. So far so good but now I'm having trouble finding a way to store the result of a calculation in row 0.
...
0
votes
1answer
132 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
346 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
65 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
112 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
370 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 ...
