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

learn more… | top users | synonyms

0
votes
3answers
4k views

Recommended utility to import .csv files into Microsoft SQL Server 2008 R2?

I'd like a better method to import .csv files into Microsoft SQL Server 2008 R2. The default import wizard maps everything, by default, to a varchar(50), even when its quite obvious that its a columm ...
1
vote
0answers
38 views

SQL Windows authentication from Web application?

Is it possible to use MSSQL Windows authentication to connect from one server to another using web application? Both servers are in the same VPN.
1
vote
1answer
326 views

deleting a row in dbvisualizer

I would like to delete this one in the db visualizer and not sure if I am writing the correct syntax: I also see that the idsapusertype 25 is also linked to idsapusertypedetails 75 and 76. Can I ...
1
vote
4answers
11k views

SQL Server Management Studio - First Time Setup

I'm on Windows 7 and using free version of SQL Server Management Studio. I try connecting to DB server for the first time. I run the program as administrator. I go to Connect > Database Engine and ...
3
votes
1answer
5k 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?
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
1answer
2k views

Starting a SQL server on fedora

I am a total databases noob, hence please be gentle. I am looking for tutorials how to create a SQL table, how to start a SQL server, and what software to use on fedora. Would anyone share links to ...
2
votes
2answers
554 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 ...
12
votes
2answers
61k 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 ...
0
votes
2answers
5k views

How do I write a query in Microsoft SQL Server Management Studio and then use that Query in Excel

I have an Excel file that I want to open up, hit refesh, and it pulls in the data from the SQL server and then I manipulate the data and create some dashboards. I actually have this but I'm pulling ...
0
votes
1answer
11k views

SQL Server Express 2008 R2 Installation error at Windows 7

I created an install script that will install SQL Server 2008 R2 on Windows XP SP3, Windows Vista and Windows 7. One of the command that I used in the installation is for silent installation of SQL ...
0
votes
2answers
38 views

How to install SQl for the first time in XP

I ve downloaded mysql-essential-5.1.49-win32 for their site and installed. After Installing, i tried some internet stuffs(mysqld --console) to verify the installation. I cant get the correct output. ...
0
votes
1answer
77 views

How do i pass a variable to a function thats already being escaped?

What i want to do is create multiple informix sql statements & later run them via a bash script. Here is what i have so far (this works) but is meant to be run from a cron job so it only does ...
1
vote
2answers
1k views

SQL authentication not authenticating in MS SQL Server 2008

When I try to connect to the SQL Server running on localhost using Windows Authentication in SQL Server Management Studio, I am able to connect but when I try to connect using SQL authentication, it ...
8
votes
2answers
8k 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 ...
0
votes
1answer
129 views

Looking for program to export data from MS SQL database

I need to export some tables in a MS SQL database. The ASP.NET Enterprise Manager provided by the host doesn't offer much functionality. Can someone recommend a good program for doing this? I only ...
0
votes
4answers
712 views

Tool to copy SQL Server Database

I am looking for a tool to copy a sql database tables, stored procedures, functions etc and also the data contained within the database from a server to my local pc. Both have sql server management ...
0
votes
1answer
413 views

Graphical Decision Engine Framework - Any ideas?

Is there an open-source decision framework I could use? What I am looking to create is some kind of graphical interface to allow people to visually build a query based on a set of parameters, ie. ...
0
votes
1answer
4k views

SQL Server 2008 Management Studio x64

Is there a 64bit version of SQL Server 2008 Management Studio? I downloaded the 32bit/64bit version of SQL 2008 Developer R2 and it still installed into the Program Files (x86)\ file location.
0
votes
1answer
1k views

How can I specify rules for foreign keys in Microsoft Access using SQL?

I have to create some tables in Microsoft Access using SQL sentences, and some of the tables have foreign keys. I would like to specify the constraints and rules for foreign keys using SQL: Whether ...
2
votes
3answers
225 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
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 ...
17
votes
5answers
13k 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 ...
2
votes
1answer
869 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 ...
1
vote
1answer
1k views

Running multiple SQL files at once

I feel like I've run commands like the following in the past, but I'm getting an error trying it right now. Maybe I'm just having a brainfart, and my syntax is off. mysql -u root -p db_name < ...
0
votes
1answer
1k views

Getting account lock status in MS SQL Server

I want to unlock an account in MS SQL Server. Before unlocking I have to check whether the account is locked or not - I only want to unlock if the account is locked. Are there any SQL queries or ...
2
votes
3answers
1k views

Why does MS SQL Server Management Studio almost freeze up my computer while it restores?

Why does MS SQL Server Management Studio almost freeze up my computer while it restores? It makes it so when I click on the clock it takes seconds for the calendar to open. I don't see why this ...
1
vote
2answers
899 views

How to swap first and last names in MS Access

I have an Access database where a column of fields contain names where the first name is first and the last name is last. Id like to be able to swap then around so they are Last name first, first name ...
0
votes
2answers
123 views

Mac OS app options for SQL editor with JDBC or ODBC support

Mac OS options for SQL editor with JDBC or ODBC support?
1
vote
3answers
2k views

Access - Merge two databases with identical structure

I would like to write a query that merges two Access 2000 databases into one. Each has 35 tables with identical fields and mostly unique data. There are some rows which will have the same "primary ...
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
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 ...
3
votes
10answers
395 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 ...
18
votes
11answers
4k 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 ...