Search Results

Search found 26283 results on 1052 pages for 'temporary table'.

Page 389/1052 | < Previous Page | 385 386 387 388 389 390 391 392 393 394 395 396  | Next Page >

• Is there a web-like DB tool for navigating relational databases?

  - by Caffeine Coma

  Is there a tool that implements hyperlink-style navigation between tables via foreign keys? Web-based or native app. For example, if I have table Users, with a column containing a foreign key reference to table Preferences, such a tool would implement simple 1-click access between the rows of the two tables, automatically creating links based on foreign keys.

  Read the article

• Are Conditional subquery

  - by Tobias Schulte

  I have a table foo and a table bar, where each foo might have a bar (and a bar might belong to multiple foos). Now I need to select all foos with a bar. My sql looks like this SELECT * FROM foo f WHERE [...] AND ($param IS NULL OR (SELECT ((COUNT(*))>0) FROM bar b WHERE f.bar = b.id)) with $param being replaced at runtime. The question is: Will the subquery be executed even if param is null, or will the dbms optimize the subquery out?

  Read the article

• Syntax Error in showing Error Description

  - by Sreejesh Kumar

  What is the correct Syntax to be applied for "@[System::ErrorDescription]" inside the query like "INSERT" ? I am unable to retrieve the correct Error Description inside the table, as the result in the table is showing as "@[System::ErrorDescription]". I am not getting the result !

  Read the article

• Restrict update Column

  - by Kushan Hasithe Fernando

  Is it possible to restrict updating a column in SQL without using a trigger ? If so how ? (need the query) PS: I mean, I have a table CREATE TABLE MYBUDGET.tbl_Income ( [IncomeID] INT NOT NULL IDENTITY(1,1), [IncomeCatID] INT NOT NULL, [IncomeAmnt] MONEY NOT NULL, [IncomeCurrencyID] INT NOT NULL, [ExchangeRateID] INT NOT NULL, [IncomeAmnt_LKR] MONEY NOT NULL, [AddedOn] DATETIME NOT NULL, [Remark] VARCHAR(250), ) I need to allow users to update only [ExchangeRateID] and [IncomeAmnt_LKR] fields. All other fields can not be updated. only insert.

  Read the article

• SQL Server "Group By" for an interesting case

  - by stckvrflw

  Hello, I have a table like that 1 A_Team 11 2 A_Team 3 3 B_Team 2 4 A_Team 1 5 A_Team 1 What I want is grouping the same named teams which are also sequential teams So the result table should look like 1 A_Team 14 2 B_Team 2 3 A_Team 2 Thanks

  Read the article

• NullDisplayText in markup or ISNULL(field, 0) in SQL?

  - by abatishchev

  Which approach is better to use: BoundField.NullDisplayText isn't set. NULL-case is foreseen in SQL query, i.e. SELECT ISNULL(amount, 0) FROM table or BoundField.NullDisplayText is set, e.g. "0.00 %". NULL-case isn't foreseen in SQL query, i.e. SELECT amount FROM table What do you think?

  Read the article

• Sqlite3 and PDO problem with ORDER BY

  - by Maenny

  Hi, I try to use the SQL statement SELECT * FROM table ORDER BY column via an PDO-Object in PHP. Problem is, that I always get an error (Call to a member function fetchall() on a non-object - that means, the query did not return a PDO-object) when using the names of all columnname EXCEPT for ID. When I query SELECT * FROM table ORDER BY ID it works. ID is the PRIMARY INTEGER KEY, all other columns are TEXT or NUMERIC, neither of them would works with the ORDER BY clause. Any ideas?

  Read the article

• How to scroll to specific item using jQuery ?

  - by Misha Moroshko

  I have a big table with vertical scroll bar. I would like to scroll to a specific line in this table using jQuery/Javascript. Should I look for plug-ins for this task, or there are built-in methods ? Here is a little example to play with. Thanks a lot !

  Read the article

• Linq to SQL in and not in

  - by pranay_stacker

  what is in and not in equals in Linq to sql ? fore example select * from table in ( ...) and select * from table not in (..) what is equal to above statement in Linq to sql ?

  Read the article

• using ansi sql syntax for formatting Numeric

  - by changed

  Hi I am using two different databases for my project. Oracle and apache derby and trying to use as much as possible ansi sql syntax supported by both of the databases. I have a table with column amount_paid NUMERIC(26,2), in a table. My old code which was using oracle db need to retrieve value in this format SELECT LTRIM(TO_CHAR(amount_paid,'9,999,999,999,999.99')) . How can i do this using ANSI sql syntax.

  Read the article

• how to find duplicated field values and delete them in mysql

  - by Mac Taylor

  Consider we have a field named (username) in our table named (tpl_users), now this table has lots of duplicated rows I wrote this code to delete duplicated usernames: Delete FROM tpl_users WHERE username = username; How is it possible to delete duplicated usernames?

  Read the article

• find a Stationary points Excel

  - by uv

  Hi, I am looking for a funcation in excel that will show my the Stationary points in th table. for exapmle A point is the lowest point on the table B point is the highest point - after point A C point is lowest point -after point B on the X there are point A,B and C, on the Y there are dates . I hope it is clear - i diddn't find the way to add the excel. Many thanks in advnce Uv

  Read the article

• mysql update unique index

  - by atno

  Is there a way to say UPDATE items SET qty=10 WHERE **unique key** instead of saying UPDATE items SET qty=10 WHERE userID=1 AND listID=10 and itemID=100 on the following table? CREATE TABLE IF NOT EXISTS `items` ( `userID` int(20) NOT NULL, `listID` int(20) NOT NULL, `itemID` int(20) NOT NULL, `qty` int(10) NOT NULL, UNIQUE KEY `unique` (`userID`,`listID`,`itemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  Read the article

• inner join in sql

  - by vini

  SELECT TotalItems.Total_Items ,TotalItems.No_Items_Present ,ItemsTable.No_Of_Items_Ret FROM TotalItems INNER JOIN ItemsTable ON ItemsTable.Item_Name= '" + DropItemName.SelectedValue + "'" this is my SQL query what I want is to retrieve two column values corresponding to the item I enter in my dropdown list from one table and the no_of_items_ret from another table satisfying the condition of the dropdownlist I'm getting all the values corresponding to any item I enter what should i do?

  Read the article

• ASP.net C# Add controls automatically to a data form

  - by user333817

  I am using ASP.net with C# and am looking for a tool that given a SQL table name, reads the table columns and populates an aspx form with controls (textboxes with matching labels). Something like ComponentOne InputPanel, except that this product only works for WinForms. See demo of ComponentOne InputPanel: http://www.componentone.com/newimages/Products/Videos/StudioEnterprise/InputPanel/ComponentOneInputPanel.html

  Read the article

• SQL Server and Identity column

  - by andrew007

  Hi, I just noticed that if I have an identity column in a table, when I insert new rows SQL Server 2008 is automatically filling up the sequence if there are discontinuity. I mean, if in my identity column I have 1,2,5,6 if I insert other two rows in the table the system puts automatically 3,7 in the identity column. Do you know how to control this behavior? THANKS

  Read the article

• Question on XJB

  - by Hima

  I have two tables -- INSTALL_BUILD_RESULTS and BUILD_RESULTS. IBR has a primary key called Install_Build_Id and BR has a primary key called Build_Id. Both are numbers A third table, LINK_BUILD_TO_INSTALL_BUILD is a table simply consisting of the two columns mentioned above, used together as a composite key. How can I write an xjb for these 3 tables.

  Read the article

• How to use Linq To Sql to get Users who has more than 2 photos?

  - by Mike108

  The scenario is I want to get the users who has more than 2 photos. There are two table: [Users] (UserId, UserName) [UserPhotos] (PhotoId, PhotoName, UserId) and UserId is a Foreign Key. A user may have none photo in the [UserPhotos] table. How to use Linq To Sql to get List who has more than 2 photos?

  Read the article

• How can I build a voting system to support multiple types of objects to vote on?

  - by Kyle Hayes

  I'm really looking for something very similar to the way SO is setup where a few different kinds of things can be voted on (questions AND answers). What kind of DB schema, generally, could I use to support voting on many different kinds of objects? Would I have a single Vote table that would have references to other objects in the database? Or do I have to have or should have a separate vote table for each of the objects I would like to vote on.

  Read the article

• Where do I put utility functions in my Python project?

  - by Chetan

  I need to create a function to rotate a given matrix (list of lists) clockwise, and I need to use it in my Table class. Where should I put this utility function (called rotateMatrixClockwise) so I can call it easily from within a function in my Table class?

  Read the article

• Is there a prefered way to specify a text column in SQLite?

  - by JannieT

  Since the SQLite engine will not truncate the data you store in a text column, is there any advantage in being specific with column sizes when you define your schema? Would anyone prefer this: CREATE TABLE contact( id INTEGER PRIMARY KEY, name VARCHAR(45), title VARCHAR(10) ); over this: CREATE TABLE contact( id INTEGER PRIMARY KEY, name TEXT, title TEXT ); Why? Are there advantages to not being specific?

  Read the article

• SQL Server: Declaring variable type based on a column type

  - by Bernard Dy

  In Oracle's PL-SQL, you can declare a variable and define its type based on a table column: declare var1 table.column%TYPE; Is it possible to do something similar in MS SQL Server? I searched but could not find a duplicate for this question. If there is one, please let me know and I'll refer to it and delete this.

  Read the article

• Take data from an XML file and put it into a MySQL database

  - by Aidan

  Hi Guys, I'm looking to construct a script that would go through an XML file. Would find specific tags in it, put them in a table and fill the table with specific tags within them. I'm using MySQL 5.1 so loadXML isn't an option and I think that ExtractData() method wont be much use either.. but I don't really know. What would be the best way to go about this?

  Read the article

• how to swap array-elements to transfer the array from a column-like into a row-like representation

  - by Christian Ammer

  For example: the array a1, a2, a3, b1, b2, b3, c1, c2, c3, d1, d2, d3 represents following table a1, b1, c1, d1 a2, b2, c2, d2 a3, b3, c3, d3 now i like to bring the array into following form a1, b1, c1, d1, a2, b2, c2, d2, a3, b3, c3, d3 Does an algorithm exist, which takes the array (from the first form) and the dimensions of the table as input arguments and which transfers the array into the second form? I thougt of an algorithm which doesn't need to allocate additional memory, instead i think it should be possible to do the job with element-swap operations.

  Read the article

• mysql delete and foreign key constraint

  - by user121196

  I'm deleting selected rows from both table in MYSQL, the two tables have foreign keys. delete d,b from A as b inner join B as d on b.bid=d.bid where b.name like '%xxxx%'; MYSQL complains about foreign keys even though I'm trying to delete from both tables: Error: Cannot delete or update a parent row: a foreign key constraint fails (yyy/d, CONSTRAINT fk_d_bid FOREIGN KEY (bid) REFERENCES b (bid) ON DELETE NO ACTION ON UPDATE NO ACTION) what's the best solution here to delete from both table?

  Read the article

< Previous Page | 385 386 387 388 389 390 391 392 393 394 395 396  | Next Page >