Search Results

Search found 17240 results on 690 pages for 'query'.

Page 479/690 | < Previous Page | 475 476 477 478 479 480 481 482 483 484 485 486  | Next Page >

• Make a set from CSV values in TSQL

  - by rossfabricant

  If I want to see which values from an Excel spreadsheet column don't match values in a table, I can easily create a table with Bulk Import. Is there a simpler way? EG, I want to do a query like: select into #temp from ('a', 'b', 'c') as 'Id' select * from #temp where Id not in (select Id from MyTable)

  Read the article

• Can you define values in a SQL statement that you can join/union, but are not stored in a table outs

  - by Mervyn

  I'm trying to create a query and need to join against something that I can define values in without creating a table. I'll attempt to describe what I'm trying to do: table1 is joined on field a with table2 (titles for FK in table 1) - Table1 has values outside of what exists in table2 - I want to add an additional 'table' to be unioned with table2 and then joined with table 1 Thanks

  Read the article

• how to find direction of device movement?

  - by JohnWhite

  I am implementing one iphone application in which i want to find direction of device on movement.I dont know how to find.Can u help me for this query.Thnks in advance.

  Read the article

• Copy (or USE) data from two tables in different databases

  - by Z77

  I don-t know how to use one table from one database and second table from another databse at the same time or copy data from table in one database to table from another databse. I tried following query: select * into NewTable from existingdb.dbo.existingTable; But it doesnt't work.

  Read the article

• Clone XML node PHP

  - by Kemrop

  I want to grab an xml node with its attributes plus all the chilren with their attributes and move them to a different node in the same XML file.I believe cloneNode is the most closest thing i can use.Right? Again to be more specific i am using DOM and Xpath to query the node.

  Read the article

• Prepared statement. Can I miss out parameter?

  - by skydreamerr

  I use queries like "UPDATE MAILSCH.MESSAGE " + "SET IDFOLDER=?, SUBJECT=?, CONTENT=?, CREATIONTIME=?, AD_FROM=?, AD_TO=?, STATUS=? " + "WHERE IDMESSAGE=?"; May I miss out IDFOLDER without changing query?

  Read the article

• INSERT 2000 records into SQL Database all at a time from C# .NET code

  - by padmavathi

  We need to INSERT 2000 records into SQL DB from C# .Net code. For this is there any way to INSERT all 2000 records at a time instead of executing the INSERT query for each record. Also how would be the performance impact of doing this? Thanks & Regards Padma

  Read the article

• access forms: forcing UCASE in a textbox

  - by every_answer_gets_a_point

  i would like to force the textbox to immediately change the text to UCASE as soon as the user moves away from the field. is this possible? the important thing is that this text will be used in a SQL query to update a table.

  Read the article

• How do I post long strings that contain special characters (like '&' specifically) via an AJAX reque

  - by user298924

  I'm looking to make a Contact/Query form, wherein the end user can send an email to the webmaster. The form has a 'textarea' field, which captures long strings from the user, if I use AJAX to submit the form using GET method, my params tend to break if their is a special character, specifically '&' in the textarea's string.. I'm stuck please help!

  Read the article

• Lucene Search for documents that have a particular field?

  - by RP

  Lucene.Net - Is there a way to query for documents that contain a particular field. Lets say some of my documents have a field 'foo' and some do not. I want to find all documents that have the field 'foo' - regardless of what the value of foo is. How do I do this? Is it some sort of TermQuery?

  Read the article

• How can I add a column to this union result?

  - by MrXexxed

  I have this query (which I removed some keys from for brevity's sake): SELECT id as in_id, out_id, recipient, sender, read_flag FROM received WHERE recipient=1 UNION ALL SELECT in_id, id AS out_id, recipient, sender, read_flag FROM sent WHERE sender=1 Which combines the results from two tables showing messages sent and received by a given user. What I'd like to do is add a column/flag to the result to distinguish which table the row belongs to so when I display them I can show a relevant icon for sent or received messages. How would I add this?

  Read the article

• How do I select count() and LIMIT?

  - by alex

  SELECT * FROM ...LIMIT 5, 10 But what if I want the total rows? I don't want to make another query without the limit.

  Read the article

• Camping: Return user to recent entries, but keep errors

  - by echoback

  Users can view a specific entry in my webapp with a URL. /entry/8, for example. If an entry doesn't exist, "Entry not found" gets appended to @messages and I render an error page. I'd like to redirect the user to /recent, but I can't figure out a good way to keep the error message around to be displayed. There are other actions that need to take place in the Recent controller, so I can't just duplicate the query and render :posts.

  Read the article

• Java JFrame Remove from Taskbar

  - by ikurtz

  i did a quick topic look and did not find something similar. my query is how do i prevent a child window appearing on the windows taskbar when it is shown?

  Read the article

• Mysql select multiple colomn from non related tables

  - by Ajith

  I have two table in mysql named rootpath with only one field 'root' and savecatogory with fields brandid,categoryid,name.There is no relation between these two tables.Now how can retrieve root,brandid,categoryid using single query.Please help me.

  Read the article

• CONCAT_WS rows in JOIN

  - by Alex Kiselev

  i have tables profiles (id, name, deleted) categories (id, name, deleted) profiles_categories (id, profile_id, category_id, , deleted) I have wrong query SELECT p.id, p.name CONCAT_WS(', ', c.name) AS keywords_categories FROM profiles p LEFT JOIN profiles_categories pc ON p.id = pc.profile_id LEFT JOIN categories c ON pc.id = c.id WHERE p.deleted = FALSE So, i want have result with all profiles with concan categories.name. Thanks

  Read the article

• Selecting all tables with no records

  - by sqlgrasshopper5

  I need to display all tables that have zero records. I tried, select * from user_all_tables where (select count(*) from user_all_tables)=0; But it doesn't seem to work. How should I go about redesigning this query? Thanks.

  Read the article

• Load huge sql dump to mySql

  - by jonathan

  Hi I have a huge mysql dump file generated from phpmyAdmin (150 000 lines of create table, inserts....) The mySql query tool fails to open such a big file. As a result i can't insert all the records. Is there a way to do this ? Thanks John

  Read the article

• summing the sum in mysql

  - by JPro

  Hi, Say If I get a resultset in mysql as : ID count(posts) 101 2344 102 3245 103 232 104 23 Is there any way to get the tota count of count(posts) in the query itself, like this? ID count(posts) 101 2344 102 3245 103 232 104 23 ------ 5844

  Read the article

• does mysql undo changes if you kill thread?

  - by every_answer_gets_a_point

  i ran a delete rows query. it was taking too long so i killed the thread from administration. did it undo the changes to the table/?

  Read the article

• Colored Data in 1 String in a gridview in asp.net?

  - by Kovu

  Hi, I have a resultgridview from a search query. In this gridview I have a name e.g. "aaaaaaaaaabbbbbbbbbbbbcccccccc" If the user serach "bbbbbbbbbbbbbb" I will select the "bbbbbbbbbbbbbb" in the string in the gridview in red and bold. how to do it?

  Read the article

• left join on linq

  - by ognjenb

  SQL: FROM `order` o LEFT JOIN person d ON o.`DistributorId` = d.`Id` LEFT JOIN person c ON o.`CustomerId` = c.Id LEFT JOIN Transporter t ON o.`TransporterId` = t.Id LEFT JOIN IbekoEngineer e ON o.OrderEnteredBy = e.Id In any way to translate this 4 left join to LINQ query

  Read the article

• update XML file

  - by Pila

  I want to replace an XML node that is not a child of the root element. How can I do it - not in .NET 3.5? I don't know the exact path to the node I want to replace, I get the node by XPath query like: XmlElement root = doc.DocumentElement; oldItem = root.SelectSingleNode("//Node1[@name='aaa']//Node2[Item='bbb']/Value"); How can I replace this old item?

  Read the article

• List all tables that are currently published for replication MS-SQL

  - by Scott Vercuski

  I need to get a list of all tables that are published for replication from MS-SQL 2005/2008 databases. Is there a system stored procedure or a query I could run to generate such a list? Thank you,

  Read the article

• Compare two table and find matching columns

  - by Karthick

  Hi, I have two tables table1 and table2, i need to write a select query which will list me the columns that exist in both the tables.(mysql) I need to do for different tables (2 at a time) Is this possible? I tried using INFORMATION_SCHEMA.COLUMNS but am not able to get it right.

  Read the article

< Previous Page | 475 476 477 478 479 480 481 482 483 484 485 486  | Next Page >