31 January 2008

Download 59 learning video of Silver Light from Silver.net site.

Create PROCEDURE usp_MoveSequence]

@ID int,

@Sequence int,

@MoveBy varChar(4)

AS

BEGIN—PROCEDURE

SET NOCOUNT ON;

DECLARE @compateTo INT

DECLARE @compateToMax INT

DECLARE @currentSequence INT

DECLARE @NextSequence INT

DECLARE @NextRecordID INT

IF @MoveBy='UP'

Select TOP 1 @NextSequence=Sequence, @NextRecordID=ID from TableName where sequence<@Sequence ORDER BY sequence DESC

ELSE IF @MoveBy='DOWN'

Select TOP 1 @NextSequence=Sequence, @NextRecordID=ID from TableName where sequence>@Sequence ORDER BY sequence

--ENDIF

IF @NextRecordID<>0

BEGIN

UPDATE TableName SET Sequence=@NextSequence WHERE ID=@ID

UPDATE TableName SET Sequence=@Sequence WHERE ID=@NextRecordID

END

END--PROCEDURE

13 January 2008

Do you want to show 1 rupees note of year 1949?

Click Here to find really very great information about currency of our country with image preview and it year.
Did you started to learn new features of Visual Studio 2008?

  • What's New in Microsoft Visual Studio 2008
  • Microsoft LINQ
  • Microsoft ASP.NET AJAX
  • Microsoft Silverlight.
Download eBook of this new version of Visual Studio from Microsoft learning center.

07 January 2008

Microsoft Office provides very good temples for Year 2008.

This templates are available in many formats like Word, Excel, Powerpoint, Once note, Visio

Download many attractive calenders form here.