Search Results

Search found 34274 results on 1371 pages for 'mysql table'.

Page 455/1371 | < Previous Page | 451 452 453 454 455 456 457 458 459 460 461 462  | Next Page >

• copy a table with data to another db in sql server 2005 express

  - by Luca Romagnoli

  hi, i've a db with a table. i want copy it with the data in another db. How can i do it in sql server 2005 express? thanks

  Read the article

• How do I customize a table view?

  - by Nathan

  Interface Builder Question I know there's a way to change the background color of a table, but is there a way to change the text color? Please Help

  Read the article

• I cannot get the value of a table view cell in cocoa touch

  - by Michael Amici

  I am trying to get the value of a cell in a table view but it won't let me. If someone could help that would be great. int numberOfChecks = -1; numberOfChecks = numberOfChecks +1; if ([objectsForTable count]-1 >= numberOfChecks) { UITableViewCell *cell = [self.tableView cellForRowAtIndexPath:numberOfChecks]; NSString *cellTitle = cell.textLabel.text; }

  Read the article

• Select distinct values from a table field

  - by alj

  I'm struggling getting my head around the Django's ORM. What I want to do is get a list of distinct values within a field on my table .... the equivalent of one of the following: SELECT DISTINCT myfieldname FROM mytable (or alternatively) SELECT myfieldname FROM mytable GROUP BY myfieldname I'd at least like to do it the Django way before resorting to raw sql.

  Read the article

• Query for retrieving top two rows from a table in SQL Server

  - by Praveen

  Hi All, I have a table called Employee with EmpID,Salary,Name fields. I want to get top two employees with maximum salary. How can i write this query ?

  Read the article

• select distinct col1 with min(col2) and max(col3) from table

  - by user338804

  My table looks like this with duplicates in col1 col1, col2, col3, col4 1, 1, 0, a 1, 2, 1, a 1, 3, 1, a 2, 4, 1, b 3, 5, 0, c I want to select distinct col1 with max (col3) and min(col2); so result set will be: col1, col2, col3, col4 1, 2, 1, a 2, 4, 1, b 3, 5, 0, c I have a solution but looking for best ideas?

  Read the article

• Move row from one table to another?

  - by lance

  I have two tables with the same column definitions. I need to move (not copy) a row from one table to another. Before I go off and use INSERT INTO/DELETE (in a transaction), is there a smarter way? SQL Server 2005

  Read the article

• what is an index in a table?

  - by Ramesh

  What is an index in table? Related with realworld entitly like librabry. what are the types of indexes? please related this too also with real world entity.

  Read the article

• Setting column width in Table View

  - by Jeremy

  I am having a hard time understanding how to change the width of columns when creating a table view. I know you can set the width in pixels of a column but that is not what I want to do. Say, for instance, I have 2 columns and want each column to take up half the screen. How do I do this without explicitly setting the pixels, so that my code can work on multiple screen sizes?

  Read the article

• Passing table data to PRPT from xaction

  - by Manoj

  I am getting data from a query and processing it using Javascript in the xaction file. Now I want to pass the processed data (a 2D array) down to a prpt where it will be used to generate graph and table. What is the format in which Javascript would generate the data and how is it passed to and received by the prpt file from the xaction. Thanks...

  Read the article

• Change the Default Size of the filterBy text box in Rich Table

  - by Nisansala

  How can I change the Default Size of the filterBy text box in Rich Table? In all the columns, it has a same (fix) size. I used the property width, but it didn't work.

  Read the article

• Determine Last Modification Datetime for an Azure Table

  - by embeddedprogrammer

  I am developing an application which may be hosted on a microsoft sql server, or on Azure SQL, depending upon the end user's wishes. My whole system works fine with the exception of some WCF functions which determine the last modification time of tables using the following technique: SELECT OBJECT_NAME(OBJECT_ID) as tableName, last_user_update as lastUpdate FROM mydb.sys.dm_db_index_usage_stats This query fails in Azure. Is there any analogous way to get table last modification dates from Azure's sql?

  Read the article

• Nth Largest element from a table sql Query

  - by Binu

  can any one explain hiow this query works..It's for getting the Nth largest elemet from a table.here it's 4 th largest SELECT a.ID FROM tblitem a WHERE (4) = (select count(*) from tblItem b where b.id < a.id) Thanks in advance

  Read the article

• how to generate primary key values while inserting data into table through pl/sql stored procedure

  - by thulasi policherla

  hi friends, I am trying to insert data into particular table through pl/sql stored procedure,my requirement is while inserting i should generate PRIMARY KEY values for particular column and also i should return that PRIMARY KEY value to output and one more thing is that for another column i should validate my string such that it should contain only characters not integers. please help me in writing code for the above requirement Thanks and regards thulasi policherla

  Read the article

• Taking backup of data in a table.

  - by Rishabh Ohri

  Hi All, Is there some way to backup the data in a table in sql server by using sql scripts. Note: I dont want to take the backup of the whole database. And later on restore the same data back in case of any failure. Please suggest some solution.

  Read the article

• Hash Table v/s STL map in C++

  - by anon

  Hi, I am trying to learn C++ maps. Was just wondering about the implementation of STL map. I read it employs Binary search tree. Is there a implementation of hash table in STL? How exactly do STL map stores Key Value pairs?

  Read the article

• GDI+ Problem drawing a table

  - by Emanuel

  I try to draw a table on a panel in C# Windows Form by using GDI+. The problem is that when I minimize the application, my drawing disappears. How can I avoid this and why acting this way?

  Read the article

• Naming of boolean column in database table

  - by Space Cracker

  I have 'Service' table and the following column description as below Is User Verification Required for service ? Is User's Email Activation Required for the service ? Is User's Mobile Activation required for the service ? I Hesitate in naming these columns as below IsVerificationRequired IsEmailActivationRequired IsMobileActivationRequired or RequireVerification RequireEmailActivation RequireMobileActivation I can't determined which way is the best .So, Is one of the above suggested name is the best or is there other better ones ?

  Read the article

• SQL Server 2005: Insert a row in a table and update the same row

  - by vikas

  eg:table pkey --guid annualpay datefrom dateto--if null means current record percentannualincrease percent annual increase will be calculated only if there is a difference in newly inserted and previously existing last differing value. percentannualincrease = ([newannualpay-just previous pay(if different from current)]/newannualpay)*100 eg newid(),5000,today,null,0--very first row newid(),5000,today+1,null(*),0 newid,5500,today+2,null(*),?????????????--> need to be calculated before insert *--insert will close the previous record by updating dateto=null to todays date How can I do this stuff in a trigger???

  Read the article

• Transfer table from one database to another?

  - by Mahmoud

  Hey all i am working at my project where it collects information from two database, one is supplied by the program lets name it DB Y and the other supplied by the user lets name it DB X , now i have an query that depends on companies which is on DB x so i want to transfer this table from DB x to DB y at run time and also checks if there is new updates in DB x and transfer them but i am confused

  Read the article

• java table question

  - by kate

  hello i have a issue and i want your help i have a table which is called citylink[10][2] and i want to make a check before i move on in my code if it's full to continue if it's not to break!!i know that i should use an if loop but i don't know what to put inside it!!

  Read the article

• Hibernate Annotation (Pyramid Structure - same table)

  - by fatnjazzy

  Hi, I have a person table that contains the following fields: id, name, parent_id. the parent_id is actually a FK for column id. the data should look like this (Like a pyramid): "id" "name" "parent_id" "1" "I am the Top Father" "1" "2" "My Father Is 1" "1" "3" "My Father Is 2" "2" "4" "My Father Is 2" "2" How is my bean suppose to look like? Thanks

  Read the article

• Add table to SPDatabase object

  - by Ramnik

  I have created a database using a SPDatabase class. How can i add a table to it? and how to execute SQL queries in this database? Thanx....

  Read the article

• preg_match() find all values inside of table?

  - by mathiregister

  hey guys, a curl function returns a string $widget that contains regular html - two divs where the first div holds a table with various values inside of <td>'s. i wonder what's the easiest and best way for me to extract only all the values inside of the <td>'s so i have blank values without the remaining html. any idea what the pattern for the preg_match should look like? thank you.

  Read the article

• if validation on the form field fails, set visible=true on a table row

  - by Blankman

  I have a table row that has the error message in it. ... Now if someone forgets to enter text or bad text in a textbox, I want this form field to be set to visible. Can I use a asp.net validator for this or?

  Read the article

< Previous Page | 451 452 453 454 455 456 457 458 459 460 461 462  | Next Page >