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

learn more… | top users | synonyms

0
votes
2answers
28 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
16 views

SQL remove everything behind a comma in string [on hold]

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 ...
2
votes
4answers
456 views

MySQL - “Root Element is Missing”

Something has happened to the MySQL server installation on my computer. Normally, the MySQL notifier program, which is supposed to start automatically and run in the system tray has stopped starting ...
3
votes
2answers
2k views

Can I use SQL to build an Excel data table from other Excel files?

I know SQL well enough to perform basic queries and manipulate data split into multiple tables in a database. I know Excel 2007 a bit better and use it frequently to manage my mechanical engineering ...
0
votes
0answers
10 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
25 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 ...
0
votes
2answers
33 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 ...
2
votes
1answer
24 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 ...
-1
votes
1answer
25 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
2k views

SQL Server 2012 configuration manager not opening in windows 8.1

I run SQLServerManager11.msc in apps to search but nothing happen. Need Help. It is install and showed in control panel.
0
votes
0answers
5 views

When is a default value initialized? [migrated]

create table tab3(a integer,d1 datetime default getdate()) insert into tab3(a) values(1) insert into tab3 (a) select a from tab3 GO 20 insert into tab3 (a) select a from tab3 select d1,count(*) from ...
0
votes
2answers
118 views

Can't detach database in SQL Server Management Studio after accidentally deleted mdf file

I'm working with a bunch of *.mdf files which I'm attaching on my local computer. After I accidentally deleted the a folder containing some of the *.mdf files, I'm unable to view the databases in SQL ...
0
votes
1answer
11 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 ...
6
votes
3answers
4k 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?
0
votes
0answers
27 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) ...
0
votes
1answer
12 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; ...
1
vote
1answer
24 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 ...
2
votes
1answer
35 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 ...
0
votes
3answers
533 views

SQL command for selecting multiple records within range

I'm relatively new to SQL and am looking for a command that I can run in order to find all records within a database within .5 of a calculated value. For example: SELECT X, (Y/Z) AS ZZ FROM Table ...
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?
0
votes
1answer
17 views

how to delete taggregate_temp_ tables at once?

In my SQL I have multi tables like: taggregate_temp_1364792160 taggregate_temp_1364795760 taggregate_temp_1364799360 taggregate_temp_1364802960 taggregate_temp_1364806560 taggregate_temp_1364810160 ...
0
votes
0answers
50 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
1answer
124 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
27 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 ...
1
vote
1answer
316 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
vote
1answer
16 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
29 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: ...
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
16 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
59 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
22 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 ...
1
vote
3answers
1k views

Real-time graphing application for SQL data

I am looking for a free data graphing application that can pull data from MySQL and display it on a trend graph without any programming. It should use a GUI to select the data to be plotted, start ...
0
votes
1answer
13 views

OpenOffice showing syntax eror

Here's what I have so far: SELECT DISTINCT Min("gpa"."current_gpa"), "students"."lastname", "students"."firstname" FROM "students", "gpa" WHERE ...
0
votes
2answers
47 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"); ...
0
votes
0answers
66 views

Publish a local SQL database to existing database on remote server

I am trying to publish my MVC website with two SQL databases from Visual Studio 2013 Web Express to an Arvixe server. I have followed this tutorial: ...
0
votes
1answer
61 views

Can i give foreign key relationships of ODBC tables from ms sql to ms access

I have a question regarding the ODBC relationships between SQL and MS ACCESS as i have migrated several tables from SQL to ms access and i performed some operations but the problem occured in ...
0
votes
1answer
216 views

Syntax highlighting for sql files on sublime text

I want to install syntax highlighting in my sublime text program for those extensions : .plpgsql .sql .plsql Somebody know how to do it ? I have installed some packages but there was no results. ...
0
votes
1answer
32 views

How to repair .mdf file?

My sql databases in SQL Server 2014 has the status "suspend" as I saw in SQL Management Studio. I can't restore to serviceable condition sql databases through standard procedures. I need to restore ...
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 ...
0
votes
0answers
305 views

What services to disable to stop sharepoint in sbs 2011

So, I'm looking to disable sharepoint in sbs 2011. I don't want to uninstall it because I've read that it will cause update errors, but It's throwing a lot of errors itself and we don't use it, so I ...
0
votes
1answer
53 views

Cascade combo box query sorting

I have a question regarding ms access 2007 query sorting for the cascade combo box. As i have initially 3 tables with names country,state and city and i want to have a combo box such a way that if i ...
0
votes
1answer
76 views

Is there a function in Excel or Access to reshape a table to First Normal Form, or a way to do it in SQL?

Very often tables are presented in Excel files in a non-normalized form. I have one such table which I wish to take into (somewhat) First Normal Form using either SQL commands in Access or, ...
3
votes
2answers
1k views

SQL Server Management Studio print in color

I am using SQL Server Management Studio 2012. I am trying to print a stored procedure in the color-coded syntax that it loves showing me, but cannot find an option to enable this. Any ideas? I know ...
0
votes
2answers
1k views

DataStage Client 8.5 Installation Error on Windows 7

I am trying to install Datastage Client 8.5 on Windows 7 x64 and getting the below error: com.ibm.is.install.exception.ActionException: CDIIN5032E: Exception caught by ExecuteProcessAction.: ...
0
votes
1answer
41 views

SSMS query editing: possible to remove a field and have the matching value removed?

I work with large queries in SSMS. It would be fantastic if I could easily match up the comma-separated values with the comma-separated field names. I often delete a field, and then have to hunt for ...
0
votes
2answers
148 views

Where are Google chrome passwords stored in windows?

I know that Google Chrome stores the login data at LocalAppData\Google\Chrome\User Data\Default\Login Data but this doesn't shows the password, password value shows as the single special character. I ...
1
vote
0answers
225 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. ...
0
votes
1answer
125 views

Transpose data at particular row w python,r,sql?

Lets say I've got following data (about 50k of rows in real example) A B C D E X A B C D E F G H X And I want it to look A,B,C,D,E,X A,B,C,D,E,F,G,H,X So technically I want to transpose ...
0
votes
0answers
17 views

Software for creating DB alter script that ONLY uses DDL scripts

I am looking for a software which can compare two databases by ONLY using DDL script (i.e. I dont want to create a schema but rather do it on the fly). Is this possible ? Any ideas ?
-1
votes
2answers
146 views

SQL Server Database Encryption [closed]

Let's say two programmers are working on a website for a store. They've created a small database for an online store. Users would have to register and provide a username(e-mail address) password,home ...