Search Results

Search found 25852 results on 1035 pages for 'linq query syntax'.

Page 308/1035 | < Previous Page | 304 305 306 307 308 309 310 311 312 313 314 315  | Next Page >

• Can I create a table with check constrain whose values are dependent on sql query

  - by Shantanu Gupta

  Is it possible to create a table which has a check constraint on one of the column whose value lies within the result set given by another sql query eg. create table tablename ( name varchar(10), rollno int )check rollno in (select rollno from anotherDatabase.TableName,candidateRoll) or any thing like that. I dont have to use it anywhere but still want to know.

  Read the article

• MySQL: How to add one day to datetime field in query

  - by phpBOY

  Hello, In my table I have a field named eventdate in datetime format like 2010-05-11 00:00:00. How do i make a query so that it adds one day to the eventdate eg if today is 2010-05-11, i want to show in where clause to return all records with tomorrow's date.

  Read the article

• PHP GET number query

  - by Jordan

  Hi to all! I have a query that gets the name and an id. The results is like this : 54 - Rian Ree Barrientos I wanted to get the number 54. I used echo (int)$_GET['number']; But the result is "0". How can I get the number?

  Read the article

• please help me construct this MYSQL Query (date / time)

  - by sebb

  Hi there i would like to construct a query that fetches results that occurred between NOW and 15 minutes ago, im getting a mysql error when I try the following , can you help me? thanks SELECT * WHERE user_id = '000' AND date_time < now( ) AND date_time > DATE_SUB( now( ) , INTERVAL 15 MINUTE)

  Read the article

• passing a scalar query result to coalesce

  - by Fakrudeen

  How can I pass the result from a scalar [single row, single value] query to coalesce? I am trying to pick the priority as (the biggest priority so far in the table) + 1. [0 if it is the first row.] create trigger priority_SuperRuleSamples before insert on SuperRuleSamples FOR EACH ROW SET NEW.Priority=coalesce(NEW.Priority, coalesce( select Priority from SuperRuleSamples order by Priority desc limit 1, -1 )+1 )

  Read the article

• question with its query

  - by user329820

  Hi this is my homework and the question is this: List the average balance of customers by city and short zip code (the first five digits of thezip code). Only include customers residing in Washington State (‘WA’). also the Customer table has 5 columns(Name,Family,CustZip,CustCity,CustAVGBal) I wrote the query like below is this correct? SELECT CustCity,LEFT(CustZip,5) AS NewCustZip,CustAVGBal FROM Customer WHERE CustCity = 'WA' THANKS!!

  Read the article

• Elegant way of parsing (at the server side) the query constructed from the UI

  - by Vishal

  The UI looks like: Condition 1 (Checkbox) and/or (Radio buttons) Condtion 2 (Checkbox) and/or (Radio buttons) Condition 3 (Checkbox) and/or (Radio buttons) Condition 4 (Checkbox) I would like to parse (at the server-side) the query constructed from the client (for possible combinations). Any design ideas? PS: May be the UI can be designed better. Posts appreciated. Thanks

  Read the article

• How do I explain a query with parameters in MySQL

  - by Michael Barker

  I have a query SELECT foo FROM bar WHERE some_column = ? How do I get a explain plan from MySQL without filling in a value for the parameter?

  Read the article

• Query posts based on author id

  - by user338109

  I have the current author id stored in $theauthorid I want to do a query based on the author id so I do this query_posts('author=$theauthorid'); However it does not work unless I write the id manually. I know the id is stored correctly as I get the correct id when I echo it.

  Read the article

• need help on my query.

  - by Dharmendra

  i have one table : nobel(yr, subject, winner) and i have this query : In which years was the Physics prize awarded but no Chemistry prize. this is what i tried : select distinct yr from nobel where subject='physics' and subject!='chemistry' but is not working where i am going wrong. see, i am not here to make my homework from someone. i am here to learn something. so, please give me suggetion.

  Read the article

• Best way to use number format in mysql query

  - by PHP-Prabhu

  can any one please let me know, i need to set the "Total Price" value to be in two decimal point value like "56.35". Now its showing more fraction values like "56.3566666". I need it to be format it by musql "SELECT" query.

  Read the article

• Update multiple table column values using single query

  - by Dave Jarvis

  How would you update data in multiple tables using a single query? In MySQL it would be: UPDATE party p LEFT JOIN party_name n ON p.party_id = n.party_id LEFT JOIN party_details d ON p.party_id = d.party_id LEFT JOIN incident_participant ip ON ip.party_id = p.party_id LEFT JOIN incident i ON ip.incident_id = i.incident_id SET p.employee_id = NULL, c.em_address = '[email protected]', c.ad_postal = 'x', n.first_name = 'x', n.last_name = 'x' WHERE i.confidential_dt IS NOT NULL What is the equivalent SQL statement using Oracle 11g? (Is ANSI SQL possible?) Thank you!

  Read the article

• SQL query showing missing expression

  - by Ashok Dasari

  Query to pull the data between Yseterday 6AM to today 6AM ... SELECT lot_id, log_time, batch_no, eqp_id, STATION_ID, EXTRACTVALUE (META_DATA, '/lot_info/A3') AS A3, EXTRACTVALUE (META_DATA, '/lot_info/A3Info') AS A3Info, EXTRACTVALUE ( META_DATA, '/lot_info/apc_status_info' ) AS apc_status_info FROM t_dlis_log_history WHERE ( (EQP_ID = 'ALC4360') OR (EQP_ID = 'ALC4361') OR (EQP_ID = 'ALC1360') OR (EQP_ID = 'ALC1361') OR (EQP_ID = 'ALC1362') OR (EQP_ID = 'ALC1363') OR (EQP_ID = 'ALC1364') OR (EQP_ID = 'ALC1365') OR (EQP_ID = 'ALC355') OR (EQP_ID = 'ALC353') OR (EQP_ID = 'ALC4350') OR (EQP_ID = 'ALC354') ) AND (( log_time >= DATEADD ( HOUR, 6, CONVERT(VARCHAR (10), GETDATE (), 110) ) AND ( log_time <= DATEADD ( HOUR, 6, CONVERT(VARCHAR (10), GETDATE () + 1, 110) ) ) ) It is showing error missing expression ...

  Read the article

• sql query returns incorrect result

  - by reza saberi

  I have a mysql database that stores quotation documents with some products that are clearly defining the price of each product in them, and a table for contracts storing contract details as well as customer code and quotation code to which it belongs. I have the following query to see how much is the total price of the quotation to write it in the invoice: select sum(sqproducts.price * sqproducts.quantity) as 'total-price', squotations.currency as 'currency' from sqproducts, ccontracts, squotations where sqproducts.contracted=1 AND squotations.code=sqproducts.quotation_code AND sqproducts.quotation_code=ccontracts.squotation_code AND sqproducts.quotation_code='QUOT/2012/1' group by currency

  Read the article

• problem with intersect operation in a sql query

  - by Shadi

  I wrote the following query, I think it's correct but I have a "missing operator" error. SELECT * FROM results,Types WHERE results.a=Types.b INTERSECT SELECT * FROM results,Types WHERE results.c=Types.b Could somebody help me please? Thanks a lot.

  Read the article

• Android URLConnection GET query works WiFi but different response 3G

  - by kisplit

  Hey, I have some code which queries a web server using HTTP GET URLConnection connection = new URL("www.example.com" + "?blah=ok").openConnection(); connection.setRequestProperty("Accept-Charset", "UTF-8"); InputStream http_response = connection.getInputStream(); Now when I run this code while connected to WiFi I get the expected response but when I run this with WiFi disabled I instead seem to get the response of www.example.com without the appended query. Does anyone know why this is happening?

  Read the article

• Forming Xpath Query for total Google results

  - by user619879

  I've used this formula in Google Spreadsheets in the past to input the number of search results into a cell. The formula's not working anymore and I know I need to fix the xpath query. any ideas? Current formula: =importXML("http://www.google.com/search?num=100&q="&A2,"//p[@id='resultStats']/b[3]") Spreadsheet for public testing: https://spreadsheets8.google.com/ccc?key=tJzmFllp7Sk1lt23cXSVXFw&authkey=CM625OUO#gid=0

  Read the article

• Sql Select Query Question. Merge Rows

  - by Jono

  I have a single MYSQL Question and need help ASAP. Database: Email | Name | Tag [email protected] |Test Person | TagOne [email protected] |Test Person | Tag Two Need an SQL query that will return Email | Name | Tag [email protected] |Test Person | TagOne, Tag Two Any help?

  Read the article

• Explain this SQL query in plain English.

  - by Kevinniceguy

  Please explain, in plain English, what question this SQL query answers: SELECT SUM(price) FROM Room r, Hotel h WHERE r.hotelNo = h.hotelNo and hotelName = 'Paris Hilton' and roomNo NOT IN (SELECT roomNo FROM Booking b, Hotel h WHERE (dateFrom <= CURRENT_DATE AND dateTo >= CURRENT_DATE) AND b.hotelNo = h.hotelNo AND hotelName = 'Paris Hilton');

  Read the article

• Return value from query statement - jQuery

  - by dave

  Hello, I have a ajax, jquery form which works fine, but returning a message from <div></div>. I want to return a value from a db query, a single value. How do I go about doing it. Thanks Dave

  Read the article

• How to convert map to url query string?

  - by Ula Krukar

  Do you know of any utility class/library, that can convert Map into URL-friendly query string? Example: I have a map: - "param1"=12, - "param2"="cat" I want to get: param1=12&param2=cat. PS. I know I can easily write it myself, I am just surprised that I cannot find it anywhere (I checked Apache Commons so far).

  Read the article

• Querying two tables with one query

  - by vipul

  I want to get two separate tables by executing one query in MySQL. If you know how, please reply.

  Read the article

• Sql Query to list all views in an MS SQL Server 2005 database

  - by Matthias

  I need an sql query to enumerate all views (I only need the view names) of a specific database in MS SqlServer 2005. Thanks in advance!

  Read the article

• Query results with no reverse

  - by gruber

  Hi, Ive got table: UserA, UserB, numberOfConnections I would like to write query which returns me only rows that has no reverse I mean or example : for data : 1 2 10 1 3 10 1 5 10 1 6 10 2 6 10 2 5 10 5 1 10 5 2 10 3 1 10 it should return 1 2 10 1 3 10 1 5 10 1 6 10 2 6 10 2 5 10 rows: 5 1 10 5 2 10 3 1 10 arent valid because there are already corresponding 1 5 10 2 5 10 3 1 10 thanks for help bye

  Read the article

• How to update two tables in a single query in MS SQL

  - by Aditya Acharya

  Can it be possible to update two tables writing single query. So that i do not to execute two queries and to track whether both are successful.

  Read the article

< Previous Page | 304 305 306 307 308 309 310 311 312 313 314 315  | Next Page >