Search Results

Search found 8603 results on 345 pages for 'altering tables'.

Page 160/345 | < Previous Page | 156 157 158 159 160 161 162 163 164 165 166 167  | Next Page >

• DB2 SQL count in join or where clause

  - by Pat

  This is probably an amateur question but I'm an amateur ! ;o) I have several tables: Account table, Officer table, Location table, Web table... The Officer table doesn't give me the number of officers per account. I need to retrieve only the accounts that have more than 20 officers. Should I use the COUNT ? If so, how ? Your help is greatly appreciated. Thanks. Pat

  Read the article

• Do any parsers exist for the Oracle DML table_reference?

  - by JavaRocky

  I wish to find out what tables references are used in a DML. I prefer to use an oracle package as it can be self contained in the database. But other suggestions welcome. Open source very welcome. Here is the link to the syntax diagram of the table_reference definition: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10002.htm#i2126863 Do any parsers exist?

  Read the article

• Table Partitioning

  - by Ankur Gahlot

  How advantageous is it to use partitioning of tables as compared to normal approach ? Is there a sort of sample case or detailed comparative analysis that could statistically ( i know this is too strong a word, but it would really help if it is illustrated by some numbers ) emphasize on the utility of the process. Thanks, Ankur

  Read the article

• Using a Linq-To-SQL class automagically generates the connection string for me; is there a way to ma

  - by Sergio Tapia

  I'm just beginning to use Linq-to-SQL and it's just wonderful to use. The problem is, this software is going to be run on a lot of machines and each machine will have a unique connection string. Is there a way for me to manually set the connection the Linq-to-SQL (.dbml) uses? The way I'm doing things now is creating the .dbml file, and in the graphic designer I'm dragging tables from the Server Explorer to the white board of the .dbml.

  Read the article

• Looking for Java libraries to create a report editor

  - by Julian

  I have to develop a specialised report editor in Java. The user will get a number of fields that can be layed out on a page plus some graphical elements. The resulting report design needs to be serialized into already defined database tables. Is there any software library that will help to achieve this without reinventing the wheel? I have come across Eclipse GEF and Zest, but I am not sure if this really meets my problem.

  Read the article

• PHP Doctrine: Custom nested set?

  - by ropstah

  Is it possible to have nested set capabilities in this somewhat custom setup? Consider these 4 tables: Object: (oid, name) contains: [1, 'Licence'] and [2, 'Exemption'] Licence: (lid, name) Exemption: (eid, name) Cost: (oid, oid_ref, cost_oid, cost_oid_ref) For: P = Licence with lid [1] R = Exemption with eid [2] i can say "object P is a parent to object R" if the following Cost record exists: [oid: 2 oid_ref: 2 cost_oid: 1 cost_oid_ref: 1] I understand that this creates somesort of 'conditional foreign key' relation which I need to define in code. Is it possible to have the nested set loaded with these conditions?

  Read the article

• MYSQL query to return rows that are NOT in a set

  - by iglurat

  Hi, I have two tables: Contact (id,name) Link (id, contact_id, source_id) I have the following query which works that returns the contacts with the source_id of 8 in the Link table. SELECT name FROM `Contact` LEFT JOIN Link ON Link.contact_id = Contact.id WHERE Link.source_id=8; However I am a little stumped on how to return a list of all the contacts which are NOT associated with source_id of 8. A simple != will not work as contacts without any links are not returned. Thanks.

  Read the article

• Help with simple SQL Server query

  - by Bram

  I have to tables as follows; Employees: Name nvarchar(50), Job Title nvarchar(50) and Salary int. Employers: Name nvarchar(50), Job Title nvarchar(50) I would like to select every item from the 'Employers' table where 'Job Title' does NOT show up in the 'Employees' table. I know this is a simple query but it has me stumped. I'd be grateful for any help. Thanks.

  Read the article

• Hibernate mapping, on a unmapped class

  - by Jan

  Hi, I' ve got 2 tables... Challenge and ChallengeYear, ChallengeYear is only to create a list of years in challenge. I only want to make Challenge an entity, containing a list of List years. Is this possible? I've looked in to @SecondaryTable together with @JoinColumn and @OneToMany, but neither of those can do the trick, or i am overlooking something. Can someone help me? Greetings, Jan

  Read the article

• Convert a MSSQL database to MYSQL database

  - by soldieraman

  Alright so I want to convert an already exist MSSQL database (2005) to a MYSQL database. There is nothing extraordinary to be done The only things I need to achieve is Recreate the tables Transfer data Relationships would be nice but not necessary No views, no sprocs, no functions. Any easy way to do this. Also do you know of any DST (Database Synchronization Tool) which would let me do MSSQL to MYSQL MYSQL to MYSQL MSSQL to MSSQL (I know there is SQL Delta for this)

  Read the article

• A MySQL schema parser in Java?

  - by Richard

  Hi all, Does anyone know whether there is a java library for parsing a MySQL schema? In code I want to be able to determine the tables and fields specified in a schema. Or am I going to have to write my own? Thanks Richard.

  Read the article

• mysql full text search ampersand (&) Problem

  - by Jason

  How can I serach word with "&" using mysql full text search ? There are words string, like "Marks & Spencer", "at&t" in my tables , serach "at&t", but can't find it on the database using mysql full text search Any ways to serach word with "&"?

  Read the article

• Style guide for database metadata naming

  - by Nulldevice

  We want to establish some database metadata naming rules in our new project. For example: tables are named as nouns in a plural form (courses, books, lessons) if present, an adjective goes before a noun in a table name and is separated by an underscore (red_books, new_lessons) table index column is always named "id" foreign key names are derived from a table name with suffix _id (book_id, red_book_id) so on Does someone know any guide like this?

  Read the article

• SQL Server DB metadata

  - by Lijo

  Hi Team, I am using SQL Server 2005. I have a requirement to list out all the tables (and the column) whcih has the value 'xyzeee'. Is there a query to achieve this? Thanks Lijo

  Read the article

• How do I rename a table in SQL Server Compact Edition?

  - by romkyns

  I've designed my SQL CE tables using the built-in designer in VS2008. I chose the wrong names for a couple. I am now completely stuck trying to find a way to rename them. I am refusing to believe that such a feature could have been "forgotten". How do I rename an existing table using the VS2008 designer, or a free stand-alone app?

  Read the article

• CMS just for backend

  - by krumiro79

  I'm looking for a CMS just for backend that lets you manage database tables with custom fields. I found Wordpress Pods similar to what I'm looking for, but I don't want Wordpress to manage my frontend (and Wordpress Pods don't look professional to me...) Is there something like this out there? Thank you. Sergio

  Read the article

• table cell and row borders different on each edge in C#

  - by tbischel

  I'm trying to dynamically generate a report in a table where the borders are different on each side of a cell or row, but can't figure out how. The TableRow, TableCell, and Table objects each have a BorderStyle property, but it seems to apply to the entire border rather than just one side. Can this be done without nesting tables? For my case, I'd like a solid border around the first two rows of a table (because the first row has a cell spanning two rows), and a solid border around each subsequent row.

  Read the article

• Android browse SQLite database on phone

  - by Chris

  How can I browse the SQLite database that I am creating in my app on my Android myTouch phone? When I log in through adb shell, sqlite3 gives me a permission denied. Is there another way to check if my database and tables are actually being created, and if rows are being inserted? I am not able to use the emulator, since it doesn't play videos etc. very well that is the main feature of my app, so I can only test on phone. Thanks Chris

  Read the article

• Locking a table with a select in Entity Framework

  - by Manuel Felício

  I need to be able to do select * from myTable with (xlock,holdlock) from Entity Framework. Is this possible? I've opened a TransactionScope with the Serializable isolation level but my selects are not locking the tables. I'd like them to lock until I complete the transaction scope.

  Read the article

• Run SQL scripts on windows mobile installer

  - by Guillermo Vasconcelos

  Hi, We are working on a Windows Mobile 6.5 application. The application is already installed in some devices, and we need to distribute a new version with changes in the database schema (we added a few tables). Is there a way to make a "patch" windows mobile installer that will replace the application and update the embedded SQL database with some scripts? In a normal windows installer we would create a custom action in the installation process to apply the changes in the database, but I'm not sure how to do that for Windows Mobile Thanks.

  Read the article

• Hidden features in Oracle

  - by Peter Gfader

  I enjoyed the answers and questions about hidden features in sql server What can you tell us about Oracle? Hidden tables, inner workings of ..., secret stored procs, package that has good utils...

  Read the article

• how to write programs that they use advanced OpenType features?

  - by Sorush Rabiee

  How could I write a simple program using OpenType tables in order to dynamically render text? please answer in : assembly , C , C++ , C# , java or Python (and a little WPF:-) or introduce libraries of them. comments and answers about text rendering system of common Operating Systems, or designing text engines compatible with unicode 5.02 protocol are welcomed.

  Read the article

• Modelling class relations

  - by phenevo

  Hi, I have a few classes: Article ------- Content ID Magazine -------- Name Code And 3 tables in database: Articles Magazines ArticlesInMagazines (two fields: IDArticle and CodeMagazine) In my app, I've got a module to manage Articles, and a datagridview to relate their associated magazines DataGridView has twofields: MagazineCode IsPublished (indicates articles which have been published in this magazine). The same article can be in many magazines (1:n) How would you implement on model ? Article have to has a field : List ?? I am concerned because Magazine associates Articles

  Read the article

• Tools to work with App Engine data dumps

  - by Thilo

  Using the bulkloader.py utility you can download all data from your application's Datastore. It is not obvious how the data is stored, however. From the looks of it, you get a SQLite file with all data in binary format in a single table: sqlite> .tables bulkloader_database_signature result sqlite> .schema result CREATE TABLE result ( id BLOB primary key, value BLOB not null, sort_key BLOB); Are there any tools to work with this data?

  Read the article

• Is there a way to enable / disable constraints in db2 v7?

  - by mauro2

  Hello people, I have to copy tables from an Oracle database to a db2 v7 one, and in order to do this (avoiding millions of drops and creates) I'd like to know if db2 has a feature like Oracle to enable / disable constraints temporarily without dropping them. Thanks in advance, Mauro.

  Read the article

< Previous Page | 156 157 158 159 160 161 162 163 164 165 166 167  | Next Page >