Search Results

Search found 42428 results on 1698 pages for 'database query'.

Page 201/1698 | < Previous Page | 197 198 199 200 201 202 203 204 205 206 207 208  | Next Page >

• Fluent Nhibernate napping to existing database with primary key in joining table of a many to many r

  - by Todd

  I have an existing database with a many to many relationship however the joining table has a primary key ID and 2 foreign keys to do the join. Is it possible to configure the mapping files to handle this? at the moment i am stuck. Thanks

  Read the article

• Where to find an SQL database for medical information?

  - by iamrohitbanga

  Where can I find sample data of medical information? Data on medicines, diseases, etc. and preferably in a format easy to import into an SQL database.

  Read the article

• How to prevent updating duplicate rows in SQLite Database?

  - by CSharperWithJava

  I'm inserting new rows into a SQLite table, but I don't want to insert duplicate rows. I also don't want to specify every column in the database if possible. I don't even know if this is possible. I should be able to take my values and create a new row with them, but if they duplicate another row they should either overwrite the existing row or do nothing.

  Read the article

• Make a final call to the Database when user leaves website (ASPX)?

  - by Jisaak

  I have a system set up to lock certain content in a database table so only one user can edit that content at a time. Easy enough and that part is working fine. But now I'm at a road block of how to send a request to "unlock" the content. I have the stored procedure to unlock the content, but how/where would I call it when the user just closes their browser?

  Read the article

• How can I frequently/automatically compare the structure of the same Database?

  - by Pitming

  Does anyone know a tool that automatically compares the structure of a database and gives a report of what was changed? If it can be integrated into a CruiseControl, even better. By structure I also mean functions and stored procedures. Which is probably not clear at first sight ;-) The idea was to integrate that into a cruise control server

  Read the article

• VS2010 Database Compare. How do you create a *.DBSchema extensioned file?

  - by George

  I'd like to take a snapshot of my database, make some changes and then use the db compare functionality to identify the changes, and who knows, maybe even generate scripts to make the change. I'd like to avoid having to backup the current db and restore it as a separate db just to have a "before" snapshot. I'm guessing I shouldn't have to. Obsviously, I'm clueless about db projects and am looking to be pointed in the right direction. ty!

  Read the article

• How to use C# to parse a glossary into database?

  - by Yaaqov

  This should be a simple one, but I'm a beginner with C#. Given a glossary list in the following format: aptitude ability, skill, gift, talent aqueous watery arguably maybe, perhaps, possibly, could be How can I parse this, and insert into a database table in the format: TABLE: Term_Glossary ================================================ Term_Name | Term_Definition | ================================================ aptitude | ability, skill, gift, talent | ------------------------------------------------ aqueous | watery | ------------------------------------------------ arguably | maybe, perhaps, possibly, could be| ================================================ Any help would be appreciated - thanks.

  Read the article

• Do you know a database written in Perl with DBI interface?

  - by Aftershock

  Hi, Do you know a database written in Perl with DBI interface? Or what can be used if there is no MySql or Postgresql installed? Thank you.

  Read the article

• How to use Triggers for Logging History of database change in MySQL?

  - by Parth

  How to use Triggers for Logging History of database change in MySQL? If yes, then is it possible to create a sepearte db for trigger tables for tracking history of other Db tables??

  Read the article

• Is there a "best" or more popular database for standalone Java app?

  - by Tom Brito

  Is there a "best" or more popular database for standalone Java app? I'm currently writing by hand, but I would like to know what is commonly done, if there is something that is commonly done.

  Read the article

• How to convert rows of a database query to a XML file?

  - by EASI

  I am developing a Delphi application that needs to pick up the rows from a period of work and convert them to a single XML file in order to upload to a 3rd party web-service. Is there any component or library available to do that? If not, what is the best approach of code to build that DB2XML conversor? I noticed that most XML questions are about how to convert it to another type of data. Note: the database will be MySQL or Firebird.

  Read the article

• With database table design, Is there an advantage of using special naming convention for a Many-to-m

  - by Jian Lin

  Whenever there is a many-to-many relationship, I think there will be immediately a many-to-many table needed (also called a junction table). Is there any advantage of using special naming convention for these tables, as opposed to the other 1 to many tables? Or are there popular special naming conventions used by companies designing database tables?

  Read the article

• How do I remove the first 8 characters from a Microsoft Access database field?

  - by Gavin O'Brien

  Hi, I've got an Access '07 database that imports data from text files. The problem is one of the fields that is taken in comes with a date value before a place value that I don't need. For example, the field comes in like so: 01012010DUBLIN whereas I need it to just display DUBLIN. I'm stumped on this and any help would be greatly appreciated Thanks.

  Read the article

• How can I create a model in Powerdesigner which can generate create script for different database?

  - by MemoryLeak

  I just want to create the model once, and then use it in any kind of database, without the need to modify the model. What I should do with the data type ? I found there is numeric and other kind of data types. What does that correspond to in mysql or access ?

  Read the article

• IOC are at the class level, but what about database conflicts?

  - by mrblah

  With IOC I understand you can substitue implementations out by merely editing a configuration file etc. BUT, what happens when the classes are married to particular database tables and sprocs, you can't just swap out an implementation since the classes/entities are tied to particular tables and stored procedures. Am I right here?

  Read the article

• How to monitor the change of the database so as to flush the treeview?

  - by jack

  target: whenever the table in the database changes, the treeview will reload the new contents of the table. Is there any good methods to solve this problem? thank u

  Read the article

• How do you store a trie in a relational database?

  - by blank

  I have a prefix trie. What is the recommended schema for representing this structure in a relational database? I need substring matching to remain efficient.

  Read the article

• What's the quickest way to dump & load a MySQL InnoDB database using mysqldump?

  - by Josh Schwartzman

  I would like to create a copy of a database with approximately 40 InnoDB tables and around 1.5GB of data with mysqldump and MySQL 5.1. What are the best parameters (ie: --single-transaction) that will result in the quickest dump and load of the data? As well, when loading the data into the second DB, is it quicker to: 1) pipe the results directly to the second MySQL server instance and use the --compress option or 2) load it from a text file (ie: mysql < my_sql_dump.sql)

  Read the article

• Is there any SQL Server database designer software like MySQL workbench?

  - by newbie

  I need to design database for SQL Server, is there any MySQL workbench like software for that? I have access to MSDN, so it can also be commercial product that can be found form MSDN.

  Read the article

• How do you find out which database links are used in queries for the Oracle RDBMS?

  - by JavaRocky

  I would like to find out if any and which database links are being used, for a schema, and in which tables. Is it possible via the data dictionary somehow? Is this possible with the Oracle RDBMS?

  Read the article

• Django database - how to add this column in raw SQL.

  - by alex

  Suppose I have my models set up already. class books(models.Model): title = models.CharField... ISBN = models.Integer... What if I want to add this column to my table? user = models.ForeignKey(User, unique=True) How would I write the raw SQL in my database so that this column works?

  Read the article

• Why use your application-level cache if database already provides caching?

  - by vsb

  Modern database provide caching support. Most of the ORM frameworks cache retrieved data too. Why this duplication is necessary?

  Read the article

• Java: Storing information from database. What collections are appropriate?

  - by garvy

  I write an application in Java. I get form a database a table (clients) which contains fields like: name | surname | adress What is the best solution to store this data in my app? Should I create an object for each client and store these objects in a list or set? The table contains about 100 records and it's already sorted. Thanks in advance.

  Read the article

• What is the easiest way to add a bunch of content to a SQL database?

  - by Trip

  Nothing technical here. Suppose I have a lot of different categorized data, and I would like to create a database out of it. Would someone literally hand plug in all that info with SQL code itself? Or do some people make a mock website just to input data? What are some of your strategies?

  Read the article

• How to create view from more than one table in MS Sql Server database?

  - by GK

  I have to create a view from more than one table in MS Sql Server database, but i am not able to get the correct syntax for the same. need help. thanks.

  Read the article

< Previous Page | 197 198 199 200 201 202 203 204 205 206 207 208  | Next Page >