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

learn more… | top users | synonyms

1
vote
1answer
27 views

How come using import SQL only works if the insert script is the only script in the SQL pane?

I am going to take a shot here and hope that some of you in superuser actually use SQLA (SQL Assistant). When you set File > Import Data so that you can execute insert into mydb.mytable (?,?,?,?); ...
0
votes
2answers
2k views

255 Max character size in Excel cell when cell data is linked/fetch from external data source

I have one bug tracking system which export bug data as Excel file. I would like to create a report based on this exported excel file. what I did is create a office data connection file which link ...
0
votes
1answer
43 views

Scan a SQL Server for Stored Procedures with Dynamic SQL evaluations

Is there a procedure which I can use to scan a database's stored procedures for dynamic query evaluation? This is in the interest in providing some assurance against SQL injection.
0
votes
0answers
74 views

SQL 2005 doesn't let me to copy and paste the a big query result, what can I do?

I am doing a local query through a remote desktop of a server. It is Management Studio 2005 and the result is large. Somehow, it doesn't let me to copy and paste the result. csv format doesn't work ...
0
votes
0answers
12 views

Is there any way I can access an access database I set to read only from other computers on another computer?

Basically I secured the database to only open fully on one system but now I need to change it from another system. Is there anyway I can do this? Thanks Edit: The database is a .accdb I changed the ...
0
votes
2answers
2k views

Remote access sql server 2005 over internet

I find so many similar question/problem and go through but unable to solve my problem. As so I am repeating the question again. I would like to connect my sql server 2005 remotely over internet. I ...
1
vote
1answer
181 views

Install sql server management studio API only

I have already installed sql server 2008 R2 , but now i need to install sql server management studio also ( i mean just that API ony ) is it possible to install only this instead of uninstall sql ...
1
vote
1answer
792 views

SQL Server Express “hangs”, on startup

I recently installed SQL Server 2012 "Express", and, also, Visual Studio 2012. I was working with it, and all worked ok. At some point, a few hours ago, SQL Server Express, however, started ...
-1
votes
1answer
421 views

database structure “customers” table having several orders per customer and several items per order [closed]

I want to create a database that has several customers and many orders per each customer and each order has several items in it. I was thinking of creating a table for each order and populate each ...
0
votes
0answers
114 views

SQL Server Data Tools Explore Data error

I am reading a step-by-step book to learn more about SQL Server Analysis Services. I am creating a dimension for an AdventureWorks data source. In the Design Diagram pane, I right click on the header ...
2
votes
4answers
206 views

Accessing a mySQL database on an external server

I have a large (multi-gigabyte) SQL database on an external server. I can access it through SSH, but manually querying the data will be a major pain. I really need a GUI. I'm using Ubuntu 13.04, but ...
2
votes
1answer
86 views

Opening SQL Sever Management Studio and Databases

Is there a way when opening SQL Server Management Studio to also open databases along with it. For instance, I usually work on a minimum of 6 databases during an usual day, and if I could get the SQL ...
1
vote
1answer
262 views

Windows 8 & Server 2012: SQL Server Connection Delay

When connecting from a Windows Server 2012 or Windows 8 box to a SQL Server machine, it takes 2 sec to open a SQL connection and .5 sec for any SQL command to execute. Connecting to the same SQL ...
2
votes
1answer
508 views

Reuse SQL View in different sheets in SQL with different sub queries

I have an Excel document with 20+ sheets, all these sheets use the same SQL View, but they have different critirias on what to show, the only way I can get that working is to make 20 different ...
3
votes
0answers
1k views

How to associate visual studio 2012 with SQL files in Windows 8?

I'm using Windows 8 and I'm trying to make Visual Studio 2012 the default program with which to open my .sql files. I have right-clicked on a .sql file and chosen: Open with... > Choose default ...
0
votes
2answers
98 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
86 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
13k 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
81 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
41 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
172 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
192 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
457 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
646 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
712 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
748 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
72 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
542 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
2k 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
233 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
495 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
649 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
1k 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
1k 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
46k 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
50 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
520 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
362 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
482 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
304 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
1k 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
94 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
44 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
1k 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
1k 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 ...