Do you have any idea how to present all rows from let's say table with the possibility to click on particular row and open that way another window to edit? I've got no idea how to create this. I would like to avoid access like creation by built-in wizards in Microsoft Visual Studio 2008. Perhaps you know where I can find more informat...
Although I'm guilty of this crime, it seems to me there can't be any good reason for a table to not have an identity field primary key. Pros: - whether you want to or not, you can now uniquely identify every row in your table which previously you could not do - you can't do sql replication without a primary key on your table Cons: - ...
Hello all, I am looking for a simple CRUD (or DAL) Generator for C#. I don't want anything heavyweight since I only have a couple of tables in a SQL Server 2008 database. Any suggestions? I know .netTiers, but it is way too much for what I need. Thanks! UPDATE: I tried LINQ to SQL and it doesn't work well for my needs. ...
Hey does anybody know technologies that vimeo uses? I know they use mysql for the db, not sure if they use memcache. The site seems pretty smooth compared to youtube. Thanks ...
I have a .mdf which I need to import into MS Access. I have read that .mdf is a Sql Server format so Access wont recognize it. But is there some way I can get the database created in MS Access. I am using Access 2003 and Sql Server 2005 ...
It's been a while since I've last tinkered with databases, and as usually my mind has slipped on what I need to do. Here's me problem: I have a list of entries (strings). Each entry has its own name and unique ID. Entries can share names, but not IDs. Entries can also have properties (strings). Entries can have more than one of the sa...
Hi All, I'm need to know can i connect db through javascript? Actually, the last action where i end is done through javacsript. Now, i need to make some entries(extracted through javascript) in the database where last action stops. How can this be done? Khushi ...
I've given a client the following query to delete duplicate phone no. records in an MSSQL database, but now they need to also do it on MySQL, and they report that MySQL complains about the format of the query. I've included the setup of a test table with duplicates for my code sample, but the actual delete query is what counts. I'm aski...
I have SQL Server databases and do changes in them. Some database tables have records that are starting records required my app to run. I would like to do version control over database and these records (rows). Is it possible to do this and bundle it to SVN version control I have for my source code or are there other solutions to this? I...
I have an MS-SQL Server which keeps track on a number of clients. If the birthday is known it is stored as a datetime attribute called dayOfBirth. Now I would like to have another attribute age, which keeps track of the current age of the client. Since age can change any day I figured a script might be the best idea. First thing I did, ...
For this question, we want to avoid having to write a special query since the query would have to be different across multiple databases. Using only hibernate criteria, we want to be able to escape special characters. This situation is the reason for needing the ability to escape special characters: Assume that we have table 'foo' in ...
Is there a tool to find the difference between two databases. Both the schema and the actual data are pretty much the same, but not 100%. Do you know a tool that can help to succinctly describe the changes. ...
Does anyone know of a web-based database system similar in function to Microsoft Access? Basically I'm looking for a frontend to an RDBMS that can be used to: create, modfy and delete database objects enter data directly into tables view data in a grid format easily create forms for data entry add programming logic behind such forms (...
I've run into a situation in our database where I need to shift the timestamps of a number of records by a day, however I have a unique constraint that requires the an id field and a timestamp field to be unique. Here is the table description. Table "public.eedata" Column | Type | ...
Looking for a light weight ER Diagram tool. We are only looking to visualize our tables and their relationships, however none of them have primary key constraints defined. We use certain index/NOT NULL fields as primary keys (eg: claim_num). We simply need a tool that let's you draw the diagram itself, nothing more nor less. Also, for so...
I have a database that is locking mdb's and such that I'd like to backup. However the tool (I have the source) I am using opens the file before backing it up and finds that it is locked. Is there a way I can open it for read-only purposes? For reference the tool uses C# and .NET 2.0 (but can be updated to 3.5). ...
Hi, I created a database with couple of tables and some table names are enclosed with square bracket: [table_name] Does anyone qnow why this happen, and how to get rid of it? Thanks! ...
In database, such as Informix, DB2, Oracle etc, will the rowid be reused pls? ...
Hi I am trying to link an MS access mdb to my sql server 2005, the problem is that the MDB is located on a shared network drive which will require login/password. How do I pass the username and password into the "Linked server Access MDB" template? I assume I have to @datsrc parameter? ...
I look at table properties in Oracle and it has "LOGGING: YES". how can i query that log or if its in file were can I find it? ...