Search Results

Search found 30190 results on 1208 pages for 'table row'.

Page 164/1208 | < Previous Page | 160 161 162 163 164 165 166 167 168 169 170 171  | Next Page >

• Import/Export table definistrions using SQlServer Management Studio

  - by fireBand

  Hi, How to import/export table definitions from my dev database to production database(recreate the whole database). I have Sql server 2005, Sql Management studio with power shell. Thanks in advance.

  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

• New table for every user?

  - by SonOfOmer

  Hi everyone, I want to crate new table for each new user on the web site and I assume that there will be many users, I am sure that search performance will be good, but what is with maintenance?? It is MySQL which has no limit in number of tables. Thanks a lot.

  Read the article

• [Javascript] How to call JS to click a table element

  - by Ricky

  Hi all: Assume I get a table element with ID="emTab", how do I call JS to click it? Thanks.

  Read the article

• delete all from table

  - by I__

  what's faster? DELETE * FROM table_name; or DELETE * FROM table_name where 1=1; why? does truncate table work in access?

  Read the article

• Update table of two different database

  - by chetan

  This is the query to update table in one database that is of other Update test.temp a, test2.temp b Set a.name=b.name Where a.no=b.no; Now I don't want to write every field i.e a.name=b.name Is there any solution?

  Read the article

• Scripting all the constraints and indexes without the create table statement

  - by Ice

  Hi there, How to get a script for all tables about all default constraints and indexes from an existing database? SQL Server Management Studio produces SQL-Scripts with the create table statements and there is no option to dismiss it. Peace Ice

  Read the article

• LaTeX: Breaking long (sub)section titles in Table of Contents

  - by V.Shevchishin

  Hi! Is it possible to tune LaTeX to break automatically long (sub)section titles in the Table of Contents?

  Read the article

• SQL Server: how to create multiple text files from a table

  - by Patrick

  hi, I need to extract data from my SQL Server database into multiple text files. I have a table with 4 columns: UserID, UserName, Tag, Score. I need to create a text file for each Tag (so basically I need to group by Tag and order by score). Before to start I would like to know what's the fastest way to create several text files: File titles = TAG field each line = userID

  Read the article

• Question on jpa joined table inheritance

  - by soontobeared

  Hi, The 'DiscriminatorColumn' annotation isn't creating any column in my parent entity. Where am I going wrong ? Here's my code @Entity @Inheritance(strategy=InheritanceType.JOINED) @DiscriminatorColumn(name="TYPE", discriminatorType=DiscriminatorType.STRING,length=20) public class WorkUnit extends BaseEntityClass implements Serializable{ @Entity @DiscriminatorValue(value="G") @Table(name="Group_") @PrimaryKeyJoinColumn public class Group extends WorkUnit implements Serializable{

  Read the article

• Archive Parent / Child Table Hierarchy in MySQL

  - by Eric J.

  If I have a Parent and Child table in MySQL related by a foreign key, is it possible using a SQL statement to move certain rows from Parent and the related rows from Child into archive tables (e.g. Parent_Archive and Child_Archive) in an atomic manner?

  Read the article

• Convert dependencies to point to View instead of Table

  - by jwarzech

  I currently have a SQL Server 2008 database in which I am planning to separate out some tables to other databases. I want to be able to replace all references to the separated tables from the original database using views. Is there a better way (other than manually changing all FK and SProc references) to switch all the dependencies to reference the view instead of the table?

  Read the article

• Ado.net Entities + get table by T

  - by john

  Hi all Is it posible to get a table to do queries on with Ado.net Entities? In linq ou could do DataContext.GetTable.Where...... Thanks in advance

  Read the article

• Hash Table question [closed]

  - by Fatimah

  I need your help to solve this program ... Implement a separate chaining hash table that stores strings. You’ll need a hash function that converts string into an index number. Assume the strings will be lowercase words, so 26 characters will suffice.

  Read the article

• Query for second maximum salary from employee table

  - by Dinesh

  how to find out second maximum salary from all employee in employee table ? please give me sql query.

  Read the article

• MySQL: Update table column from subquery result

  - by Jhourlad Estrella

  On the Members table are columns "MemberID" and "PointsEarned". I want to update the PointsEarned column from the result of this query: SELECT m.MemberID, m.UserName, ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=2)*10 ) + ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=3)*3 ) + ( (SELECT COUNT(*) FROM ChatMessages as c WHERE c.MemberID=m.MemberID)*.1 ) as PointsEarned FROM Members as m Can anybody tell me how I should do it with a single query? Thanks!

  Read the article

• in mysql table update 'a' record with 'b' and 'b' with 'a'

  - by chetan

  IN my table there are two field one is name and other is gender I want to fire query so that every male is update with female and vice a versa. I don't want to use procedure ,trigger or function.I have to do this only with simple query.

  Read the article

• How to decrease width of table view cells for iphone

  - by David Hsu

  I'm trying to create a grouped table view with two sections. For the first section I would like the width to be only half the screen. For the second section it would be the standard width. Also, next to the first section I would like to put a button. How is this done? Thanks!

  Read the article

• Update all table rows but top N in Mysql

  - by arthurprs

  I was trying to run the following query UPDATE blog_post SET `thumbnail_present`=0, `thumbnail_size`=0, `thumbnail_data`='' WHERE `blog_post` NOT IN ( SELECT `blog_post` FROM blog_post ORDER BY `blog_post` DESC LIMIT 10) But Mysql doesn't allow 'LIMIT' in an 'IN' subquery. I think I can make a select to count the table rows and then make an ordered update limited by 'COUNT - 10', but I was wondering if there is a better way. Thanks in advance.

  Read the article

• have mysql select statement return fully qualified column names like table.field

  - by handsomeGun

  is there a way to have a mysql select statement return fully qualified column names like "table.field" without using AS for every single field? like so: SELECT * FROM table1 LEFT JOIN table2 on table1.f_ID = table2.ID and the result would be: "table1.ID", "table1.name", "table2.ID", "table2.name", ...

  Read the article

• Using a Hash table

  - by Maria Attard

  I have 2 lists in my program one that store objects of type student and another one which stores objects of type marks. I have 3 methods one that inputs the details of the students, one that inputs the marks and one to view student details and their marks. My question is how I can use a hash table to get the Id of a student and then use it to input the marks and then how to retrieve both the student details and their marks altogether. Please help me if you can.

  Read the article

• How to store data in a table locally and present it in C#

  - by joslinm

  I want to setup a table that can: Save the data on the user's machine Reference & present the data in the GUI Capable of adding rows dynamically during runtime What's the best way to go about this? DataGridView or TableLayoutPanel or...? I'm having trouble with SQL server CE, as I was going to connect it with the DataGridView, but I'm very new to this kind of work, and wondered if it was even necessary to use SQL.

  Read the article

• sql: delete a subtree table(id, Parentid) , delete a item with all his children

  - by Omu

  I have a table like this foo(id, parentId) -- there is a FK constraint from parentId to id and I need to delete an item with all his children and children of the children etc. anybody knows how ?

  Read the article

• How to insert the last id from a table into another table in MySQL?

  - by James

  I want to take the id of the most recent item in a database, increment it by one and insert that new id in to another table. I tried: $select = mysql_query("SELECT id FROM tableName ORDER BY id DESC"); while ($return = mysql_fetch_assoc($select)) { $id = $return['id']; $newId = $id++; } mysql_query("INSERT INTO anotherTable (someColumn) VALUES ('$newId')"); But it didn't work. How can this be done?

  Read the article

• jQuery and HTML visual glitches on table cell .toggle

  - by Forkrul Assail

  I have table that gets dynamically created. When using jQuery and toggle, everything works. I however get a small visual glitch - it seems the HTML sometimes get selected. How would I disable this on a faulty drag or mouse operation? Is there a difference in the DOM between text in a cell and 'not text' or buffered space in a td? Thanks in advance.

  Read the article

< Previous Page | 160 161 162 163 164 165 166 167 168 169 170 171  | Next Page >