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

0
votes
0answers
10 views

Running Oracle (11g) script in VBA to extract data to Excel [on hold]

We have a number of saved Oracle scripts (PL/SQL queries) that we routinely run to extract data to Excel for end users. I know its possible to convert these queries in VBA and add 'buttons' to an ...
0
votes
0answers
26 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 ...
1
vote
0answers
32 views

Back up a database nightly [migrated]

Question: Is it possible to automate the process of coping a full database every night into the development database on the same server? Software: Windows Server, SQL, SQL Server Management Studio, ...
0
votes
0answers
6 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 ...
-2
votes
1answer
21 views

Prerequisites to get SQL cmd in computer

I want to get SQL cmd in my system. Could someone please guide me the complete steps? Even though I have a native client installed, sql cmd is still not appearing in the command prompt even by typing ...
1
vote
0answers
18 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 empty, but must be like that: |Manager|User1|User2|User3| ...
2
votes
1answer
27 views

Convert DateTime with Decimal Time Longer Than 3 digits?

I'm trying to import some data from CSV into MS SQL 2008 Server. I'm using PowerShell's Invoke-SQL, and an SQL script that utilizes BULK INSERT. CSV fields get imported as VarChars and I'm trying to ...
0
votes
2answers
17 views

UTF-8 not recognized in SQL batch process through Putty

I have an .sql file with a few simple "Insert into" SQL commands that are being inserted into a table called Künstler. insert into Künstler (name) values ('Mariah Carey'); insert into Künstler (name) ...
-1
votes
1answer
21 views

commands to upload sql file to database

There is a database file in this path : /var/www/db.sql in server. Our database size is about 800mb. we have to upload this sql file to the database : "age" username : root, password : pass, ...
2
votes
1answer
78 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 ...
0
votes
2answers
24 views

SQL - How to Stop MYSQL from command line

I just noticed when I made an error statement, sometimes, it didn't stop or showed the error. Instead, the line kept going like this one mysql > UPDATE person ->SET birth_data = ...
0
votes
0answers
21 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 ...
-2
votes
1answer
23 views

SQL Server licensing in a virtualised environment

My company has 6 instances of SQL Server 2012 Standard. These instances all run on VMware virtual machines. The licenses for SQL Server came packaged with WonderWare products (WonderWare Historian for ...
2
votes
1answer
30 views

Add column in SQL

I am currently learning SQL, and my current question is. Is it bad practice to have the word "COLUMN" after add when you want to add a column in SQL code? ALTER TABLE FICTION add COLUMN Best_Seller ...
0
votes
0answers
13 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
9 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
1answer
26 views

update multiple fields in SQL

I am trying to update my table in SQL 2012 where the CategoryNumber values should be correspondant for the below name values but it seems that my syntax is wrong. Update mytable SET ...
0
votes
0answers
26 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
1answer
69 views

SQL Server Management Studio (SSMS) 2012 slow to show results in Grid only

I generally use Microsoft SQL Server Management Studio 2012 (11.0.3000.0) with query results being displayed in a grid. As of 3 or 4 days ago query results have been quite slow, but only ...
0
votes
1answer
24 views

Date values from SQL cannot be filtered in EXCEL

I created a VIEW in SQL which contains a date column. The date column is defined as datetime ,I had to use CONVERT (nvarchar.mydate,103) so I can get the following format : dd/mm/yyyy. Now when I ...
0
votes
1answer
41 views

Replace a filepath column in SQL with new file structure

I have recently changed the structure of a drive where I keep a lot of my 'estimating' files. The problem is, I use a program that has references to some of those files, in the old structure, stored ...
1
vote
1answer
97 views

Submit data to db and load next page PHP and SQL

This is just a test page I am working on. Trying to get my submit button to load the next page "order.php" It just keeps loading the same page. Should I be writing this in PHP or HTML? If you look ...
0
votes
1answer
48 views

what will happen when two users submit same form and the php code having more than one queries will be executed on the server?

I want to ask that what will happen when two user will submit the same form and then the php code having more than one queries in more than one for loops and if statements which alter the table data ...
0
votes
3answers
62 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
1answer
129 views

In Access, how can I pull data from another table by matching a field?

I am working on an inventory system for a tool rental shop. I have two tables: Details and Tracking. Details has all the basic information about all the customers (Name, Barcode, ID etc.). Tracking is ...
0
votes
1answer
16 views

Is it possible to get SQL string generated from clicking through UI commands in SQL Server Management Studio?

Ok, so SQL Server Management Studio (SSMS) lets me backup and restore SQL databases, which is pretty awesome an application QA Tester. It allows me to test different starting configurations without ...
0
votes
1answer
62 views

Transform a CSV with Notepad++

Suppose I have a CSV file like this: 1,"abc",,,, 2,"def",,,"ghi", 3,,"jkl",,,"mno" Now I need to transform it in 3 steps: Replace all empty spaces with the String NULL Add at the beginning of ...
-1
votes
2answers
52 views

Select distinct from after certain date [closed]

I have a DB with 3 tables: classes, teacher and taught: classes ID (classNum) title (classesType) cost (classesCost) teacher unique int (teacherNum) taught ...
0
votes
0answers
96 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 ...
-1
votes
2answers
44 views

how to use the &command in SQL insert into statement?

what is the syntax of the insert into statement wherein SQL prompts for input? like for example, if I have attributes "name" and "age" in a student table and I write an insert query , SQL will prompt ...
1
vote
0answers
31 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 ?
0
votes
0answers
21 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
245 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
1answer
32 views

How can I detect the changes in my SQL Server database

I want to know the exact changes in my SQL Server database? Can I see the complete changes in a SQL Database
7
votes
1answer
10k views

When will SSDT-BI be available for Visual Studio 2015

From Microsoft's download page, SSDT-BI (SQL Server Data Tools Business Intelligence) for Visual Studio 2013 is available but not for 2015. When will Microsoft release SSDT-BI for VS 2015? ...
0
votes
0answers
13 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
1answer
69 views

Sorting in SSRS 2008

I am trying to sort a column from largest value to smallest in SSRS 2008. These values are derived from an expression, not an actual data field. So I am wondering if there is a way to sort this ...
0
votes
1answer
30 views

How to restore MS SQL logon password

I am running MS SQL Server. The SQLSERVICE logon password was changed incorrectly and now I'm getting a logon failure warning when starting it. Is there any way to restore previous used password?
1
vote
1answer
644 views

Invalid field count in CSV input on line XX in phpmyadmin?

I have a 16MB CSV file with 50,000 lines that I want to import into my database. I go to the PHPMyAdmin-Interface, choose IMPORT and set the correct options. The import fails with the error Invalid ...
0
votes
1answer
12 views

Error when trying to SET field in MySQL

I am trying to set the field block, in the table h8cyw_users, to 1 where the email field in both tables are the same. I am using the following script: UPDATE UPDATE table1 SET block='1' WHERE email ...
0
votes
1answer
34 views

Is there a database that speaks pure SQL?

My understanding is that SQL is the standardized basic framework for quite a variety of different SQL flavors like MS SQL, MySQL, PostgreSQL, ... But all of these different flavors introduce a ...
2
votes
3answers
164 views

Can't include an HTML link in PHP script, but works fine as MySQL query

I'm using the following as part of a PHP script: mysqli_query($con,"UPDATE table SET description='<a href="http://123456.biz/index.php/123/321/456/*/789">text</a>' WHERE description IS ...
0
votes
1answer
21 views

null values aren't returned unless specified - Oracle SQL

When attempting to run a select statement that simply excludes some data, null values are wrongfully (?) being excluded as well. Using table a: ID NAME 1 Foo 2 Bar 3 ...
1
vote
0answers
334 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
1answer
35 views

Handle Multiple entries in Fact table in Data Cube

We have been constructing data cube for our project in which we are facing a problem like 1 to many relationship in the dimension tables and making entries in fact table (duplication). ...
0
votes
0answers
228 views

Remove extra blank line in the bottom of spool file

I am creating a spool file. Problem is that it creates a blank row in the bottom which i do not need. I am running the .sql in windows. Any suggestions? below is the sql : ...
1
vote
2answers
89 views

How to properly delete all page content in MediaWiki?

I found this page that explains how to delete all pages in MediaWiki but I'm not at all convinced that running DELETE FROM page; is a good idea. The MediaWiki schema is pretty complex and just ...
1
vote
0answers
52 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
1answer
59 views

Dynamic data sheet combined with one static

I am using a sheet in excel which pulls data out automatically SQL from a database. Fills in maybe 20 or so columns with orderinfo. In column A i have a unique order no. What i want to achieve is ...
1
vote
0answers
46 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 ...