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
11answers
5k views

How do hackers know what and how to hack a system?

I've been reading through a couple of posts about how to prevent your system from being hacked and I would like to know how a hacker actually knows how to exploit the system? For example, everyone ...
18
votes
6answers
16k views

Is it possible to open a sqlite database from within microsoft sql management studio?

Is there a way to open a .db file (sqlite database file) from within microsoft sql management studio? Right now we have a process that will grab the data from a microsoft sql server database and put ...
15
votes
2answers
83k views

Run an SQL Query With a Parameter from Excel 2007

I have a query in an excel table. I followed this to do it. But how can I add a parameter from a cell into my query? I am looking for a way to do this select * from dbo.Customers where CustomerID ...
9
votes
2answers
11k views

How to open several tables in different tabs in SQL Developer

I have several schemes and need to open different tables in different tabs from different schemes at the same time. SQL Developer opens the table view in the same tab. Clicking whilst holding Ctrl ...
8
votes
4answers
7k 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?
5
votes
3answers
2k views

How to use Microsoft SQL Server 2008 as a simple database for testing

As a student, I get Microsoft SQL Server 2008 R2 for free through MSDNAA. I installed it, but I seem to be at a loss for how to use it to test database queries, and how to construct a database with ...
5
votes
5answers
4k 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 ...
5
votes
2answers
17k 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). ...
5
votes
1answer
7k views

How can I get sql server profiler installed

I have Sql Server 2008 R2 installed. But in Management Studio, under Tools menu, I don't see Profiler. What feature do I need to install in order to get profiler?
4
votes
4answers
53k views

How to open sql file as a table?

Someone gave me a file with extension sql, but I don't know what should I use to open it. I can open it with a text editor, but I would like to view it as a table. Is there any software that can do it ...
4
votes
3answers
7k views

Where can I obtain the SQLpackage command-line utility?

I am trying to use he SQLpackage command-line utility (sqlpackage.exe) on a SQL server, but I cannot find it anywhere online. Is it something that I can download as a standalone utility, or is it ...
4
votes
5answers
2k 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 ...
4
votes
0answers
364 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 ...
4
votes
1answer
250 views

Copying out color theme background from SQL management studio to Outlook

I have a color theme set in SMS 2012, where the background is dark and some of the syntax is white, when I copy and paste this out into an email (white background) the dark background of management ...
4
votes
0answers
1k views

How to associate visual studio 2012 with SQL files in Windows 8?

I'm using Windows 8 and I'm trying to make Visual Studio 2012 the default program with which to open my .sql files. I have right-clicked on a .sql file and chosen: Open with... > Choose default ...
3
votes
10answers
452 views

Warm-up .NET application

We have speed problems in corporate enviroment. Most of the notebooks are strongly loaded: the start-up time of Excel is 3-5 minutes, Outlook 10-15 minutes etc. Our application has the same start-up ...
3
votes
5answers
4k views

Excel formula - querying a Range that results a Range

I have a Range in Excel (B3:C8) from which I want to filter out the English persons. In SQL this would be dead simple: SELECT Persons FROM [myTable] WHERE Nationality = 'English' How can I apply a ...
3
votes
2answers
16k 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), ...
3
votes
1answer
135 views

SQL import size

I'm in the process of importing a couple of SQL dumps into my own mySQL server. The size of these dumps, from Wikipedia, are 2.3 GB and 22 GB. Is the size of an SQL dump file approximately the same ...
3
votes
2answers
2k 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 ...
3
votes
3answers
260 views

opening sql file hangs most of the editors but not notepad++

I sometimes need to modify url in big sql files. I usually open it up in some editor and do search and replace. On windows machine notepad++ works perfectly, it never hangs and feels snappy to show ...
3
votes
2answers
3k 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 ...
3
votes
1answer
51 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 ...
3
votes
2answers
4k views

SQL Server 2008 R2 (x86) and the Access Engine

All, I have set up the Access Database Engine for SQL Server 2008 R2 (Service Pack 1) on many machines running x64 Windows 7 without any problems running as 'Administrator' (and setting up SQL Server ...
3
votes
1answer
1k 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 ...
3
votes
1answer
4k 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
0answers
560 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 ...
2
votes
6answers
2k views

Mac software to open a 16GB SQL file? [duplicate]

Possible Duplicate: VERY large text files and Snow Leopard Open massive file on Mac? I have a 16GB sql database backup I have just taken, what software can I open it with for Mac? I have ...
2
votes
4answers
1k views

Installing SQL Server Express 2008 on Windows Server 2008

Can I install SQL Server Express 2008 on a Windows Server 2008 or should I stick with the SQL Server Express 2005?
2
votes
2answers
2k views

understanding Microsoft Download Center naming convention

The following are the download names for SQL Server Express Editions. SQLEXPR_x86_ENU.exe SQLEXPR_x64_ENU.exe SQLEXPR32_x86_ENU.exe The machine I have is a 32 bit intel machine. Which one should ...
2
votes
3answers
1k views

Cannot Attach Database in SQL Express More Than Two Directories Deep?

I have a database in one of my Visual Studio Express projects. I want to attach it to my local SQLEXPRESS instance so I can run aspnet_regsql on it and add the membership database. When I select ...
2
votes
2answers
1k views

excel - generate a username from a full name field

I'm trying to generate a username using a single name field in excel which has the person's first name and last name. I'm open to what the username would be, as long as its intuitive for the user. The ...
2
votes
3answers
85 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 ...
2
votes
4answers
214 views

Accessing a mySQL database on an external server

I have a large (multi-gigabyte) SQL database on an external server. I can access it through SSH, but manually querying the data will be a major pain. I really need a GUI. I'm using Ubuntu 13.04, but ...
2
votes
2answers
672 views

Connection Issues with SQL Server Express

I have windows 7 Ultimate, 64bit. I have installed SQL Server 2008 Express and have created a database in it. I have a jar that helps me create a connection file to connect to this database. I have ...
2
votes
1answer
903 views

Sql Server Managmenet Studio Alternative - Are there any?

I am looking for lightweight MS SQL Server Managmenet Studio (2005) alternative (open source/freeware is a bonus). Something more like HeidiSQL for MySQL. LINQPad is not an option (although it's ...
2
votes
1answer
18k 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 ...
2
votes
1answer
1k 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 ...
2
votes
1answer
5k 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 ...
2
votes
3answers
230 views

Spreadsheet RDBMS

I'm looking for a software (or set of software) that will let me combine spreadsheet and database workflows. Data entry in spreadsheet to enable simple entry from clipboard, analysis based on joins, ...
2
votes
3answers
15k views

How do I start a MySQL Server in Windows ?

I've installed a MySQL server onto my computer and when I first installed it, it ran automatically, now I've restarted my computer it is no longer running, what file do I need to run to get it back up ...
2
votes
1answer
582 views

Reuse SQL View in different sheets in SQL with different sub queries

I have an Excel document with 20+ sheets, all these sheets use the same SQL View, but they have different critirias on what to show, the only way I can get that working is to make 20 different ...
2
votes
1answer
2k views

how to connect to pervasive sql through odbc?

I am trying to add a linked server to a sql server 2012 database using ssms 2012. the linked server is pervasive sql. here's how i am trying to do it: EXEC sp_addlinkedserver @server = ...
2
votes
1answer
5k 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 ...
2
votes
1answer
8k views

How can I split a large SQL file into smaller chunks? [duplicate]

Possible Duplicate: How to split large file on Windows? I have a 100MB SQL file which my host won't let me upload all at once (2MB per upload). The database is on a different server so I ...
2
votes
1answer
94 views

Opening SQL Sever Management Studio and Databases

Is there a way when opening SQL Server Management Studio to also open databases along with it. For instance, I usually work on a minimum of 6 databases during an usual day, and if I could get the SQL ...
2
votes
1answer
84 views

What are the risks for logging across databases via a trigger?

I've searched for this online and had mixed or unclear responses. On SQL Server 2005, we currently log certain table changes via triggers using the inserted/deleted tables. Currently, our log ...
2
votes
1answer
3k 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?
2
votes
1answer
2k views

I can't install SQL Server on my PC

I have a PC with Windows XP Professional x64. And I'm trying to install a SQL Server Express x64 version. All goes well until the setup builder try's to set the necessary setup files. At this point ...
2
votes
2answers
14k views

How can I get a list of fields AND respective tables used in an MS Access 2010 database?

I know this is how you get a list of all the tables in the database (and more if you modify the critieria: SELECT * FROM MSysObjects WHERE (((MSysObjects.Type)=1) AND ((MSysObjects.Flags)=0)); But ...