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

19
votes
6answers
22k views

Is it possible to open a SQLite database from within Microsoft SQL Server Management Studio?

Is there a way to open a .db file (SQLite database file) from within Microsoft SQL Server Management Studio? Right now we have a process that will grab the data from a Microsoft SQL Server database ...
-1
votes
0answers
28 views

Case when SQL statement into variable [migrated]

i need to create a variable for a 'case when statement' on sybase sql. I have this error from my sql client ' A SELECT statement that assigns a value to a variable must not be combined with data-...
-1
votes
0answers
8 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
12 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 ...
1
vote
2answers
32 views

sql - year day to day/month conversion

suppose I have the following table +-----------+-------------+ | DAY | LEAP YEAR | +-----------+-------------+ | 7 | true | | 167 | false | | 43 | true ...
1
vote
3answers
3k views

Microsoft SQL. SELECT FROM WHERE query with varchar type column

Inside the SQL Server Management Studio I am trying a query like this: In human words: Give me all rows from the table where the string in the column "name" is "alice". My not working attempt on ...
0
votes
1answer
39 views

how to find out session id of executing ssis package through SP_target

I am executing a ssis Package which contains only one data flow task. Simply SELECT statement in source and Table in destination. I want to find out session id of this running Package in SP_TARGET. I ...
2
votes
2answers
6k views

Event log warning Registry setting specifying configuration file does not exist

Microsoft SSIS Service: Registry setting specifying configuration file does not exist. Attempting to load default config file. For more information, see Help and Support Center at http://go....
0
votes
0answers
5 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
1answer
28 views

Using SQL to merge .xlsx file and over 1,000,000 rows?

I'm having trouble with an operation that I believe is limited by the shear size of the data - the operation is a merge and filtration of two Excel workbooks, each with over 1 million rows. Perhaps ...
-1
votes
2answers
118 views

MSSQL 2016 express edition download

Been looking everywhere for this download but can't find it ?MS didn't not released the Express edition ??? ?Did they had any problems creating the express edition SKU for the release date (today, ...
-1
votes
2answers
161 views

SQL/DB browser for DB2

I'm looking for a simple SQL browser which supports DB2. I just want to be able to connect to a DB and try some queries.
3
votes
2answers
27k 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), ...
1
vote
0answers
25 views

In SQL SERVER how to do ;Third Computed Column = First Computed Column + Second Computed Column + Basic Column [closed]

I use SQL Server. I have a table with A. One column is for "Interest" B. There are three computed columns : First_val , Second_val , Third_val First_val = 10 % of Interest , Second_val = 20 % of ...
1
vote
1answer
43 views

Running Parameterized Stored Proc From Power Query

I have been following the tutorial HERE but anytime I try to refresh the workbook, it gives me an error of: DataSource.Error: Microsoft SQL: This database function doesn't support the query option ...
0
votes
1answer
21 views

Error when installing SQL Server on new machine

I am installing SQL Server on a brand new laptop with no previous users. Unfortunately I am getting the following error: Has anyone seen this before and know the cause of it?
2
votes
1answer
19 views

In Microsoft SQL Server, how can I disable “X rows affected” at the end of my output?

I'm querying a database in Microsoft SQL Server and writing the output to a csv file. When importing the outputdata into another program i get an error because the last line of my output file ...
0
votes
0answers
17 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 ...
2
votes
4answers
1k views

Running Windows Powershell Scripts simply opens it in the editor

I have a Windows powershell script that works fine in the interactive editor. The script is a simple one line sql cmd: sqlcmd -S servername -d dbname -E -W -w 999 -s "," -Q "SELECT select col1,col2,''...
1
vote
1answer
985 views

mysqldump not on wamp server

I am trying to use mysqldump on my wamp server mysql console however, it doesn't seem to have mysqldump included. I found the mysqldump.exe file in this location: /cygdrive/c/wamp/bin/mysql/mysql5.6....
0
votes
1answer
16 views

Nested IFF query in MSAccess returning wrong number of arguments

I am trying to write a nested IFF query in MSAccess, but on running the error returned is "Wrong number of arguments" My two fields Paper1 and Paper2 are of datatype True/False The Query I wrote in ...
0
votes
1answer
28 views

How do you free up Disk Space on a Windows 7 OS? [duplicate]

I've downloaded the sqlexprwt_x64_enu.exe file which was around 700mb and I'm trying to open up the file, but I keep getting the error message of "Unable to find a volume with enough disk space for ...
1
vote
1answer
45 views

Outer join with union in Excel 2010 using Power Query

I've got two tables (two worksheets of the same workbook in Excel 2010): The result should look like this: My SQL code works well: SELECT table_2.ID, table_1.value_1, table_2.value_2 FROM ...
0
votes
1answer
36 views

(SSIS) Data Flow Task – export SQL to excel file

I'm looking for a solution / tutorial following case. In the MS SQL database I have two tables (invoice, invoice item). I need to export data to excel. My problem is the structure of the export ...
14
votes
5answers
10k 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?
2
votes
2answers
6k 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?
0
votes
1answer
48 views

How do you make a read-write data connection between two Excel worksheets? (I am currently using an od.odc file and a connection that uses SQL)

I have the following project started: Inside of Master.xlsx I have (the worksheet is named MasterList): I then go into CA_Accts.xlsx and make a data connection, with the following steps: ...
0
votes
1answer
18 views

Clustered SQL database requires full recovery mode?

The application we provide customers with requires an SQL database. Due to the nature of the application, we recommend the recovery mode to be set to Simple as it is not critical data that is stored. ...
-2
votes
1answer
18 views

Convert a (-ve) number to a (+ve) or absolute

How do I update a field in a SQL table to change a neg to a pos. (Multiply *-1) I have some data that was loaded using a mapper tool. Unfortunately the data should have been - and was +. The software ...
1
vote
2answers
260 views

Can't install SMSS 2016 March Preview

I am trying to install the latest Microsoft SQL Server Management Studio release. This is what the installation log looks like just before the installation fails: [44C4:4610][2016-04-03T23:15:57]i000:...
10
votes
6answers
10k views

SQL management studio hangs when opening after being closed down on dual screen

I have a dual screen set-up. I'm running windows 8.1. I have had this issue with Management studio 2008 R2, 2012 and 2014. If I drag the management studio screen across to my 2nd display, and then ...
0
votes
0answers
40 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
43 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
63 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 ...
2
votes
1answer
6k views

How do you create a SQL query in Excel 2007 with a dynamic date range?

I am trying to create a reporting spreadsheet that can print reports for a given time period. The query below works, but when I try to use a ? parameter in place of the date, I get an error after ...
1
vote
1answer
434 views

How to find out MS SQL Server Enterprise Edition Expiration Date?

I have MS SQL Server Enterprise 64bit Install on VMplayer, Version: 11.0.3128.0 Product LVL: SP1 Upon installed, there is no documents indicates how long this license will last. Anyone can ...
3
votes
1answer
5k 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. ...
3
votes
1answer
58 views

SQL Result to excel file

In Microsoft SQL Service Management Studio, there is an option to send results to file when a query is executed. Is it possible for that result to be changed to excel format? Are there other ways to ...
0
votes
0answers
11 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
10 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
1answer
18 views

MS SQL equivalent of MyISAM?

I'm trying to port an old project from Linux onto current Windows (mostly as a learning exercise). The database side is all MySQL and every table uses TYPE=MyISAM, which I've done a little reading on ...
3
votes
2answers
4k views

How to export data from Excel to SQL Azure?

I know how to import data from SQL Azure into Excel From Excel go to: - Data - From Other Sources - From SQL Server I want to manually edit data and post it back to SQL Azure. What is the ...
1
vote
2answers
340 views

Sql Statements in MySQL, the use of the dot operator

The following is the sql statement that I found, and I am still learning SQL thus this might be a silly question for you. SELECT d.name, count(e.emp_id) num_employees FROM department d INNER JOIN ...
1
vote
1answer
30 views

MS SQL query which split to other table columns

I have two table: table1: |Manager | USER | +--------+------+ |John | Tom | |John | David| |John | Marry| |James | Henry| table2: Now is empty, but must be like: |Manager|User1|User2|...
5
votes
2answers
25k views

How can I make Excel fetch data from a database automatically when I open the spreadsheet?

I want to have an excel spreadsheet, that when it opens will automatically populate from a SQL database, using specific queries. Each Workbook would use a different query (or multiple queries). ...
1
vote
1answer
341 views

Installation error while Installing SQL Server 2014 Standard Edition

I have tried to install Microsoft SQL Server 2014 Standard Edition and it is giving the error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: ...
0
votes
3answers
97 views

How to access SQL Configuration Manager

Upon checking the programs installed on my machine, it says that I have SQL Server 2014 installed. However I can't access the Configuration Manager in the "All apps" of the start menu to make a ...
0
votes
0answers
29 views

Wordpress : clean a infected SQL dump [closed]

I'm currently recovering a wordpress website from an infection (due to Gravity form plugin). I'm backing up the files and the db, in order to perform a clean install on a new WP installation. So ...
0
votes
0answers
50 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 ...