Structured Query Language (SQL) is a declarative query language for relational databases. Consider also using the tag for the specific database software if your question involves vendor extensions or language quirks.

learn more… | top users | synonyms

4
votes
0answers
614 views

Excel VBA : SQL query handles error

I have SQL that I can use in Excel 2013 to get the info from the Access database and it works using the SQL directly in a connection, but now I want to run it from VBA instead so I can use some ...
4
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 ...
3
votes
0answers
670 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
0answers
951 views

Row is not deleted in PHPMyAdmin

I have a problem deleting a row in PHPMyAdmin. When 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 "...
1
vote
0answers
38 views

Sql server 2008 R2 is losing Intellisense after installing Visual Studio 2010 SP1

after installing service pack 1 on visual studio 2010 , i have lost Intellisense in sql server 2008 r2 , what should i do in order to fix this issue ?
1
vote
0answers
499 views

Windows 7 web browser cannot access localhost

I'm using windows 7 and installed xampp, but I can't access localhost from all web browser (IE, Chrome, Firefox), it always give me "ERR_CONNECTION_REFUSED". I already googling it and found many ...
1
vote
0answers
78 views

Why is sql server native client version “not marked” in odbc data source administrator?

Normally there's a version number in there:
1
vote
0answers
66 views

.bad file not generated in SQLLOADER

I am invoking sqlloader from windows batch script. I have a WHEN clause added in control file. Error record generates and log says that .bad file is generated at designated path. However, no .bad file ...
1
vote
0answers
168 views

Is there any chance Workbench has a case sensitive setting for Queries?

So I have been using MySql workbench for an online database I was able to set everything up but to my suprise and my boss' amazement, Workbench was actually case sensitive. We wrote two select ...
1
vote
0answers
223 views

Manual SQL install error

I am receiving the following error when trying to manually install my SQL: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right ...
1
vote
0answers
196 views

50.000 rows created when querying small table in google sheets. Working as designed or bug?

Querying a small table (11x4 cells), results in sheet expanding to 50.000 rows. Is this expected behaviour or a bug? Shared example spreadsheet here. Spr is read-only, because experimenting with this ...
1
vote
0answers
843 views

SQL Server 2008 R2 - Process 6 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process

I am running Microsoft SQL Server 2008 R2 (SP2) - 10.50.4302.0 (X64) (Latest CU11, Feb 2014) on Windows Server 2012 R2. I have a simple database and a website that runs on the same machine using IIS. ...
1
vote
0answers
45 views

Website unable to connect to SQL Server

I have a very specific problem which has been plaguing me for months now. The issue is this: Every once in a while, the website will lose all connection to the SQL Server with the following error A ...
1
vote
0answers
617 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 ...
1
vote
0answers
307 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
717 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
0answers
338 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
0answers
409 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
0answers
478 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
452 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
0answers
38 views

SQL Windows authentication from Web application?

Is it possible to use MSSQL Windows authentication to connect from one server to another using web application? Both servers are in the same VPN.
0
votes
0answers
6 views

sql server 2000 vs 2014 local login

I have an application written in delphi AND uses sql server 2000 as database engine.I was on windows server 2003 for many years without problem.recently I upgraded to windows server 2012 r2 and sql ...
0
votes
0answers
37 views

How to Create a Query which Combines Two Crosstab Queries under a Split, Merged Column

Sorry if the title is a little confusing. I am attempting to create a query which takes two cross-tab queries and combines them in a slightly different format than the original cross-tabs. I have used ...
0
votes
0answers
46 views

“Navicat for PostgreSQL” gives error “80070003: PrectServer2 not connected” when attempting to autocomplete with materialized views

For some reason I get the error "gives error "80070003: PrectServer2 not connected" when Navicat tries to autocomplete. Take the following example select co.| from visualize.co_mention co When the ...
0
votes
0answers
57 views

VBS for SQL 'Update' statement

Struggling a bit with what I assume is quite simple so wondering if you can point me in the right direction. I want to automate the following SQL command: Update Tablename SET COLUMN ='12/03/2016 ...
0
votes
0answers
77 views

how do i filter by a rolling date range from a sql query

I am trying to filter a query by a date range, but a moving date range. I have heard (read on this site) that this can be handled in a formula in excel, but I couldn't really follow the formula that ...
0
votes
0answers
12 views

SQL Server Management Studio 2008 UI Issues

I work in a Citrix VDN virtual machine. When I get disconnected from my session and come back in, SSMS UI has a bunch of mini windows exploded all over the screen (sorry, no better way to describe it)...
0
votes
0answers
11 views

Curious search behavior in Sql Server 2014, searching for dot also returns comma results

Background I'm getting some unexpected search results, consider the following pseudo-query: SELECT SomeField1WithSearchCriteria, SomeField2WithSearchCriteria, ...
0
votes
0answers
57 views

What is the best way to archive a large SQL DB table

Question: I am looking for recommendations on how to archive about 80% of the data in a SQL DB table. Software: I am using SQL Server Management Studio on a windows server. Background Info: I have ...
0
votes
0answers
35 views

SQL Server 2016 installation issue

I've downloaded the SQL Server 2016 CTP 4 this evening and am trying to install it. I get this error message: "The application cannot find one of its required files, possibly because it was unable to ...
0
votes
0answers
17 views

Cannot connect to SQL Server 2008 R2 from 3rd party program

I am running SQL 2008 R2 on a pc. I usually connect to a server instance from a 3rd party program all on the same machine, but suddenly I cannot connect. When I try I get message about network ...
0
votes
0answers
12 views

Getting data from databse using mysql querry of a php form

I have made a php form and created a database sarokaar for it with a table named persons. I want to get the values of all the attributes printed. I tried but I got error: Database Sarokaar ...
0
votes
0answers
36 views

Different Sharepoint filepaths in different environments

We have a VBA application in Excel (UserForm) that users use to update another excel workbook via SQL. The two files are side by side in an MS Sharepoint folder. There are two kinds of users – first ...
0
votes
0answers
150 views

Changing Microsoft SQL Express Server 2012 Shared Feature Directory

I know that in order to change any directory location, when installing SQL Server 2012, there mustn't already be present other SQL products on the system, otherwise the directory text boxes and browse ...
0
votes
0answers
22 views

Excel SQL Sort Greyed out

I have an excel sheet with multiple Teradata connections. I am trying to sort/filter the data by description, but I am unable to as the sort/filter button is currently greyed out. I need to keep the ...
0
votes
0answers
337 views

SQL Installation hanging on windows 10

I've tried installed every version of SQL Express I can get my hands on (And I've got the MSDN SQL 2016 CTP 2). Everythings hangs, and always at this point. I've a feeling its a .net related issue ...
0
votes
0answers
22 views

How do I modify the definition of a view in Sequel Pro?

I just switched to Sequel Pro (OSX) from HeidiSQL (Windows), and can't seem to find an easy way to modify the base query of a view. Is there something I'm missing? Or do I have to drop the view and ...
0
votes
0answers
24 views

SQL: Are Searches Faster at Identifying Distinct Rows If More Attributes Are Tested?

Given a large database table, and the foreknowledge that a unique row with qualities you know is in there, can the row be retrieved faster if more attributes are tested for known values? Or, will the ...
0
votes
0answers
576 views

Notepad++ custom folding keywords in existing language

I use notepad for sql code that has "REGION" blocks like the above that I would like to be able to fold -- REGION MODE 3 - DELETE MODE WHEN 3 THEN DELETE FROM EDMX.M1_BRIEF WHERE ID = TID ; SET ...
0
votes
0answers
57 views

command for running script?

I was wondering what command would get the batch file to read a seperate text file and use all of that code in a database.. if that didn't make sense I'll do my best to explain: I have a text file ...
0
votes
0answers
57 views

Stanford Wrangler ideal, but imposes limits, what are other options?

Stanford Wrangle tool is quite amazing, and I solved a giant problem with it, but it limits me to very small size. My file is about 500MB, and it allows me to process less than 1MB, the remaining data ...
0
votes
0answers
40 views

Accessing the columns of a form in an sql query

I would like to query the a table using a form which has three columns but with the code below I can only access the first column. The columns I wish to include are course_no, location and start_date. ...
0
votes
0answers
295 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
101 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
15 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
0answers
192 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 ...
0
votes
0answers
99 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 ...
0
votes
0answers
116 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), ...
-1
votes
0answers
23 views

Extract Data from Sql and display the results to excel sheet

I am trying to execute this code, but it does nothing and shows no errors too. Basically, I am trying to extract specific information from sql table and display the results in excel. I have a button ...
-1
votes
0answers
13 views

mutt command is not working with huge file size, Can anyone suggest for the same

I am using 'mutt' to send the small number of records(fetched from database and converted into CSV) through email, while if the record grows till 400k from database mutt is not able to send that huge ...