sql clarification
- by JPro
Can anyone please clarify what this query will return ?
SELECT TestCase FROM MyTable WHERE Verdict = 'PASS' AND
StartTime > DATE_SUB(NOW(), INTERVAL 2 MONTH)
Search Results
Search found 20208 results on 809 pages for 'compiled query'.
Page 563/809 | < Previous Page | 559 560 561 562 563 564 565 566 567 568 569 570 | Next Page >
-
-
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
-
iPhone to host server to mySQL and back?
- by ronbowalker
Can someone please direct me to process for doing this? I have already done the Login verification exercise using mySQL for the dbase on my host server (thanks to kiksy). Now I am trying to move forward and "Query" from the iPhone a list of "users" that currently occupy the table (iphoneusers) in MySQL. And of course get it back to the iPhone via…Read the article
-
case-insensitive search of MySQL?
- by Haroldo
case-insensitive search of MySQL? For my site search, what is the most efficient way of to query my db for a word/phrase regardless of case?Read the article
-
linq group by with count
- by snorlaks
Hello, Im trying to write query in linq Select UserId, UserNumber FROM User where UserNumber in (Select UserNumber FROM User group by UserNumber having Count(UserId) = 1) Aby hints ?Read the article
-
Get all design documents in CouchDB
- by karlthorwald
How can I get a list of all design documents in CouchDB? Using a http query, not futon.Read the article
-
I am searching for a string like Cityname, State in mysql table where state name is 2 letter char.
- by subson
I am searching for a string like Cityname, State (e.g.Moline,IL) in mysql table. How can i make the query using regexp in mysql.Read the article
-
XML XQUERY Problem with NTEXT data type
- by johnfa
Hello I want to use XQuery on a column of data type NTEXT (I have no choice!). I have tried converting the column to XML using CONVERT but it gives the error: Incorrect syntax near the keyword 'CONVERT'. Here's the query SELECT y.item.value('@UserID', 'varchar(50)') AS UnitID, y.item.value('@ListingID', 'varchar(100)') AS…Read the article
-
Excluding records based upon a one to many SQL join
- by tequila2k
How would I write a SQL query that excludes a record if one (external) record from a one to many join matches a certain condition? For example: Details ID 1 2 Items DetailID Item 1 A 1 B 2 B 2 C How would I select the detail records where the Items do not include 'A'?Read the article
-
How to create Local Data Caching in c# WinApps?
- by kurt_jackson19
Anyone can give me an example on how to create local data caching? Like for example I query 10 millions records from my DB and I want to store it in my local so that I would not encounter performance problem next time when I want to reload the data. Thank you so much.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…Read the article
-
Update on #temp table is faster then the @ table variable.
- by pansingh
In the similar query Update on #temp table is faster then the @ table variable. But I m forced to use table variable as I am wokring with function. I feel index is not being picked up for table variable. I have unique clustered index. Please helpRead the article
-
HTML actual page link
- by lore3d
Hi all, I'm building a website, and i need to know the actual page address in which the user is in, in order to take users in the same page after login. The problem is that every page is generated from variables passed by url and query string, so I dont't know how to recover every variable and assign to it the correct value. How to…Read the article
-
How can i add '"-" in column
- by jasmeet
my query is showing in row 2000 the data of 2000-2001 & in 2001 the data of 2001-2002. how can i change the column so that it displayes column 1 column 2 2000-2001 5 2001-2002 3 2002-2003 9 2003-2004 12 . . . . and so on...Read the article
-
Order results by another table?
- by user3462020
I'm working on a custom forum system and I'm trying to figure out how to put a thread on the top of the list if a user posts in it. I've got this for my query SELECT user_threads.threadID, user_threads.title, user_threads.uid, user_threads.postDate, thread_messages.posted FROM user_threads, thread_messages WHERE …Read the article
-
Get matching route from URL in rails (again)
- by fturtle
Hi, How can I get hold of the matching route for a url in rails? Given a url, I want to query the respective controller and action. Note, the current page isn't the url in question. This question has been posed before but wasn't answered. Cheers.Read the article
-
SQLite FTS3 sumulate LIKE somestrin%
- by alex
I'm writing a dictionary app and need to do the usual word suggesting while typing. LIKE somestrin% is rather slow (~1300ms on a ~100k row table) so I've turned to FTS3. Problem is, I haven't found a sane way to search from the beginning of a string. Now I'm performing a query like SELECT word, offsets(entries) FROM entries…Read the article
-
SQL Performance Question (no where clause vs where column like '%')
- by infocyde
Hi, in a query, is there any performance hit by doing a where clause like so select bunchofstuff from sometable where column like '%' vs select bunchofstuff from sometable Building some dynamic queries, just curious. Thanks.Read the article
-
SQL top + count() confusion
- by vasin
I've got the following table: patients id name diagnosis_id What I need to do is get all the patients with N most popular diagnosis. And I'm getting nothing using this query: SELECT name FROM patients WHERE diagnosis_id IN (SELECT TOP(5) COUNT(diagnosis_id) FROM patients GROUP BY diagnosis_id ORDER BY diagnosis_id) How to fix…Read the article
-
MySQL Wildcards * and %
- by RussellDias
What is the difference between % and * wildcards in MySQL? In a query like so : "SELECT * FROM $table WHERE MATCH (message) AGAINST('$string*' IN BOOLEAN MODE)"Read the article
-
Building Visual Studio Setup Projects with TFS 2010 Team Build
- by Jakob Ehn
One of the most common complaints from people starting to use Team Build is that is doesn’t support building Microsoft’s own Setup and Deployment project (*.vdproj). When creating a default build definition that compiles a solution containing a setup project, you’ll get the following warning: The…Read the article
-
Advanced Data Source Engine coming to Telerik Reporting Q1 2010
This is the final blog post from the pre-release series. In it we are going to share with you some of the updates coming to our reporting solution in Q1 2010. A new Declarative Data Source Engine will be added to Telerik Reporting, that will allow full control over data management, and deliver significant gains in…Read the article
-
Using SQL Developer to Debug your Anonymous PL/SQL Blocks
- by JeffS
Everyone knows that SQL Developer has a PL/SQL debugger – check! Everyone also knows that it’s only setup for debugging standalone PL/SQL objects like Functions, Procedures, and Packages, right? – NO! SQL Developer can also debug your Stored Java Procedures AND it can debug your standalone PLSQL blocks. These bits…Read the article
-
How LINQ to Object statements work
- by rajbk
This post goes into detail as to now LINQ statements work when querying a collection of objects. This topic assumes you have an understanding of how generics, delegates, implicitly typed variables, lambda expressions, object/collection initializers, extension methods and the yield statement work. I would also…Read the article
-
USB software protection dongle for Java with an SDK which is cross-platform “for real”. Does it exist?
- by Unai Vivi
What I'd like to ask is if anybody knows about an hardware USB-dongle for software protection which offers a very complete out-of-the-box API support for cross-platform Java deployments. Its SDK should provide a jar (only one, not one different library per OS & bitness) ready to be added to one's project…Read the article
