April 21, 2009

Using the EXISTS Command in SQL

Suppose you wanted to retrieve the department number (deptno) and name (dname) fields for employees in an emp table. One way to get the values is with this SQL query: SELECT distinct d.deptno,d.dnameFROM dept d,emp eWHERE d.deptno=e.deptno The preceding query takes four milliseconds to execute (on my machine). But if

SharePoint Applied: SharePoint 2007 with WCF and Silverlight

ilverlight 2 just went RTM. This product is unique because for the first time in the Microsoft world, you have .NET running cross platform, in a secure way, and without all the deployment hassles. It has the ability to bring rich UI, right to the browser?much like Flash, but with

New IDE Feature in VS 2008: Tracepoints

When editing in Visual Studio, you would normally write a MessageBox.Show or a Console.Writeline to log the value of a variable. But you can eliminate that work now. Instead, try taking advange of a new debugging feature in Visual Studio 2008 called “Tracepoints.” To use the feature, right-click on the

An Alternative Way to Lock Your Computer

Here’s an alternative way to lock your Windows computer. Right-click an empty spot on the desktop, and select New ? Shortcut. In the Create Shortcut dialog box, type or copy rundll32 user32.dll,LockWorkStation into the “Type the location of the item” field. Click Next. In the “Type a name for this