Search Results

Search found 40059 results on 1603 pages for 'database management'.

Page 170/1603 | < Previous Page | 166 167 168 169 170 171 172 173 174 175 176 177  | Next Page >

• 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

• Is order of parameters for database Command object really important?

  - by nawfal

  I was debugging a database operation code and I found that proper UPDATE was never happening though the code never failed as such. This is the code: condb.Open(); OleDbCommand dbcom = new OleDbCommand("UPDATE Word SET word=?,sentence=?,mp3=? WHERE id=? AND exercise_id=?", condb); dbcom.Parameters.AddWithValue("id", wd.ID); dbcom.Parameters.AddWithValue("exercise_id", wd.ExID); dbcom.Parameters.AddWithValue("word", wd.Name); dbcom.Parameters.AddWithValue("sentence", wd.Sentence); dbcom.Parameters.AddWithValue("mp3", wd.Mp3); But after some tweaking this worked: condb.Open(); OleDbCommand dbcom = new OleDbCommand("UPDATE Word SET word=?,sentence=?,mp3=? WHERE id=? AND exercise_id=?", condb); dbcom.Parameters.AddWithValue("word", wd.Name); dbcom.Parameters.AddWithValue("sentence", wd.Sentence); dbcom.Parameters.AddWithValue("mp3", wd.Mp3); dbcom.Parameters.AddWithValue("id", wd.ID); dbcom.Parameters.AddWithValue("exercise_id", wd.ExID); Why is it so important that the parameters in WHERE clause has to be given the last in case of OleDb connection? Having worked with MySQL previously, I could (and usually do) write parameters of WHERE clause first because that's more logical to me. Is parameter order important when querying database in general? Some performance concern or something? Is there a specific order to be maintained in case of other databases like DB2, Sqlite etc? Update: I got rid of ? and included proper names with and without @. The order is really important. In both cases only when WHERE clause parameters was mentioned last, actual update happened. To make matter worse, in complex queries, its hard to know ourselves which order is Access expecting, and in all situations where order is changed, the query doesnt do its intended duty with no warning/error!!

  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 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

• 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 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

• 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 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

• 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 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 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• ASP.NET MVC 2 Localization/Globalization stored in the database?

  - by richburns

  Hello I've been searching for a while for a good example of localizing an C# ASP.NET MVC 2 application but storing the data in the database instead of .RESX files. Unfortunately I've had no luck finding a good example and was hoping someone else may know and could point me in the right direction? Many thanks for any help/advice/articles

  Read the article

• Wikipedia style article, how should I design my database?

  - by newbie

  I need to make article that cannot be edited, but it can be saved as a new version and only the newest version is shown to users. How should I implement this kind of database design?

  Read the article

< Previous Page | 166 167 168 169 170 171 172 173 174 175 176 177  | Next Page >