Search Results

Search found 28443 results on 1138 pages for 'partition table'.

Page 248/1138 | < Previous Page | 244 245 246 247 248 249 250 251 252 253 254 255  | Next Page >

• Can I select a set of Data and directly insert that into a table in SQL?

  - by VJ

  Hi I guess we cannot do this but was just curious if I could do something like - Select * from Employee where EmployeeId=1 and then use the data in the above statement and directly insert into a table with just changing the employeeid...or just this way- insert into Employee ( Select * from Employee where EmployeeId=1) its probably stupid from my side...but I just felt the need to do this a lot of times...so just was curious if there was any way to achieve it..

  Read the article

• Subsonic: How to exclude a table column so that its not included in the generated SQL query

  - by Fleents

  I need to insert a record to a table. Subsonic builds the query something like this (as far as i know): INSERT INTO Table1 (Title, Description, RowVersion) VALUES (@Title, @Description, @RowVersion) But i want to remove the RowVersion column from the SQL query bacause its autogenerated by the sql server. How can i do that?

  Read the article

• How to listen to keyboard events in GWT table?

  - by Olaf Mertens

  In my GWT program I have a table that has a selected row. I'd like to move the row selection with the up- and down-keys on the keyboard. So I have to catch the key events somehow. The GWT docs handle key events in input fields only. But I don't have an input field! Is this possible at all? Maybe it is a DOM/Javascript restriction that GWT cannot work around...

  Read the article

• What do these C# auto-generated table adapter commands do? e.g. UPDATE/INSERT followed by a SELECT

  - by RickL

  I'm working with a legacy application which I'm trying to change so that it can work with SQL CE, whilst it was originally written against SQL Server. The problem I am getting now is that when I try to do dataAdapter.Update, SQL CE complains that it is not expecting the SELECT keyword in the command text. I believe this is because SQL CE does not support batch SELECT statements. The auto-generated table adapter command looks like this... this._adapter.InsertCommand.CommandText = @"INSERT INTO [Table] ([Field1], [Field2]) VALUES (@Value1, @Value2); SELECT Field1, Field2 FROM Table WHERE (Field1 = @Value1)"; What is it doing? It looks like it is inserting new records from the datatable into the database, and then reading that record back from the database into the datatable? What's the point of that? Can I just go through the code and remove all these SELECT statements? Or is there an easier way to solve my problem of wanting to use these data adapters with SQL CE? I cannot regenerate these table adapters, as the people who knew how to have long since left.

  Read the article

• How do you load data into a Table View when there's both a Tab Bar and a Nav Bar?

  - by editor

  I think I'm way overthinking the issue of having a Tab Bar project type and adding Nav Bar controls. I've followed some basic directions and have a demo app running fine with two tabs, each with a Table View and nav bars. But how do I load data into them? I know I need to hook up delegate and dataSource, but where?

  Read the article

• How to build a complex table by using CSS?

  - by Relax

  Recently i ran into a complex table implementation, for example: tr1: | td1 | td2 | td3 | tr2: | td1 | td2 | tr3: | td1 | td2 | ... As this example shows, i want td1 are fixed with different width, td3 is also width fixed but at the right, td2 are all width auto to expand when screen radio changed. I'm wondering if there is a way to do this by using CSS?

  Read the article

• Why does compacting a Access 2000 db changes the order of records in a table?

  - by razvan

  As the question says. The table has no primary key defined. Other tables in the database do not change after compacting, and have as well no primary key defined.

  Read the article

• How do i select the 1st and then every 4th row in a html-table with nth-child()-selector?

  - by Nils

  Ok, math isn't my strong side, I admit it. All I want to do is to select the first, 5th, 9th, 13th, 17th etc row in a html-table. Can anybody with better math-skills point me in the right directionor perhaps supply a "nth-child-for-dummies" guide? I tried nth-child(1n+4) (which selects the 4th row and everyone after), and i also tried nth-child(0n+4) which selects the fourth row and nothing after that. Thanks in advance.

  Read the article

• How can I INSERT rows into a new table and update the primary key of the transported items?

  - by ggg

  The new table has an auto-increment that I want to use for the data that I'm transferring. Here is the query I want to run. INSERT INTO `xyz_1mydata` SELECT * FROM `xyz_1production` WHERE `xyz_1production.Id` > '12000'; I don't want to replace the existing items in #_1mydata.

  Read the article

• How can I detect if an iPhone is rotating while being face up in a table?

  - by OscarMk

  Hello, Is there a way to detect if an iphone lying down in a table face up is rotating?. I do realize that this kind of movement is not reported by the accelerometer and neither is it reported to the - (BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation method. Is there a way to detect angle variations for the phone rotating this way?. Thank you.

  Read the article

• Inability to delete table cells after a certain point.

  - by Sahil Lavingia

  I have built an app which has the ability to delete cells from a table, but only if there are more than two cells. If there are two or less cells, it only lets me select them. Any ideas? Here's a video to visualize it: http://slavingia.com/etc/helpme.mov

  Read the article

• IN MSSQL 2008 is there a way to generate a report as to how much space on disk each table takes?

  - by Matt

  IN MSSQL 2008 is there a way to generate a report as to how much space on disk each table takes? I can do it one by one by checking the storage properties, but I was wondering if there was a way, maybe even a query to generate such a report.

  Read the article

• Is it possible to alter the table in admin interface with SQL?

  - by Eric

  In our projects table we have every version of a project. Is it possible to show only those projects where max(version_id) in the admin interface? Thanks! :) Eric

  Read the article

• How do map 1-to-1 relationship in grails to just 1 table under the covers?

  - by egervari

  Let's say I have a UserAccount domain class that has a UserPreferences domain class. I do this to separate the fields for organization purposes. Is there a way to tell grails/gorm that I really want it to map these domain classes to just the user_account table under the covers? Thanks!

  Read the article

• How do I modify an attribute across all rows in a table?

  - by prgmatic

  Hi folks, My apologies for asking such a novice question but, I need help building a script using either PHP or directly in MySQL that can do the following: Take the values of a column in a table (text) Change them into capitalized words (from "this is a title" to "This Is A Title") Replace the old values (uncapitalized) with the new values (capitalized). Thanks for the help and support.

  Read the article

• loading data from a flat file to table using informatica, having both english and foreign language c

  - by Manish

  I am loading data from a flat file to table using informatica, the file has both english and foreign language characters like chinese, and others. The foreign language characters are not getting displayed properly after loading. How can this problem be solved ? I could solve it by using code page UTF - 16 Encoding of Unicode Platform Endian, earlier i was using different code page UTF-8.

  Read the article

• How to bind DataGrid to display only 25 records of a table having more than 1000 records ..??

  - by Devashri

  I have a datagrid control which is bound to a table which containing more than 1000 records. And i want to show only 25 records once a time. I have used paging in datagrid. But each time the next page index is set, query is fired again. This takes lots of time. So what is the easiest way to bound data in this case to improve performance..??

  Read the article

• Cocoa: how to nest a button inside a Table View cell?

  - by underthetable

  Take a look at the top pane of the Xcode window. There's a table list, with checkboxes in one of the columns. That's the interface I want to do. So how do you nest a button in an NSTableView cell?

  Read the article

• How to create a database table in an installation file for a Drupal Module?

  - by Koning WWWWWWWWWWWWWWWWWWWWWWW

  I am creating a module for Drupal 7.x, and I want to create a database table when the module is installed (enabled for the first time). How can I do this? Thanks.

  Read the article

• how to run Make table query that i have in access in C# code ?

  - by Gold

  hi i have query (DO2) in access that makes a table and inserting any data. how to run this query in C# code ? i try this: SQL = "Select * from DO2"; Cmd = new OleDbCommand(SQL, Conn); Cmd.ExecuteNonQuery(); Cmd.Dispose(); but i get error

  Read the article

• MySQL Sub-query.. Doesn't provide proper information after 3 entries into table.

  - by Chris Keefer

  After I get 3 rows in my forum_threads table this no longer does it's job; to organize a list of active forum threads and put the most recently responded-to thread at the top of the list, followed by second most recent posted-to thread, followed by third, fourth, etc. Like I said, the query works wonders up until there is a fourth row added to forum_threads. SELECT forum_threads.*, forum_posts.thread_id FROM forum_threads INNER JOIN (SELECT MAX(id) AS id, thread_id as thread_id FROM forum_posts group by thread_id order by id DESC) forum_posts ON forum_threads.id = forum_posts.thread_id

  Read the article

• how to insert an integer value from a Grid to Sql table?

  - by z-chaos

  Hi, I have a AdvWebGrid where the 7th coloumn is DynEdit where user will enter the value.Now I have to take the enetered value and insert into the Sql tablel. For example i have 7 records in the grid the user will enter some comments for the first three record and save.Now i have to insert/update the first three comments in the table.

  Read the article

• How to SUM() from an offset through the end of the table?

  - by keithjgrant

  If SELECT SUM(amount) FROM transactions ORDER BY order LIMIT 0, 50 sums the amount field for the first 50 records in a table, how do a sum all records after the first 50? In other words, I'd like to do something like SELECT SUM(amount) from transactions ORDER BY order LIMIT 50, *, but that doesn't work.

  Read the article

• Zend Framework: How to subtract amount from database table field ?

  - by NAVEED

  I want to subtract a amount from a table's field in Zend Framework. I can run it with SQL using following query: UPDATE `Person` SET credit=credit-50 where id=1 But how to write above SQL query in Zend Framework?

  Read the article

• How to dump temporary MySQL table into a file?

  - by Alex N.

  Is there a way to create a dump/export/save a temporary MySQL table into a file on disk(.sql file that is, similar to one that is created by mysqldump)?

  Read the article

< Previous Page | 244 245 246 247 248 249 250 251 252 253 254 255  | Next Page >