access: getting create table string
i have a table in access and i would like to get the SQL string from it that will generate the table like: CREATE TABLE example ( id INT, data VARCHAR(100) ); is there any way to do this? ...
sql
Performing Aggregate Functions on Multi-Million Row Tables
I'm having some serious performance issues with a multi-million row table that I feel I should be able to get results from fairly quick. Here's a run down of what I have, how I'm querying it, and how long it's taking: I'm running SQL Server 2008 Standard, so Partitioning isn't currently an option I'm attempting to aggregate all views f...
SQL with HAVING and temp table not working in Rails
I can't get the following SQL query to work quite right in Rails. It runs, but it fails to do the "HAVING row_number = 1" part, so I'm getting all the records, instead of just the first record from each group. A quick description of the query: it is finding hotel deals with various criteria, and in particular, priortizing them being pa...
access: implementing autonumber type in mysql
i have a database that is in access and i am converting it to mysql in access there is a type called autonumber. is there such a thing in mysql? if not, what would be an easy way to implement such a type (or not necessarily implement the type but to have the same functionality) ? ...
mysql: inserting data and autoincrement
i am converting from access to mysql i have a table in access where one of the columns is an autonumber when i transfer the data into the mysql database (where i also have a column that is auto_increment), should i be transfering the auto_increment data into the auto_increment column, or will it auto_increment itself? how do i ensure...
Linking Listbox child categories
Hello I have few monhts working with aspx, and now I'm developing a shopping cart website. For the employee to upload the products on the DB, every product needs to be linked to a category and sub category, and sub-sub category, and so on. Sometimes the sub-sub categories are up to 5. For example Electronics-TV-LCD-Samsung-40 inches. ...
best way of importing data into mysql
i have a table with 500,000 rows and about 10 columns that is in access how do i import it into mysql? ...
How to include the total number of returned rows in the resultset from SELECT T-SQL command?
I would like to ask if there is a way to include the total number of rows, as an additional column, in the returned result sets from a TSQL query using also the Row_Number (SQL 2005) command. For example, getting the results set from a query against Book table in a form similar to this: RowNum BookId BookTitle TotalRows ------...
Advantages of SQLServer vs. MySQL for C#/.NET4 Cloud Applications
I am considering building several C#/.NET4 applications all using a central, cloud based database. In addition, several LAMP (MySQL) web shops will be accessing the cloud DB. MySQL is the database that I'm most familiar with, and my default selection for the cloud DB would be MySQL on Amazon or Joyent. However, I was wondering what deve...
mysqlimport: error in syntax
i am trying to import a tab-delimited file into mysql. here is how i am doing it: mysqlimport c:\file.txt whats wrong with the syntax? ...
How Copy rows from one table to another table?
I have 2 table with same struture i need to select data from one table and have to store in to 2nd table. ...
MySQL Stored Procedure: Boolean Logic in IF THEN
I'm looking for the proper syntax (if this is possible in MySQL stored procedures) for using logical operators in an IF THEN statement. Here's something along the lines of what I would like to do, but I'm not certain if I should type "OR" or "||" in the IF ... THEN clause: DELIMITER $$ CREATE PROCEDURE `MyStoredProc` (_id INT) BEGIN ...
SQL Server 2008: Getting duration between user sessions
I have this table UserID SessionID SessionStart SessionEnd ----------------------------------------------- 1 abc1 2010-1-1 2010-1-2 5 def3 2010-1-5 2010-1-9 1 llk0 2010-1-10 2010-1-11 5 spo8 2010-1-13 2010-1-15 1 pie7 2010-1-16 2010-1-...
excel vba: writing to mysql database
i would like to write a macro that will write to a mysql database. can someone please get me started on this? ...
Collation configuration in SQL Server 2005 Express setup
I had to re-install my SQL Server 2005 Express instance due to a conflict with collations. Now, once in the setup, I can't see the SQL_Latin1_General_CP1_CI_AI collation, I see "Latin1_General" instead, and I've been told is not the same. Could you please tell me where I can find this? ...
connecting to mysql from excel: ODBC driver does not support the requested properties.
i am trying to add data to mysql from excel. i am getting the above error on this line: rs.Open strSQL, oConn, adOpenDynamic, adLockOptimistic here is my code: Dim oConn As ADODB.Connection Private Sub ConnectDB() Set oConn = New ADODB.Connection oConn.Open "DRIVER={MySQL ODBC 5.1 Driver};" & _ "SERVER=localhost;" & _ ...
What is a good way to assign order #s to ordered rows in a table in Sybase
I have a table T (structure below) which initially contains all-NULL values in an integer order column: col1 varchar(30), col2 varchar(30), order int NULL I also have a way to order the "colN" columns, e.g. SELECT * FROM T ORDER BY some_expression_involving_col1_and_col2 What's the best way to assign - IN SQL - numeric order val...
SQL subquery question
I have the following SQL SELECT Seq.UserSessionSequenceID, Usr.SessionGuid, Usr.UserSessionID, Usr.SiteID, Seq.Timestamp, Seq.UrlTitle, Seq.Url FROM tblUserSession Usr INNER JOIN tblUserSessionSequence Seq ON Usr.UserSessionID = Seq.UserSessionID WHERE (Usr.Timestamp > DATEADD(mi, -45,...
Why isn't my iif statement evaluating true when the condition is correct?
This is my statement: iif(sum(Fields!myfield1.Value) = 0, 0, sum(Fields!myField2.Value)/sum(Fields!myField1.Value)) Any suggestions? ...
what does select @@identity do?
i am connecting to a mysql database through excel using odbc what does this line do? Set rs = oConn.Execute("SELECT @@identity", , adCmdText) i am having trouble updating the database: With rs .AddNew ' create a new record ' add values to each field in the record .Fields("datapath") = dpath .Fields...