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

learn more… | top users | synonyms

-1
votes
3answers
31 views

Repair a corrupt SQL database in SQL 2005

My server crashed. most stuff lost. I recovered the .mdf .ldf files through DaRT. I can not use the files. It advises that the header is corrupt. Please advise what the best way to resolve this ...
0
votes
1answer
14 views

Remove PostgreSQL database files

I've uninstalled PostgreSQL some time ago, but now I needed it again, and installed it. When running rcpostgresql I get the following: /usr/sbin/rcpostgresql Your database files were created by ...
0
votes
1answer
16 views

squirrel sql search all tables and fields - or any software

I want to find a string like "txstate" in a wordpress (or magento, etc) database and it could be in any table or field. Can this be done in SQuirreLSQL? I have searched on this and not getting ...
0
votes
0answers
19 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 ...
2
votes
1answer
28 views

Accessing a local SQL server 2014 from within a VM running vista using VS2005 fails

My laptop is running Win 7 (x64) and is part of a domain. I've installed SQL Server 2014 Dev and VS2012 on it as I want to use the laptop for development. Since some of my development has to be done ...
0
votes
1answer
46 views

Unable to make ODBC connection on Ubuntu 14.04

I usually access an ODBC connection through a CentOS server, and I'm trying to make the same connection locally on my Ubuntu Trusty laptop. So far as I can tell I've duplicated everything properly ...
0
votes
0answers
8 views

Error to install the SQL Server 2014 Express?

When I am installing the SQL Server 2014 Express, I get three messages saying: Saying the file helpexp.bmp cannot be found in directory ...
0
votes
0answers
23 views

Unable to connect SQL Server 2014 (time out)

I have followed this method (https://www.youtube.com/watch?v=VOUDdUJ5BLY) to set up my SQL Server on my computer A. My Computer B is able to connect to the SQL Server with my public IP within the same ...
0
votes
1answer
32 views

How do I host the PostgreSQL server locally? It won't let me run as SuperUser, and it won't let me log out of SuperUser

I've spent all day working on a Database project to try and teach myself how to use SQL and PHP. When I finally went to go and try to host it, the command prompt kept closing really quickly. I took a ...
0
votes
0answers
7 views

SSMS file tree does not match file tree on drive

I'm trying to add a database to my SQL server using a .mdf file, but the filetree displayed by SSMS does not reflect the filetree on my C drive, so I cannot locate my .mdf file when I try to add the ...
0
votes
1answer
68 views

Import image from MS SQL Database into Excel

I have a MS SQL Database where images are stored as byte[]. Is it possible to import these byte[] into Excel and convert them back into images? I already have a connection to the database in my Excel ...
-3
votes
1answer
32 views

i have three laptops with HD:500gb ,ram:4gb,OS:windows7 is it possible to form a cluster? If notwhy and How can I able to make use of cluster? [closed]

with HD:500gb , ram:4gb , OS:windows7 is it possible to form a cluster? If not why(i need more laptop or something) and How can I able to make use of cluster?
-1
votes
1answer
64 views

How can I translate SQL to Excel formulas?

I have an excel sheet with raw data and I want make a custom view on it in another table for reporting purposes. How can I translate the following pseudo code to Excel? select ColA, ColB, ColC from ...
1
vote
3answers
56 views

Can a database be too relational?

I have a question about database design. I'm asking here because I'm an enthusiast/hobbyist and not a "professional" so I don't want to post it on the "Database Administrators" stack exchange ...
0
votes
1answer
252 views

Microsoft Access Left Join Query Giving “Invalid Operation” Error

Here's the question: I'm getting an "Invalid Operation" error on a LEFT JOIN query and, although I think I can identify the field causing the issue, I can't figure out why and what to do to fix it. ...
0
votes
1answer
61 views

How do I check for command line parameters in sqlplus?

I am trying to write a sql file which will run under sqlplus. My goal is to create a mechanism by which sqlplus will prompt for password if no parameters are passed, and if &1 is present, continue ...
1
vote
1answer
59 views

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

superusers. Don't blame me for asking a newbie question here :p I have MS SQL Server Enterprise 64bit Install on VMplayer, Version: 11.0.3128.0 Product LVL: SP1 Upon installed, there is ...
-2
votes
1answer
83 views

How to select first NOT NULL Value? [closed]

Eg : Table COL1 COL2 COL3 ADAM NULL AAA NULL EVE BBB NULL NULL CCC How to select first NOT NULL value? Please suggest. Thanks!!!
0
votes
0answers
20 views

How to reset pkuid in QGIS

I have a sqlite layer in QGIS with autoincrementing primary key on. Then if I delete some points I would like the option to reset the number that shows up in the pkuid column. I tried in DB manager: ...
-1
votes
1answer
127 views

Owncloud - where in the SQL database is the email stored?

I am searching and searching but still cannot find it. In what table does owncloud store the email addresses?
1
vote
3answers
50 views

Show All Results From One Table Not Listed In The Other (Junction) Table By :id

I have 2 tables I'm interacting with. The first table: acl_permissions (is just a normal table). +-----------------------------------+ | acl_permissions | ...
0
votes
0answers
145 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 ...
1
vote
3answers
389 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 ...
3
votes
0answers
273 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 ...
2
votes
0answers
69 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
1answer
127 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
1answer
92 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
30 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. ...
3
votes
1answer
48 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
30 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
43 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
24 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
1answer
25 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
65 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 ...
2
votes
1answer
12k 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
133 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
77 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
57 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
220 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
100 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
37 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
29 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
34 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
3k 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
25 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
20 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
908 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
134 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
130 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
101 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 ...