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

learn more… | top users | synonyms

-2
votes
0answers
12 views

Recovering a SQL Server 6.0 Database from a Corrupt .mdf. [on hold]

I've searched around and to no avail have found a solution. My situation is: -Working SQL server directory was deleted, no backups of said directory or full database backups (oh joy!), -Recovered the ...
0
votes
2answers
30 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 ...
-1
votes
0answers
26 views

LAN Transfer ;Ethernet vs. Fiber [closed]

I am planing to upgrade my network which is currently based on Cat 6 (copper) Cable to Fiber. i would like to know if it can help me to get more speed over the network transfers like DATA entry to my ...
2
votes
0answers
32 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 ...
0
votes
0answers
14 views

SQL databases how to link then together

Okay so I have 6 tables inside a sql database, each of them with 5million rows full of data. They have the same columns. How can I link them together? Create some sort of relation between them ? ...
0
votes
1answer
34 views

Import external data connections into Excel 2013 for use in Excel 2003

I have a workbook in Excel 2013 that retrieves data from a SQL database via a query. However, the connection imports data as a table, which is incompatible with Excel 2003. Is there a way to convert ...
0
votes
0answers
8 views

New to SQL Server 2008 and setting up specific report [migrated]

I am considerably new to the workings of SQL and I am stumbling my way through setting up reporting for some data. Here is my code SELECT [course_book no_], [customer no_], [not a ...
0
votes
1answer
23 views

Notepad++ syntax highlighting sql within php file

I love Notepad++, partly because of its syntax highlighting: in a .php file, it will highlight <script> blocks as javascript, <style> blocks as css and <?php blocks as php. Ideally ...
-2
votes
1answer
20 views

SQL Server Management Studio for sql server 2008 [closed]

Is there any other version of SQL Server Management Studio except EXPRESS one? I need one for MS SQL Server 2008 STD version. I've been trying to search almost everywhere, but it seems there is not. ...
0
votes
0answers
6 views

SQL Query for a Range of Values and One More Value [migrated]

How would I write a SQL query in MySQL to select all from a certain table where the values are between 1 and 10 and also include the value of item 15 in the results of that same query? I mean ...
3
votes
1answer
35 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 ...
-1
votes
1answer
22 views

What are the differences between LDAP and SQL?

I have read that LDAP is used to store information about users and many other objects. Since this can be done with any databases like SQL, why LDAP is used for this purpose?
1
vote
1answer
18 views

Is it possible to access any databases other than MySQL using phpmyadmin?

I heard that phpmyadmin is a GUI used to access MySQL DB. I wish to know whether any other databases are compatible to work with phpmyadmin.
0
votes
1answer
19 views

Why do URL parameters pose a security threat?

I know with SQL Injection attacks on the rise, websites have to tighten up on security. I understand that 'Dorks' are usually how they get in. Why does e.g. php?id=x pose a possible threat to the ...
0
votes
0answers
26 views

Select last four from credit card field and place in new field

I am new here. I hope this is the correct place to post this? I have a table ("accounts") in Advantage DB with two fields (CCNo & LastFour). CCNo is Credit Card Number. Last Four is the last four ...
0
votes
1answer
20 views

Sql Server 2012 Replication Report

We have about 30 users with local installs of SQL Server that have to replicate merge their local data once a month with a central SQL Server 2012 repository. Is there a SQL Server first-party or ...
1
vote
0answers
35 views

Missing arguments in SQL 2012 command line installation

I am new to SQL installation through command line. We are developing an application and using Installation Shield. I need to install SQL server on clients pc, so I am using command line silent ...
1
vote
1answer
1k views

Execute SQL Query with VBA and fill sheet with data

Very new to any form of code. Attempting to run a script in VBA that will pull data from an access database using SQL and put it into an excel spreadsheet. Code is similar to below. Runs clean but I ...
-1
votes
1answer
76 views

Missing MySQL Database after Windows Upgrade

First of all, please bear with me as I am quite new to HeidiSQL, MySQL, and the concept of relational databases as a whole. I recently started using HeidiSQL in order to create tables for import into ...
0
votes
1answer
37 views

Microsoft Query in Excel Returning Blank

In this post I was given a solution that relies on the following SQL: SELECT `S1`.DATES , `S1`.NAMES , MAX(`LS`.DATES) FROM `C:LOCATION`.`Sheet1$` `S1` LEFT OUTER JOIN `C:\LOCATION`.`LargerSheet$` ...
0
votes
1answer
20 views

SQL Code Error `Characters found after end of SQL statement`

I have the following SQL code that I am trying to run in Microsoft Query, but I keep running into the error Characters found after end of SQL statement. I understand this might be happening because ...
1
vote
1answer
64 views

Oracle SQL Select: If not exist, leave blank

I have two tables: Table1 [ID] [Number] 1 40 2 100 3 7 and Table2 [ID] [Number] [Name] 1 40 A 3 7 C Data originates in Table1, then gets copied to ...
0
votes
1answer
42 views

SQL Developer 4 Toolbar

Recently my SQL Developer toolbar became messed up. I'm not sure what I did, and I can't change it back. When I got to View-->Show toolbars-->Customize Main Toolbar, it just says ...
0
votes
0answers
27 views

SQL Server Error

I am getting the following error: Executing (Error) Messages Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Base Unit of Measure " returned status value ...
0
votes
1answer
23 views

what this datetime is used for in DB query [closed]

I acme across a db query @retVal = (DATEDIFF(s, '19700101', GETUTCDATE()) - dateTime) what this datetime used for ?? n what this query returns
0
votes
0answers
26 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 ...
-1
votes
1answer
1k views

'sqlcmd' is not recognized as an internal or external command

(I know this isn't really meant for here, but I can't ask questios on Stack Exchange) I'm creating a batch file and I get this error message: 'sqlcmd' is not recognized as an internal or external ...
0
votes
1answer
19 views

Creating tables in SQL [closed]

I'm trying to create a table using SQL and being a beginner I have no idea where I'm going wrong.. This is my code: CREATE TABLE 'test_11' ( `Company_Name` varchar(160), `Company_Number` ...
0
votes
0answers
15 views

How to view MSSQL logfiles to investigate errors made by remote connection?

I am having MSSQL 2012 running on some computer, and I am connecting to a certain database from a different computer remotely to perform a bunch of SQL commands. However, these commands have problems, ...
2
votes
1answer
211 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 ...
0
votes
2answers
71 views

How to perform sql query on sheets of excel

I have two tables in excel(sheets) . One has 10,000 entries , another has 1000 entries . Both of them have account number column in common . I want to select only those row in 10,000 entries which ...
-1
votes
1answer
49 views

SQL remove everything behind a comma in string [closed]

I have a mysql table storing some data. One column stores strings containing a comma. I want to get rid of everything (including the comma) in this string and save it, but I don't get it to work. I ...
0
votes
0answers
51 views

How to create installer for my visual basic project with sql server 2008 database?

Hi guys I have a visual basic project and I developed it using visual studio 2010 and sql server 2008 for my database. Now, I want to make an installer that will include my sql server database. I ...
1
vote
1answer
49 views

How to connect to SQL database with Windows 7

I have a third party database program on one of our servers. With Windows XP we simply create a desktop shortcut which starts the application (\apps-server\icad\msassets.exe). When I attempt to run ...
-1
votes
1answer
159 views

getting error in mysql— #1064 error while creating trigger

I need to create a trigger for a table called try.. which will execute after something is entered into the table..(I am using phpmyadmin mysql) But i am getting #1064 error while creating it.. My ...
0
votes
2answers
350 views

How do I connect to some local DB server in MS SQL Server 2012?

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
0
votes
1answer
31 views

How to create a database from psql user (not linux user)

I' ve studied some PostgreSQL. In the principle i' ve been teach to create a postgress's user with same name of my linux's user. Now i want to try to make an application, and for this reason i would ...
0
votes
0answers
36 views

SQL Server Data Input

I am new to SQL databases. Due to the huge data that I am dealing with I decided to create a SQL server. My data is mostly in the format of index_1(text) index_2(text) index_3(text) ...
2
votes
1answer
298 views

How to import Dates from Excel into Access with text in some cells?

I am attempting to import a date column from Excel into Access. The problem is that over the years, users of the Excel spreadsheet sporadically inserted text notes into this date column a few ...
0
votes
1answer
18 views

Join 2 mssql queries

I need to join to MSSQL queries, but I am not getting anywhere with this. Both queries return a single value: SELECT COUNT(*) FROM sysjobhistory WHERE run_status <> 1 AND step_id = 0; ...
2
votes
1answer
140 views

Should I install SQL Server on a SSD drive (educational purposes only)?

I have just started using a 120 GB SSD drive on my laptop. I wonder if it is a good idea to install SQL-Server on this partition. I am sure I will want to install Management Studio there but what ...
1
vote
1answer
62 views

Oracle database block diagram or map

I have an Oracle database. It has multiple schemas, and each schema has many tables. Is there a way to generate a tree diagram or block diagram, such as this image, to visualize the database? I ...
0
votes
1answer
315 views

SQL 2012 in Hyper-V. Why are my queries slow until I drop and create any spatial index?

I have a spatial application that queries several tables (layers) each time the user pans/zooms the map. When I moved the SQL server into Hyper-V, I noticed that there was a several second delay when ...
2
votes
1answer
1k 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 ...
1
vote
1answer
25 views

Possibiliy to display results SQL query in windows (monitoring purposes)

Case (one example) #1: Our business application processes documents in the background. Using MS SQL Management Studio I can create/run a query to display results. For example the current queue of ...
0
votes
0answers
83 views

invalid default value in SQL export

I exported a database with phpmyadmin, and am now attempting to import the database with PMA on a different machine, but I'm getting this weird error. What can I try as a solution? Error SQL query: ...
0
votes
0answers
39 views

How do I nest sp_msforeachtable in sp_msforeachdb?

Essentially I'm trying to select the top 100 rows for each table in each db on the server I could accomplish that using a cursor and metadata tables I guess, but can this be accomplished using the ...
3
votes
1answer
454 views

how do I check for sql injection in cookie

I am using sqlmap to test my website for vulnerabilities. However rather than testing for vulnerable variables in URL, I would like to test if cookie values are subject to sql injection. Is there a ...
0
votes
1answer
49 views

Error in installation of SQL Server 2008 Management Studio

I have installed SQL Server 2008 Express on my machine but I can't find the Management Studio. I downloaded two versions of SQL Server Management Studio, 2008 and R2 This is the result I don't ...
0
votes
2answers
175 views

Numbers are not displaying properly in excel report

n excel report generation, numbers are displaying 7.70225E+11 but it should display like 770225145579 . Any one please help to solve this issue. My code is, <?php include("connection.php"); ...