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

learn more… | top users | synonyms

0
votes
0answers
65 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 ...
2
votes
2answers
9k 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
68 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
40 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 ...
1
vote
1answer
135 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
140 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
392 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
500 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
575 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
612 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
1answer
63 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?
3
votes
0answers
469 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 ...
2
votes
1answer
1k 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
205 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 ...
1
vote
2answers
325 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 ...
2
votes
0answers
499 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
870 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
1answer
910 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 ...
4
votes
4answers
33k 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
49 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
463 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
316 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
412 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 > ...
1
vote
0answers
266 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
2k 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
2answers
795 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
23 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
89 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
41 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
1answer
1k 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
1answer
904 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" ...
3
votes
2answers
2k 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
898 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
1k 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 ...
7
votes
3answers
5k views

Search via all Skype history

How to search given string at all chat histories? СTRL+F - search inside one chat, but I have a lot them, so I want find something in all saved chats?
0
votes
1answer
290 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
641 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
127 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
251 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
951 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 ...
1
vote
1answer
241 views

Log of SQL queries to ODBC driver?

I have an application on my Windows XP SP3 machine that's querying and returning data from a database through the SQL Server Native Client. Is there a log file being kept that would show me the SQL ...
2
votes
1answer
2k views

“Edit” command in SQL Developer

In Toad, you can use edit tablename where ... and then simply edit the data in DB. Is there any equivalent in Oracle SQL developer?
1
vote
3answers
428 views

Automated Remote SQL Backup

I'm looking for a program that can be scheduled(weekly) to back up a SQL database on a server and download it to my local machine, does anyone have any suggestions? Thanks EDIT: i should have ...
2
votes
1answer
1k views

I can't install SQL Server on my PC

I have a PC with Windows XP Professional x64. And I'm trying to install a SQL Server Express x64 version. All goes well until the setup builder try's to set the necessary setup files. At this point ...
1
vote
1answer
279 views

How to use the current date as an argument?

I have a batch script which extract SQL data to CSV file: bcp Database.dbo.MyTable out C:\Reports\Output.csv -s ServerName -T -c I need the name of the output file to contain the current date. For ...
1
vote
1answer
123 views

How to create a condition clause using a current computer time

I have an SQL View which contains a column with dates of the '2012-06-21 19:44:50.543' format. I need to entre the condition to show only lines with dates starting from the beginning of the previous ...
1
vote
1answer
3k views

How do I automate the exporting of a result set from an SQL Server database?

I have a View in an SQL Server 2008 database which I need to be exported into a CSV file automatically at the beginning of each month. As I understand, two procedures are needed: The SQL script to ...
3
votes
1answer
3k views

Importing specific date format to Excel from Microsoft SQL Server

I've already asked the question at: StackOverFlow and got sent to this place here. I'm importing dates from a German SQL Server table into a German Excel file via the built-in Excel connection tool. ...
2
votes
3answers
219 views

opening sql file hangs most of the editors but not notepad++

I sometimes need to modify url in big sql files. I usually open it up in some editor and do search and replace. On windows machine notepad++ works perfectly, it never hangs and feels snappy to show ...
1
vote
3answers
2k views

Real-time graphing application for SQL data

I am looking for a free data graphing application that can pull data from MySQL and display it on a trend graph without any programming. It should use a GUI to select the data to be plotted, start ...