there is no such beast as DUAL in MS SQLServer. if what you want is the result of a function just leave off the from clause like so: select getdate()
-----Original Message----- Sent: Friday, September 20, 2002 8:43 AM To: Multiple recipients of list ORACLE-L Does anybody know what table is in MS SQL instead of Oracle DUAL? Thanks JP On Friday 20 September 2002 14:53, you wrote: > T is for trasnsactional SQL which is SQL Server and Sybase terminology. > > -----Original Message----- > Sent: Thursday, September 19, 2002 7:13 PM > To: Multiple recipients of list ORACLE-L > > > > Datawarehouse meta data. > > But what the heck is T SQL? > > > > > "Miller, Jay" > <JayMiller To: Multiple recipients of > list ORACLE-L <[EMAIL PROTECTED]> @TDWaterhouse cc: > .com> Subject: RE: Consulting > Position Available-Oracle DBA/Developer/NYC Sent by: root > > > 09/19/2002 > 02:08 PM > Please > respond to > ORACLE-L > > > > > > > But 4th normal form? Does anyone really use this? > > -----Original Message----- > Sent: Tuesday, September 17, 2002 3:35 PM > To: Multiple recipients of list ORACLE-L > > > well the market must be picking up some, been definitely more reqs > posted here a/o recent. > > joe > > Bill Christison wrote: > >Interested candidates reply to: [EMAIL PROTECTED] > >************************************************* > >Consulting Position Title: > >Oracle DBA/Developer > > > >Duties and Responsibilities: > > > >This position is a conversion to an Oracle Data warehouse. > >Excellent verbal skills are needed to obtain technical > >specification from the architect and users then to transform > >into written specifications. > > > >Experience Required: > >*Must have experience in PL SQL and T SQL > >*Must have 3rd and 4th form data normalization > >*Must have done business systems analysis > > > >Consulting Assignment Duration: 6 months to 12 months > > > >Assignment Location: New York City > > > >===== > >Bill Christison > >Knowlton Group, LLC > >845-258-5129 > >www.knowltongroup.com > > > >__________________________________________________ > >Do you Yahoo!? > >Yahoo! News - Today's headlines > >http://news.yahoo.com -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ ----------------------------- Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: STEVE OLLIG INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
