Last post Oct 17, 2007 05:12 AM by James Evans
Sep 12, 2007 06:47 AM|iuliax|LINK
It is posible with Entreprise Library to use the SAME QUERY, by example,
"Select isnull(Val,33) from calculs where Col1 is not null" (specific for Sql Server)
to select data from Oracle too ? or the only way is to use specific stored procedures (queries)
wtitten in 2 ways : for Oracle and for Sql Server?
Sep 12, 2007 06:56 AM|mcp111|LINK
what is sgbd?
Sep 12, 2007 07:17 AM|iuliax|LINK
Sep 12, 2007 09:06 AM|mcp111|LINK
I'm not clear what enterprise library has to do with the sql syntax. I would think that would depend on the language - sql or pl/sql etc.
Oct 17, 2007 05:12 AM|James Evans|LINK
Dont both SQL Server and Oracle support ANSI standard SQL?
So - the isnull fucntion might have to be replaced and I'm not certain about
calculs but if you could write your query in ANSI standard SQL without platform specific extensions it should work for both.