About 15,000 results
Open links in new tab
  1. MySQL :: inull () not working in mysql

    Jun 16, 2009 · select a.rid, a.reqresumeid, ( select stagetitle from hc_stage_status where stagetype=a.stagetype and value= a.stage ) as stagetitle ,isnull ( (case a.statustype when '0' …

  2. ISNULL function - MySQL

    Feb 28, 2008 · I have found isnull for MySQL, but it does not work exactly the same way. Any idea to convert that isnull from SQLServer to MySQL? This is how i use in MSSql:- fieldname = …

  3. MySQL :: [RESOLVED] Using IFNULL () on Date Field

    Feb 7, 2012 · Good afternoon! I'm trying to use the IFNULL operator on a date field so I can display a string if it's null. That sounds even more ridiculous now that I type it out. Is there a …

  4. MySQL :: default values for stored procedure parameters

    Jan 17, 2011 · Hello friends, I want to create a stored procedure where default values i.e. NULL ,then depending on it the further operations will perform. here is the sample code I wanted to …

  5. MySQL :: error when changing property of the user

    Aug 2, 2016 · Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle …

  6. MySQL :: Truncated incorrect INTEGER value

    Feb 2, 2018 · Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle …

  7. SQL VIEW referencing a linked server Incorrect syntax near '10.242'

    Jul 18, 2017 · SELECT site, acct AS Account, ISNULL (acct_unit1, '') AS [Unit Code 1], ISNULL (acct_unit3, '') AS [Unit Code 3], SUM (dom_amount) AS Amount, CAST (DATEPART (YYYY, …

  8. Cursor behavior in SQL Server vs Sybase - social.msdn.microsoft.com

    Apr 16, 2012 · Since cursors were added in SQL 6.0, and a lot of the new features in 6.0 also were introduced in Sybase 10, one can suspect that Microsoft got the enhancements from …

  9. No value given for one or more required parameters

    May 17, 2011 · The funny thing here, is that when I run this query at MS Query over the excel file everyting is just happiness, but, when I run my sql task I got this "usefull" message: "No value …

  10. Re: How to run MySQL Stored Procedure in Access VBA Solved

    Jan 23, 2012 · Problem was to update values in 3 tables, 1 project to n jobs to n lineitems. MySQL 5.5 Stored Procedure: USE `hdb`; DROP procedure IF EXISTS `updatelijobprojvalues`; …