Search Results

Search found 29814 results on 1193 pages for 'sql datetime'.

Page 558/1193 | < Previous Page | 554 555 556 557 558 559 560 561 562 563 564 565  | Next Page >

• Why does MySQL refuse pipe ('|') character in string on INSERT INTO

  - by Manuel Darveau

  If I try this statement: INSERT INTO TerminalEventChild (id,stringValue) VALUES (64,'version123|'); MySQL fail with : Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''version123' at line 1 SQLState: 42000 ErrorCode: 1064 If I remove the | character, everything works fine. Any idea?

  Read the article

• how to generate primary key values while inserting data into table through pl/sql stored procedure

  - by thulasi policherla

  hi friends, I am trying to insert data into particular table through pl/sql stored procedure,my requirement is while inserting i should generate PRIMARY KEY values for particular column and also i should return that PRIMARY KEY value to output and one more thing is that for another column i should validate my string such that it should contain only characters not integers. please help me in writing code for the above requirement Thanks and regards thulasi policherla

  Read the article

• What is the best approach using JDBC for parameterizing an IN clause?

  - by Uri

  Say that I have a query of the form SELECT * FROM MYTABLE WHERE MYCOL in (?) And I want to parameterize the arguments to in. Is there a straightforward way to do this in Java with JDBC, in a way that could work on multiple databases without modifying the SQL itself? The closest question I've found had to do with C#, I'm wondering if there is something different for Java/JDBC.

  Read the article

• Oracle multiset, collection and records

  - by Atul

  Can anybody Explain me why records are required. Can't we perform the same operation in pl/sql using loop and all. Also when multiset, records query can be used i.e. in which type of situation and which one will be the preference.

  Read the article

• Where can I get 64 bit OLEDB and/or ADO.Net drivers for Sybase ASE?

  - by Craig

  I'm new to Sybase and so far it's a monumental pain just to connect to it! Where in the world can I get 64 bit drivers for Sybase ASE 15 so that I can connect from my 64 bit SQL 2008? Our Sybase servers are 32 bit and there are no 64 bit drivers on the media :(

  Read the article

• PL/SQL ANONYMOUS BLOCK REQUIRED

  - by aryan

  I HAVE TO RETRIEVE ID AND LAST_NAME FROM MY TABLE BUT THE THING IS THAT MY ID IS NOT CONTINUOUS AND THERE NO PATTERN FOR THE GAPS. NOW I WANT TO WRITE A PL/SQL ANONYMOUS BLOCK FOR THIS.

  Read the article

• How to calculate

  - by Bob

  Hi, I hv a table like this :- Item Qty Price A Price B abc 5 36.00 0 qwe 8 0 48.00 zxc 6 12.00 0 poi 4 10.00 0 lkj 9 12.00 0 mnb 3 0 14.00 vfr 7 0 6.00 How can I sum the value using SQL ie. if Price A is zero, it will pick Price B. The expected results will be as follows :- Item Value abc 180.00 qwe 384.00 zxc 72.00 poi 40.00 lkj 36.00 mnb 42.00 vfr 42.00

  Read the article

• ms-access: displaying column as "something else"

  - by every_answer_gets_a_point

  i have the following access sql statement: SELECT * FROM (SELECT [Occurrence Number], [Occurrence Date], [1 0 Preanalytical (Before Testing)], [Cup Type], NULL as '2 0 Analytical (Testing Phase)', [2 0 Area], NULL,NULL FROM [Lab Occurrence Form] WHERE NOT ([1 0 Preanalytical (Before Testing)] IS NULL) in this: NULL as '2 0 Analytical (Testing Phase)' when it displays the column it shows the single quote. if i remove the quote completely it gives me an error, if i use double quotes it shows me the double quotes in the resulting table is it possible to not have it show any quotes?

  Read the article

• Adding to the schema of a subscribing database.

  - by NTDLS

  Transactional Replication on SQL Server 2005 Enterprise x64 (SP3). I need to add check constraints to a databases that is the target for a replication, but I cannot add the check constraints to the publishing database. The Problem is that the replication process keeps removing my constraints. How do I prevent this?

  Read the article

• Corrupt Database

  - by user250545

  I am Looking For Best Way or Software To Recover Corrupt Database in SQL 2000/2005/2008 . looking for Ur help .......................................

  Read the article

• Transforming OLTP Relational Database to Data Warehousing Model

  - by Russ Cam

  What are the common design approaches taken in loading data from a typical Entity-Relationship OLTP database model into a Kimball star schema Data Warehouse/Marts model? Do you use a staging area to perform the transformation and then load into the warehouse? How do you link data between the warehouse and the OLTP database? Where/How do you manage the transformation process - in the database as sprocs, dts/ssis packages, or SQL from application code?

  Read the article

• multiple search fields

  - by user234194

  What will be the best approach if I have search fields for 20 or more and any combination should be valid. Is there any special way to do it in openJPA or native SQL is better. Any idea would be helpful.Thanks.

  Read the article

• multiple search fields

  - by user234194

  What will be the best approach if I have search fields for 20 or more and any combination should be valid. Is there any special way to do it in openJPA or native SQL is better. Any idea would be helpful.Thanks.

  Read the article

• MySQL join problem

  - by snaken

  Whats wrong with this SQL? It should return results but returns nothing SELECT `pid` FROM `products` LEFT JOIN `prods_to_features` ON (`ptf_pid` = `pid`) WHERE (`ptf_id` = '66' OR `ptf_id` = '67') AND (`ptf_id` = '76') Is it not possible to have the 2nd where clause for the table that has been used in the left join?

  Read the article

• MYSQL Select statment Order By with Group By

  - by mouthpiec

  I have the following simple SQL statment SELECT id, name, value_name, value_id FROM table GROUP BY id ORDER BY value_id DESC when grouping I would like to get the value_name and value_id of the tuple where the value_id is the biggest. The way it is i am getting the smallest value. For example 1, name1, valuename, 3 (where i know that there is a value_id of 5) Can you please help?

  Read the article

• PHPpgAdmin: How delete rows without using SQL

  - by xRobot

  In PHPmyAdmin I can delete rows without using SQL. Is there a way to do this in PHPpgAdmin ?

  Read the article

• how to specify literal value in linq union

  - by lowlyintern

  I have the following SQL query, note I want the literal value '0' in the second field in the second SELECT statement from the ItemSale table. How do I express this in LINQ? I get the error message 'Invalid anonymous type member declarator'. SELECT BranchNumber,QuantitySold FROM Department UNION SELECT BranchNumber,0 FROM ItemSale How to express the '0' in LINQ? var unionQuery = (from dept in Department select new { dept.BranchNumber, dept.QuantitySold, }) .Concat(from item in ItemSale select new { item.BranchNumber, 0 });

  Read the article

• Convert SQL Server Varbinary field to MYSQL, keeping data intact

  - by Mike Sheridan

  I was given the daunting task of converting a ASP website to PHP and SQL Server to MySQL, and I ran into an issue that hopefully somebody can help I have a user table which has a password field with datatype Varbinary(128), are using pwdencrypt to encrypt the password. Is there a way to transfer that over to MySQL, and somehow i need to be able to keep the password intact... how can i go about that? any pointers would be greatly appreciated!

  Read the article

• Update is not updating the whole string

  - by Malik

  Following is my SQL fiddle: http://sqlfiddle.com/#!2/f9bae/1 In which i am trying to check if the whole name is being verified by lookup table or not and if there is any error then it should get replaced by the correct value but the problem i am facing is that if any name contains more than one wrong values then query only update one part of that name and leave the rest unchanged , kindly let me know how can i modify my query for update so it'll update the whole name as per lookup table correct values. Thanks,

  Read the article

• SQL-wrappers (activerecord) to recommened for python?

  - by Horace Ho

  is there an activerecord (any similar SQL-wrapper) for python? which is good for: used in a server-side python script light-weight supports MySQL what I need to do: insert (filename, file size, file md5, the file itself) into (string, int, string, BLOB) columns if the same file (checksum + filename) does not exist in db thx

  Read the article

• How to show 0 when no row found

  - by user1685991

  I have a SQL query in which I am passing sysdate to the query problem is that when there is no matching date in table with sysdate then it don't shows the zero even if there is nvl applied here is my query select * from molasses where trunc(trn_dte) = trunc(sysdate) But it show data only when current date is present in table but I want to show zero if no data found in table.please help me to do this in oracle 10 g. Because some times the situation is like above and I have to display zero when no data found

  Read the article

• How to get array using Oracle sql query

  - by Yashwant Chavan

  I want to display Years between From date - To date using oracle SQL on dual table e.g. if pass - From date as 1/1/1900 and To Date as 1/1/2000 then it shoold display 1900 1901 - till 2000

  Read the article

• Can any body help me for the syntax of select query??

  - by Azka

  i`m doing string sql = "select * from publisher where title like "'"+tbproperty.text+"; but it`s not working! regards..

  Read the article

• Sql Server Management Studio Object Explorer dissapeared - missing - vanished

  - by Felbus

  ok, my Sql Server Management Studio Object Explorer had dissapeared. I know the shortcut F8, and the view-object explorer method.. neither do anything, ive clicked everything on the keyboard, googled around, but nothing.. really need this back, its a massive hassle having to navigate through the summary window without the object explorer tree view! help meeeee...

  Read the article

• order keywords by frequency in PHP mySql

  - by Gusepo

  Hello, I've got a database with video ids and N keywords for each video. I made a table with 1 video ID and 1 keyword ID in each row. What's the easiest way to order keywords by frequency? I mean to extract the number of times a keyword is used and order them. Is it possible to do that with sql or do I need to use php arrays? Thanks

  Read the article

< Previous Page | 554 555 556 557 558 559 560 561 562 563 564 565  | Next Page >