Search Results

Search found 24890 results on 996 pages for 'pivot table'.

Page 179/996 | < Previous Page | 175 176 177 178 179 180 181 182 183 184 185 186  | Next Page >

• How to configure reference to be deleted on parent table update?

  - by abatishchev

  I have two tables: info: ID, fee_id and fee: ID, amount and a reference between them (SQL Server 2008): ALTER TABLE info WITH CHECK ADD CONSTRAINT FK_info_fee FOREIGN KEY(fee_id) REFERENCES fee (ID) ALTER TABLE info CHECK CONSTRAINT FK_info_fee GO How to configure this reference that way so a record in fee will be deleted if info.fee_id becomes NULL

  Read the article

• Can I have different configuration of rows in different section of table view?

  - by Siegfried

  Can I have different configuration of rows in different section of table view? This method doesn't contains the section parameter: -(UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath So is it possible to do differently for different sections in the same table view?

  Read the article

• Should I store logging information in main database table?

  - by Mike

  For example, say I have a table of products. Should I store logging information such as who it was created by, last edited by, last updated date, ... Or should I separate the logging information in say an auditing table if the logging information is not relevant to the actual application? Thank you.

  Read the article

• How can i learn Table Name in database an column name?

  - by Phsika

  How can i learn table Name in database an how can i learn any Table's Column name? SELECT Col.COLUMN_NAME, Col.DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS AS Col LEFT OUTER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE AS Usg ON Col.TABLE_NAME = Usg.TABLE_NAME AND Col.COLUMN_NAME = Usg.COLUMN_NAME LEFT OUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS Con ON Usg.CONSTRAINT_NAME = Con.CONSTRAINT_NAME WHERE Col.TABLE_NAME = 'Addresses_Temp' AND Con.Constraint_TYPE = 'PRIMARY KEY' But it returns to me empty data:(

  Read the article

• What logic can be applied to create the Insert query from given Audit table?

  - by Parth

  i need to create a PHP script to create the insert query to insert in a table, The table from which I need to fetch out the data to create insert query is given below.. The query has to be like this INSERT INTO table_name (field1,field2, field3...) values('newvalue','newvalue','newvalue',....) Please Help... Thanks

  Read the article

• Can you have cell specific background colors in the table-plus macro on Confluence?

  - by oo

  I am using this table-plus macro with Confluence: http://confluence.atlassian.com/display/CONFEXT/Table-plus+macro Can I have cell level formatting? I only see column level formatting.

  Read the article

• how Do I list all table names in SQL Server using T-SQL?

  - by shrimpy

  SELECT name FROM sys.databases -- this can list all database name in the server user database SELECT * FROM INFORMATION_SCHEMA.TABLES -- these two line can list the table for one particular database But how can I output the results like below? Database Table --------- ------------- db1 t1 db1 t2 db2 t1 ... ...

  Read the article

• How to store MySQL query results in another Table?

  - by Taz

  How to store results from following query into another table. Considering there is an appropriate table already created. SELECT labels.label,shortabstracts.ShortAbstract,images.LinkToImage,types.Type FROM ner.images,ner.labels,ner.shortabstracts,ner.types WHERE labels.Resource=images.Resource AND labels.Resource=shortabstracts.Resource AND labels.Resource=types.Resource;

  Read the article

• Looking for production quality Hash table/ unordered map implementation to learn?

  - by Passionate programmer

  Looking for good source code either in C or C++ or Python to understand how a hash function is implemented and also how a hash table is implemented using it. Very good material on how hash fn and hash table implementation works. Thanks in advance.

  Read the article

• What short query will return an vector (a one-column column table) representing a set of integers fr

  - by Ivan

  Assuming we have no actual table to select the data from, what do we need to SELECT to return a table consisting of one integer column containing all integer numbers starting with x1 and finishing with x2 and sorted in ascending order?

  Read the article

• jQuery - How to Use slideDown (or show) function on a table row?

  - by Greg

  I'm trying to add a row to a table and have that row slide into view, however the slidedown function seems to be adding a display:block style to the table row which messes up the layout. Any ideas how to work around this? Here's the code: $.get('/some_url',{'val1':id}, function(data){ var row = $('#detailed_edit_row'); row.hide(); row.html(data); row.slideDown(1000); });

  Read the article

• Why MS Access adodb in .NET returns 34 in fieldcount when table has 42 fields ?

  - by RocketSurgeon

  Why MS Access adodb in .NET returns 34 in fieldcount when table has 42 fields ? I see 42 fields in table of my MS Access mdb database. But ADODB layer in .NET sees only 34 fields. The Outofrange exception occures when I am calling method getOrdinal("FieldName") of reader class. Is it something I am missing in setting up connection, license or anything? Thank you

  Read the article

• How to retrieve last primary Id from mdb's table?

  - by William

  I got table with next columns: Id, Name, Age, Class I am trying to insert new row in db like this: INSERT INTO MyTable (Name, Age, Class) VALUES (@name, @age, @class) And get an exeption: "Index or primary key cannot contain a Null value." The question is how to add a new row without knowing next primary Id, or maybe there is a way to get this Id from the table with the help of another query ?

  Read the article

• using JSTL get values from table ture or false i wants to print(map) thses values Yes or No in our j

  - by mansoor

  i get values from table true or false which i set boolean when i save a new record. But i want when i retive these values from table using JSTL How i could print(map) these true and false value on YES and NO values in our jsp pages.

  Read the article

• Database design (MySql)::should we put html data in text field inside database table or more efficie

  - by meyosef

  Hi, We building big Web Application and we use mysql, we want to make mysql database more fast. Some of us think if we will put message html body inside table and not inside text.txt in will make database heavy and not fast. Thanks, *Part of main table that hold message: option 1:hold html message body inside database message { id (int) subject (varchar) body (text) } option 2: hold html message body inside body1.txt file message { id (int) subject (varchar) file_body_path (varchar) } *

  Read the article

• How to design an exception logging table using HyperTable and access it via the Java client?

  - by ikevinjp

  If I have the following table schema to log an exception (in standard SQL schema): Table: ExceptionLog Columns: ID (Long), ExceptionClass (String), ExceptionMessage (String), Host (String), Port (Integer), HttpHeader (String), HttpPostBody (String), HttpMethod (String) How would I design the same thing in HyperTable (specifically, what is the best approach for efficiency)? And, how would I code it using the HyperTable Java client?

  Read the article

• Cam you insert the results of a dynamic sql call into a SQL Server 2005 table variable

  - by codingguy3000

  Is there anyway to do this in SQL Server 2005? declare @tv_tablelist table (recnum int identity(1,1) primary key, newvar varchar(500)) declare @mysql nvarchar(4000) set @mysql = 'insert into @tv_tablelist(newvar) values (''test test test'')' Exec sp_executesql @mysql, N'@tv_tablelist table (recnum int identity(1,1) primary key, newvar varchar(500)) OUTPUT', @tv_tablelist OUTPUT select * from @tv_tablelist

  Read the article

• Is there a jquery plugin for table paginnation and sorting support via ajax call?

  - by Ethan

  I am looking for a jquery plugin for table paginnation and sorting (and search/filtering hopefully). Datasource could be obtained locally or via ajax call. Hopefully comes with most of the features of this script: http://www.leigeber.com/2009/11/advanced-javascript-table-sorter/ Here is the demo of this script: http://sandbox.leigeber.com/tinytablev3/index.html The problem with this script is that it only support local datasource.

  Read the article

• How do I use a MySQL subquery to count the number of rows in a foreign table?

  - by James Skidmore

  I have two tables, users and reports. Each user has no, one, or multiple reports associated with it, and the reports table has a user_id field. I have the following query, and I need to add to each row a count of how many reports the user has: SELECT * FROM users LIMIT 1, 10 Do I need to use a subquery, and if so, how can I use it efficently? The reports table has thousands and thousands of rows.

  Read the article

• import a text file into a temporary table using 'Load data infile' in a stored procedure- MySQL

  - by Pankaj

  I need to import a text file into a temporary table and from that select portions of it to insert in different tables. I wanted to use 'LOAD DATA INFILE'. Is there any way, i can use 'Load data infile' in a stored procedure. I am using mysql. LOAD DATA LOCAL INFILE 'C:\\MyData.txt' INTO TABLE tempprod fields terminated by ',' lines terminated by '\r\n'; SELECT * FROM product p;

  Read the article

• What is symbol table and how is it integrated into the executable?

  - by user198729

  When I tried to debug an executable: (gdb) break +1 No symbol table is loaded. Use the "file" command. What does that mean exactly? Is the symbol table appended to the executable?

  Read the article

• Is there a way to listen for changes in an MySQL database table using Java and JDBC?

  - by adrian7

  I have a number of users which are logged in at a time in my desktop application. They are working on the same table (create, read, update, delete data) so I have to update their views, to reflect changes, every few seconds - currently I am thinking to use a different thread to do that. I am using the MySQL database engine. Is there a way, using JDBC, to listen for changes on a specific table in the database and triggering a Java method only when changes are made?

  Read the article

• How do you fix a MySQL "Incorrect key file" error when you can't repair the table?

  - by Wayne M

  I'm trying to run a rather large query that is supposed to run nightly to populate a table. I'm getting an error saying Incorrect key file for table '/var/tmp/#sql_201e_0.MYI'; try to repair it but the storage engine I'm using (whatever the default is, I guess?) doesn't support repairing tables. how do I fix this so I can run the query?

  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

• Do I need to drop index on temp table?

  - by Phil

  Hi, Fairly simple question, but I don't see it anywhere else on SO: Do indexes (indices?) on a temporary table get automatically deleted with the temporary table? I'd imagine they do but I don't really know how to check to make sure. Thanks, Phil

  Read the article

< Previous Page | 175 176 177 178 179 180 181 182 183 184 185 186  | Next Page >