Where can I get lecture of database managment system？
Where can I get lecture of database managment system？ I need both the introduction and implementation video lectures. Thanks. ...
database
How to import data to an in-memory database?
Are there any ways to import data in databases such as MS SQL, MySQL into in-memory databases like HSQLDB, H2 etc ? ...
Delphi 2009, MyDAC and relational database
Hello everyone! I have quite a problem concerning the use of relational database concepts in Delphi 2009 with MyDAC. I have a database structure that looks somehow like the following: Item id name Storage id name StorageItem id item_id storage_id place Now when I have an active dataset from "Item" how can I disp...
Sql Server: uniqueidentifier plus integer compound PK ... what type of index to use?
I have a junction table in my SQL Server 2005 database that consist of two columns: object_id (uniqueidentifier) property_id (integer) These values together make a compound primary key. What's the best way to create this PK index for SELECT performance? If the columns were two integers, I would just use a compound clustered index (...
Linker error while building a edb database
error LNK2019: unresolved external symbol _CeCreateDatabaseWithProps referenced in function "public: __thiscall EDB::EDB(void)" (??0EDB@@QAE@XZ) I got the following linker error in the .obj file of my project. I have coredll.lib and Windbase_edb.h Windbase.h winbase.h included in the project covering the dependancies as instructed i...
How to change all highlighted rows in DataGridView - VB.NEt
Hi all, Begginer's question. I'm trying to write small piece of code in Visual Studio (VB.net) that will change value of a particular field of the database for all highlightetd rows. So, I'm running my form, which displays some data from the datatabse. I then highlight some rows (holding Ctrl and clicking). Next I click a button that wi...
What would it take to write my own database system?
What would it take to write my own database system? I would want to make it a server type system. Have any successful database systems been written by one person? ...
how to update sqlite3 database in iphone
i want to update my sqlite database but i cannot find the way to do it,following is the code: const char *sqlStatement = "UPDATE frame SET fileExist = '1' WHERE name='$variable'"; if(sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) { NSLog(@"successupdate"); } from the above code i want my tabl...
What is the difference between Join and Union?
What is the difference between Join and Union? Can I get a sample? ...
How to import SQL dump to a table without overwriting duplicate fields
Hi, how do I import a MySQL dump file to a database without overwriting records with the same value? ...
ORACLE 7.3 user management
Hi, At work I have an app sitting on Oracle 7.3 (old stuff, yes). Recently I tried to create an account that would be able to SELECT on all tables, but nothing else i.e. no updates or deletes. But whenever I create a new account it already has access to all application tables. I even stripped it down to CREATE SESSION only. This didn't ...
Can subsonic build for me the CRUD and paging stored procedures?
Can subsonic help me building these main stored procedures? Can i edit its template to make it generate these SPs? Where to begin learning that? ...
Android: Get highest value in column
I have an URL pointing to content and I need to get highest value contained in one of the columns. Is there any aggregate function that will accomplish that or do I have to do this manually? ...
Any guidelines to follow to design database Metadata Repository ?
I would like to design a metadata repository for the internal database. The repository should be able to provide simeple answers to questions like - which tables have what type of data and what are the table relationships ? Any industry standard guidelines that I should follow ? ...
Stored procedure parses correctly but will not execute. Invalid object name. Msg 208
I've scripted up a stored procedure as follows. It will parse without errors, but when I try to execute it, it will fail. The error message reads: Msg 208, Level 16, State 6, Procedure aspnet_updateUser, Line 23 Invalid object name 'dbo.aspnet_updateUser'. Here is the stored procedure. USE [PMRS2] GO /****** Object: StoredProced...
selecting and displaying ranked items and a user's votes, a la reddit, digg, et al
when selecting ranked objects from a database (eg, articles users have voted on), what is the best way to show: the current page of items the user's rating, per item (if they've voted) rough schema: articles: id, title, content, ... user: id, username, ... votes: id, user_id, article_id, vote_value is it better/ideal to: select ...
Database - Data Versioning (followup)
My original question can be found here, for which I've gotten some great answers, idas and tips. As part of a feasibility and performance study, I've started to convert my schemas in order to version my data using those ideas. In doing so, I've come up with some kind of other problem. In my original question, my example was simple, wit...
what to use for php db abstraction layer?
Hi, I have been using Creole for a year, but Creole project is dead now.. what are other good abstractions for php ? ...
How to merge two databases in SQL Server?
Both databases have the same schema, but they may experience conflict with primary key in some tables. So I want them to just ignore the duplicate rows, and continue merging further. ...
Page results in [database of your choice]
I'd like to collect the "state of the art" ways to paginate results for any database in this wiki. Input: I have a huge table PAGE_ME: create table PAGE_ME ( ID bigint not null, NAME varchar(32) not null, CREATED TIMESTAMP not null ) id is not necessarily in the same order as created. I want to display the results between...