I want to connect to database SQL2005 from ActionScript3, where i need to execute query statements from actionscript! can any one tell me please the code to do that ???? i searched about this issue and the result did'nt help me as the code is not workinf so i got confused. ...
I'd be curious to find out how the major databases compare in terms of popularity. How much of the market does Oracle have? How much does MS SQL have? MySQL, PostGre, ...? How does this breakdown in the smaller markets (e.g. small web apps, large web apps, huge corporate services,...)? I'm looking for statistics here. Not impression...
I'm looking for some feedback on the best approach to a problem I've been tasked with. There are two systems with their own databases which store very similar business entities. For each entity in question there needs to be a synchronization mechanism in place to make sure that changes in one database are delivered to the other when a ...
Complete newbie researching Rails. Can Rails be used with a read-only schema that doesn't conform to the Rails' default naming and design conventions? For example, my database's schema has base tables that use string columns for unique primary keys. For example, a base table called Jobs, might have a unique primary key defined as Jo...
There is about 2000 lines of this, so manually would probably take more work than to figure out a way to do ths programatically. It only needs to work once so I'm not concerned with performance or anything. <tr><td>Canada (CA)</td><td>Alberta (AB)</td></tr> <tr><td>Canada (CA)</td><td>British Columbia (BC)</td></tr> <tr><td>Canada (CA)<...
I have a huge table of > 10 million rows. I need to efficiently grab a random sampling of 5000 from it. I have some constriants that reduces the total rows I am looking for to like 9 millon. I tried using order by NEWID(), but that query will take too long as it has to do a table scan of all rows. Is there a faster way to do this? ...
Hello, during a lecture my professor gave examples of several actions involving databases and the java.sql package. These examples were supposed to be uploaded online in a pdf file, but for some reason the names of all functions and class names aren't displaying with my pdf reader. I would like to know the equilavents of the following P...
I need to copy the indexes from one table to another. There are a LOT of indexes and I don't want to recreate them from scratch. Seems error prone anyways. I have copied the structure using SELECT * INTO [BackupTable] FROM [OriginalTable] But that doesn't copy indexes, constraints, triggers etc Does anyone know how to do this? ...
The idea that web services are small bits of functionality or data that are bundled together and encapsulated as small, stand-alone entities is pretty clear, and makes good sense. But how do services relate to databases that they use or provide an interface for? For example, when moving from a monolithic, 2-tier architecture with a mass...
I'm trying to script an MS SQL Server 2005 database to a single file. So far I've tried using SQL Management Studio and the MS Database Publishing Wizard. Both tools will script the database objects without a problem although neither tool is scripting objects in the right order of creation. For instance the script might script a view ...
I create a view with many joins. I want to group the resultset by some of the fields I selected. Does setting indices on these fields increases the performance of the query? I'm using MS SQL Server, but it should be nearly the same for all dbs, shouldn't it? SELECT table1.field1, table1.field2, table2.field1 FROM table1 INNER JOIN tabl...
Given a table of models 'A', that can have multiple child models 'B', of which 'B' will have one or more child models 'C'.. this sounds simple, however I need to enforce that for each 'A', any 'B' must have a unique collection of 'C'.. for example, C cannot be a child of two 'B's that are part of the same parent 'A'.. but a 'C' can be a ...
How to use Query cache with ADOdb in PHP? Is it default in ADOdb or Is there any configuration needed ? ...
I know this is not a programming question per se, but I wanted to get as much input from the SO community on a new project I hope to get started. The project is from being started from scratch and thus every decision for programming languages, databases, frameworks, platforms and what not are up in the air. I'm hoping to get your opini...
I have read-access to a MySQL database and am trying to connect to it via the MySql ODBC 5.1 driver. I'm getting an authorization failure (401) from the server. The administrator set up my access as follows: mysql> grant select, create temporary tables on theDatabase.* to 'adrian' identified by 'password'; I am successful in connecting...
I'm trying to make an import of a database but I get this error: Imp-00009 Abnormal end of export file Imp-00020 Long column too large for column buffer size(7) The import creates four tables and creates the rows for three of them, I guest that when the import tries to create the rows for the last table is when I get the error. I try ...
I have an application server which connects to a database server. I would like to be able to supply users with installers and, with a moderate degree of comfort, trust that the database schema is secure. I understand that there are some risks that I will just have to accept with not controlling the computer on which it installed - a de...
I need to do some structural changes to a database (alter tables, add new columns, change some rows etc) but I need to make sure that if something goes wrong i can rollback to initial state: All needed changes are inside a SQL script file. I don't have administrative access to database. I really need to ensure the backup is done on ser...
Somewhat related to my previous question, this is regarding creation patterns to enforce table patterns where 'A' has many 'B' children where 'C' is the table of child 'B's for 'A', but has at least ONE. Currently I have: A (A_ID primary key, B_ID reference key) B (B_ID primary key, etc) C (A_ID reference, B_ID reference) The point i...
Trying to wrap my head around test driven development. Unit testing is already in place and works fine from business layer up to and including web UI. Now I’m trying to solve question how to test data layer and underlined database. In the past, data layer had more code than in business layer and UI, and keeping the layer untested really ...