T-SQL is Transact SQL, (it originated from Sybase) Sybase (before they sold their technology to Microsoft to make "Microsoft SQL Server") also called their server "SQL Server"
After the sale, Sybase then changed it's name, so to not confuse anyone (potentially) MS-SQL (MSSQL) is of course "Microsoft SQL Server" and is named such (by others, i don't think Microsoft calls it that) Sybase is still "Sybase", but of course has the products ASE and ASA (Adaptive Server Enterprise and .. .. Anywhere) and T-SQL in Access .. I think not ;) > -----Original Message----- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Thursday, 3 April 2003 9:38 AM > To: CF-Talk > Subject: Re: Learned something today (Oracle) > > > Hey Joe...what's MS-SQL?? Access and SQL Server both use T-SQL or is > the"MS" throwing me? > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > --------------------------------------------------------- > Macromedia Associate Partner > www.macromedia.com > --------------------------------------------------------- > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > ----- Original Message ----- > From: "Joe Eugene" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, April 02, 2003 3:27 PM > Subject: RE: Learned something today (Oracle) > > > > > They must be single-quotes. (guess you weren't paying > attn in SQL 101 ;) > > > J/K of course. > > > > I dont think i mentioned Oracle or any DB for that matter :) > > Different DB's have variations in SQL.. T-SQL for MS-SQL , > PL-SQL for > Oracle > > etc. > > Access you can use double quotes... > > > > All String(char/varchar) fields in the query should > have single/double > > > > quotes. > > Perhaps you didnt read "single/double" :) > > > > > > Joe Eugene > > > > > > > -----Original Message----- > > > From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, April 02, 2003 6:15 PM > > > To: CF-Talk > > > Subject: RE: Learned something today (Oracle) > > > > > > > > > > > > > All String(char/varchar) fields in the query should > have single/double > > > > quotes. > > > > This is something you learn in SQL 101. > > > > > > > > > To clarify- in Oracle if you put double-quotes around a value that > you're > > > matching to a String field (char/varchar), it'll come back with an > error. > > > They must be single-quotes. (guess you weren't paying > attn in SQL 101 ;) > > > J/K of course. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
