Tag Archives: SQL

• Microsoft SQL Server, Sybase Adaptive Server, and Oracle Compared

  Posted on June 24, 2010 by Dan in programming

  This is an excellent link comparing MS SQL and Oracle datatypes and other imoportant information.   http://download.oracle.com/docs/cd/E12151_01/doc.150/e12156/ss_oracle_compared.htm Share on Facebook Share on Linkedin Tweet about it Print for later Tell a friend

  Post Tagged with Coding, Microsoft SQL Server, Oracle, SQL, Sybase
  No Comments.
  Continue Reading...

• Using CFQUERYPARAM to create quotes on a list for an IN operator within SQL

  Posted on August 12, 2009 by Dan in programming

  I have found that when you are trying to use a string list variable in an IN operator of a SQL query, it can sometimes be difficult.  The IN operator requires a list to have single quotes around each list item, if they are strings, in order for the query to process correctly.  There are [...]

  Post Tagged with Coding, ColdFusion, Information, SQL
  No Comments.
  Continue Reading...

• Get an ID of record after a SQL insert using ColdFusion

  Posted on August 11, 2009 by Dan in programming

  When you want to get an ID field of a record that was just inserted, you have to use the code below in ColdFusion.  First you "SET NOCOUNT ON" and process your insert statement.  After the insert, use a select statement like the following "SELECT @@IDENTITY AS varname".  After this you can "SET NOCOUNT OFF".  [...]

  Post Tagged with Coding, ColdFusion, Information, SQL
  No Comments.
  Continue Reading...