The Microsoft Future Pro Photographers Photography Contest is the most lucrative contest of its kind and provides a unique opportunity for college and university student photographers from around the world to showcase their artistic talent and photographic style.

Microsoft is committed to carrying the art of digital photography forward by encouraging new and emerging talent at the student level to learn, utilize, and implement state-of-the-art equipment, software, and techniques to produce the finest images possible.
http://prophoto.microsoft.avitivacorp.com/Site.aspx

You can view some great galleries as well as download fantastic new tools.
http://www.microsoft.com/prophoto/default.aspx

SQL Server 2008 introduces MERGE, a new keyword which performs INSERT, UPDATE and DELETE operations at one go. With SQL Server 2008, you can perform the above operation as simple as the following code.

CREATE PROC dbo.usp_MergeSQL
(
     @pID INT OUTPUT,
     @pName VARCHAR(80)
)
AS
BEGIN
     SET NOCOUNT ON;
     MERGE dbo.Table1 t
     USING (SELECT @pName
            ) p(Name)
     ON t.Name = @pName
 
     WHEN NOT MATCHED THEN
     INSERT (Name)
     VALUES (@pName)
 
     WHEN MATCHED THEN
     UPDATE SET @pID = ID;
 
     SET @pID = COALESCE(SCOPE_IDENTITY(),@pID);
 
END
RETURN
 

For the keen photographers out there,

Have you heard of Shutterstock? It is an exciting program that can turn your photos into cash!
ShutterStock will sell your photos and pay you for each one that's downloaded!

Sign up for free at http://submit.shutterstock.com and start to make $$$ from your photos!

Submit Photos to ShutterStock and make $$$!

Check out My Gallery Here

Download unlimited stock photos!