SQL statements are used by Access, ADO, Oracle, Informix, and not suprisingly, MS SQL server. In short, if you use databases, be it in VB, ASP, FoxPro, Access or anything else, at some stage you will need to know SQL. SQL, or Structured Query Language gives you complete control over databases, creat
Community
Web services body adds 50 members
By Wylie Wong – The Web Services Interoperability Organization (WS-I) said Thursday that it has gained 50 new members, bringing its total membership to more than 100 companies. The organization's stated goal is to promote Web services and ensure that software from various technology makers is co
Hot and Fresh Technology for the Enterprise
by Antoine Quint – In my first article here five months ago I discussed where we were then with SVG. I focused on the application area I was most familiar with, end-user graphics. The situation since then has evolved as the community is still awaiting an SVG-enabled animation authoring tool from a m
XML Industry Analyst Firm ZapThink Establishes Web Services Practice Area
ZapThink announces the establishment of a new Web Services Practice Area, dedicated to providing focused research, analysis, and insight on emerging Web Services technologies that will have a high impact on the way businesses will be run in the future. The analyst group, known for its high quality r
The toughest SQL Server and Oracle questions answered
By Tim DiChiara – A few weeks ago, I called upon you loyal SearchDatabase readers to submit your toughest questions to stump our site experts. We received over a hundred questions — I knew the modern DBMS was complex, but wow! The experts’ responses ranged from a confident “None of them really pose
‘Yukon’ to Add Run-Time, XML Support
By Peter Galli and Matt Hicks – Microsoft Corp. is bringing its next SQL Server release, code-named Yukon, in line with its .Net and Web services vision, with new data unification and integration technology. Microsoft plans to embed .Net CLR (Common Language Runtime) in the SQL engine, as wel
Converting Access Data into XML
The following applications can help you convert Access data into XML format: Access 2002, ADO 2.5, and SQLXML. Access 2002 (part of Microsoft Office XP) enables you to query or save a table in XML format. You might be able to automate this process. ADO 2.5 and later enables you to open the data into
SQL Server CE 1.1 SP1 Updated
Microsoft has updated Microsoft SQL Server 2000 Windows® CE Edition (SQL Server CE) version 1.1 Service Pack 1 (SP1) to include support for Windows CE .NET devices. SQL Server CE 1.0 users must upgrade to SQL Server CE 1.1 before applying this service pack. Read SQL Server CE 1.1 SP1 Readme.txt Addi
Dynamic time sequence query
By Dusan Djuric – Suppose you need to see a full (10 minutes, half-hour, one hour, etc) time map for a given date with user_objects changes counter. And you need to do this in one SELECT statement, with no additional tables, views, packages, procedures, or functions. Is it possible? Yes, it is! Here
Selective Joining of Tables
by Navin Kumar – Assume there are three tables of interest: T1, T2 and T3. Depending on the value of a local variable VAR, you want to join two tables out of the three. The requirement is: If value of VAR is ‘X’ then join T1 and T2; otherwise, join T1 and T3. The value of VAR is determined at […]