In SQL Server 2000 or above is there anyway to handle an auto generated primary key (identity) column when using a statement like the following? Insert Into TableName Values(?, ?, ?) My goal is to NOT use the column names at all. ...
Is it possible to do mysqldump by single SQL query? I mean tu dump the whole database, like phpmyadmin does when you do export to SQL ...
I've looked through similar questions but I'm still a little perplexed about something that seems to be a simple case in Rails. Let's say I have a model class called Employee. One attribute of an employee is their security_clearance, which is a string that can be None, Some, or Full. No other values are valid. In other applications I'd ...
I am developing a transactional application in .NET and would like to get some input on how to properly encapsulate database access so that: I don't have connection strings all over the place Multiple calls to the same stored procedure from different functions or WORSE, multiple stored procedures that are different by a single column ...
When using mysql_fetch_assoc in PHP, how can I make it return the correct data types? Right now it appears to convert everything to strings, I'd prefer if it left the Ints as Ints, and somehow designated the Date/Time as either Object or somehow different than strings. The reason for this is that I am using PHP as a backend to a Flex ap...
Are there any naming conventions for DB triggers? For example "before delete on users" would be "bdUsers" or something like that. ...
I am starting off with a SQLServer database. So it would seem that I should use System.Data.SqlClient namespace. But, there is a chance that we might shut down our SqlServer database and go to MySql or Oracle. For this reason, I am coming up with a set of standards on how our .Net apps will communicate with the database, so as to make it...
Anyone know where I can find a simple comments script in php/mysql, i just want a system that has the basic font enhancements, url links, image and reply functions. Thanks. ...
Is there a .Net project/dll, that supports escaping of user supplied input to database queries for various database systems? I would like our entire team to standardize and use one module to perform escaping of user supplied input that will then be used in parameterized SQL queries. Ideally, I would like to specify the database system ...
Daily 20-25 million rows that will be removed at midnight for next days data. Can mySQL handle 25 million indexed rows? What would be another good solution? ...
Dear experts, I am working on design a application that required to send a notification email for paid services. For example, user signed up a hosting solution for 3,6, and 12 months. The application requires to send an email to user whenever the contract expires in a sequence until user renew service for every 2 weeks, 3days and 1 days ...
Update: Management has seen the light, we're going with php and mysql. Thanks for your help. Subject: Access 2007 If it were my choice, i'd write up a web-based app w/ perl and mysql... But the higher-ups aren't good with computers, and know more about microsoft excel than they do the command line. They are great at organizing and...
I've been reading a lot lately about signature trees, or S-Trees. For example, this paper. The literature speaks very highly of them, and evidence is provided for considerable performance gains over, for example, inverted files or B-Trees, for some applications. Now, why is it that I don't see S-Trees used very much? Do you know of any ...
So I’ve been working on this project at work where I’m coding a php website that interacts with a database I have no control over. The database was “designed” by a co-worker that has been with the company many more years then I have; so in the end decisions are left for them to decide. When I was first pulled aboard on this project I w...
This question is similar to my last question. Except this time I'm using letters rather than 6 digit integers. I want to find the out of sequence "letters". Let's say I have the following data: id | Date | Letter ----------------------------- 01 | 5/1/2009 | X 02 | 5/1/2009 | Y 03 | 5/1/2009 | Z 04 | 5/1/2009 | A 05 | 5/1/2009 | B 06 ...
Say for example I've got an SQL schema that is ready to go. How would I import it into my Rails app so that I use my prepared database instead of all those funny migrations. EDIT: You have all misunderstood my question so far. I'm asking if I had a working database application in say PostgresQL. How would I use this as the basis of my R...
I have a web application running over a MySQL database (in development). I'm considering to migrate my application to Google App Engine, and would like to better understand how my simple relational database model can be transformed to the non-relational approach. I'm a long time relational database person, and I have no experience with ...
For a while I've been working on inserting the data from a bloated Excel workbook into a SQL database. My team has suggested keeping a backup of the .xls, and they are wondering if it might be a good idea to put the Excel workbook actually inside the database so that all the relevant data from our project was together. I know some datab...
We are trying to do a manual failover of our oracle database servers through enterprise manager and it keeps throwing an ORA-16198 timeout incurred on internal channel during remote archival. How do I go about troubleshooting this problem? ...
Let's say I have the following table in SQL Server 2005: id | Date | Letter ----------------------------- 01 | 5/1/2009 | W 02 | 5/1/2009 | X 03 | 5/1/2009 | Y 04 | 5/1/2009 | Z 05 | 5/1/2009 | A 06 | 5/1/2009 | B 07 | 5/1/2009 | D 08 | 5/1/2009 | E 09 | 5/2/2009 | W 10 | 5/2/2009 | X 11 | 5/2/2009 | Y 12 | 5/2/2009 | Z 13 | 5/2/2009 | ...