Get relationship between tables using foreign key relationships!
SELECT Referencing_Object_name, Referencing_Column_Name, Referenced_Object_Name, Referenced_Column_Name FROM
(SELECT Referenced_Column_Name = c.name, Referenced_Object_name = o.name, f.constid FROM sysforeignkeys f, sysobjects o, syscolumns c WHERE (f.rkeyid = o.id) AND c.id = o.id AND c.colid = f.rkey) r,
(SELECT referencing_column_Name = c.name, Referencing_Object_name = o.name, f.constid FROM sysforeignkeys f, sysobjects o, syscolumns c WHERE (f.fkeyid = o.id) AND c.id = o.id AND c.colid = f.fkey) f
WHERE r.Referenced_Column_Name = f.referencing_column_Name AND r.constid = f.constid
ORDER BY f.Referencing_Object_name
Apple Introduces Safari for Windows
June 11, 2007—Apple® today introduced Safari™ 3, the world’s fastest and easiest-to-use web browser for Windows PCs and Macs. Safari is the fastest browser running on Windows, based on the industry standard iBench tests, rendering web pages up to twice as fast as IE 7 and up to 1.6 times faster than Firefox 2. And it executes JavaScript up to 2.8 times faster than Internet Explorer 7 and up to 1.6 times faster than Firefox 2. Safari joins iTunes® in delivering Apple’s legendary user experience to both Windows and Mac® users as well as full support of open Internet standards. Safari 3 features easy-to-manage bookmarks, effortless browsing with easy-to-organize tabs and a built-in RSS reader to quickly scan the latest news and information. Safari 3 public beta is available today as a free download at www.apple.com/safari
Visual Studio 2008 Shell
If you create software development tools, you’ll want to consider building on the Visual Studio 2008 Shell. A streamlined Visual Studio development environment, the Visual Studio Shell provides the core foundation so you can focus on building your application’s unique features. Flexible customization options help you deliver optimized experiences for specific markets. Read the rest of this entry »
Adobe Integrated Runtime (AIR) code named Apollo
Adobe has released a free beta version of Adobe Integrated Runtime (AIR), marking a critical stage in its project to bring rich web applications to the desktop.
Formerly known by the Apollo codename, AIR is an application runtime that works across operating systems and lets developers use familiar tools such as HTML, Ajax and Adobe’s Flash and Flex to write applications. A full release is scheduled for the fourth quarter. Read the rest of this entry »
Aptana IDE
The Aptana IDE is a free, open-source, cross-platform, JavaScript-focused development environment for building Ajax applications. It features code assist on JavaScript, HTML, and CSS languages, FTP/SFTP support and a JavaScript debugger to troubleshoot your code. Read the rest of this entry »
Microsoft Research Pex
Pex (Program EXploration) is an intelligent assistant to the programmer. By automatically generating unit tests, it allows to find bugs early. In addition, it suggests to the programmer how to fix the bugs.
Pex enables a new development experience in Visual Studio Team System, taking test-driven development to the next level. Pex analyzes .NET applications. From a parameterized unit test, it automatically produces traditional unit tests cases with high code coverage. Moreover, when a generated test fails, Pex can often suggest a bug fix. Read the rest of this entry »
Microsoft Math
With Microsoft Math, students can learn to solve equations step-by-step, while gaining a better understanding of fundamental concepts in pre-algebra, algebra, trigonometry, physics, chemistry and calculus.
Microsoft Math provides a set of mathematical tools that helps students get school work done quickly and easily. With a full-featured graphing calculator that’s designed to work just like a handheld calculator, Microsoft Math offers a wide range of additional tools to help students with complex mathematics.
Top features in Microsoft Math include: Read the rest of this entry »
SQL Server 2008 (Formerly code name Katmai) June CTP available now
The most awaited CTP of SQL Server 2008 (Formerly code name Katmai) has been released on June04, 2007.
You can download it from http://connect.microsoft.com/sqlserver. You can also watch Ted Kummert talking about SQL Server 2008 here
Some of the key improvements in this CTP are: Read the rest of this entry »
Google Gears: Enabling Offline Web Applications
Google Gears is an open source browser extension that lets developers create web applications that can run offline. Read the rest of this entry »
Google Developer Day
Google Developer Day is here! Our first worldwide developer event has kicked off in Sydney and won’t stop until it’s reached 10 locations around the world, finishing up 29 hours later at Google’s offices in Mountain View, California. If you can’t make it in person, you should try to catch one of the sessions online. We’re webcasting live sessions from London and California, and will post videos from all our events shortly afterwards on the Developer Day website
