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:

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

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