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

learn more… | top users | synonyms

0
votes
1answer
48 views

SQL : swap 2 values in a column without using an intermediate value

Given a table with a single column containing only 2 values, say 'A' and 'B', is there a way to swap them in a single statement Ex: A B A B to B A B A It is a trivial process if we use a bit ...
0
votes
0answers
30 views

Accessing the columns of a form in an sql query

i have table I would like to query the data using a form which has three columns but with the code below i can only access the first column. the three columns i wish to include are - course_no, ...
1
vote
0answers
268 views

“Compacting” a SQL database after deleting records with SQLiteMan

I'm using SQLiteMan to edit/delete Skype message history, as described in numerous guides on the Net. I.e. I open Skype's main.db file in my profile folder using SQLiteMan and selectively delete some ...
0
votes
0answers
87 views

Cannot open SQL files in VS2010 on Win7 x64

If I try to open SQL files in Visual Studio 2010 on Win7 x64, VS just hangs and I have to kille the process. This is happening with both local files and files on TFS. I have no problem with opening ...
0
votes
0answers
105 views

Using SQL to join spreadsheets in excel

Based on the explanation here: How do I join two worksheets in Excel as I would in SQL? I tried to join two excel sheets from different files into the same sheet. However, I keep getting this error ...
1
vote
1answer
116 views

How can I connect to an InterBase database using Excel?

There is an InterBase database that I'd like to connect to using Excel. I have the database name, address, and login info. IB, as I understand it, is a form of SQL. Using the SQL connect mode under ...
1
vote
3answers
2k views

How do I start a MySQL Server in Windows ?

I've installed a MySQL server onto my computer and when I first installed it, it ran automatically, now I've restarted my computer it is no longer running, what file do I need to run to get it back up ...
1
vote
1answer
162 views

Deployment Fail During Generate Star Schema

I am Using SQL Server Data Tools for Visual Studio 2012 for Generating Start Schema.I am using one Database with four Tables.When i am Click on Start Button. I Got This Error The project could ...
2
votes
2answers
386 views

understanding Microsoft Download Center naming convention

The following are the download names for SQL Server Express Editions. SQLEXPR_x86_ENU.exe SQLEXPR_x64_ENU.exe SQLEXPR32_x86_ENU.exe The machine I have is a 32 bit intel machine. Which one should ...
1
vote
1answer
21 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
0answers
21 views

automatically type the fields when creating a table / loading data from file?

Very often I use mysql and sqlite in an ad hoc manner: quickly create a few tables, retrieve the information I need, then delete the tables beause I will never use them again. I wonder if it is ...
0
votes
2answers
641 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
32 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
49 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
10 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
971 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 ...
0
votes
0answers
38 views

How to cancel all sql server jobs without starting ms sql server process

I am using ms sql server 2012, at the midlle of huge query execution, my system crash so i decided to end task ms sql server process. Now, each time i want to start ms sql service my system crash ...
0
votes
0answers
26 views

Is it possible to show several tables in SQLYog at the same time but in different tabs?

For now when I click on some table in tables list on the left the content of that table appears in the Table Data tab on the right. When I choose another table the content of the previous table in ...
1
vote
1answer
122 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
314 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
232 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
65 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 ...
1
vote
4answers
147 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
56 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 ...
0
votes
1answer
108 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 ...
1
vote
1answer
261 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
614 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
79 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
54 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
6k 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
54 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
38 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
107 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
108 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
330 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
364 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
386 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
407 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
54 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
385 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
605 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
142 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
2answers
160 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
375 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
480 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
677 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 ...
3
votes
3answers
19k 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
42 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
291 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
245 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 ...