Message in ASP.NET

Cursor in MsSQL

DECLARE @CItem NVARCHAR(10)
DECLARE db_cursor CURSOR FOR
select ColName from Table_Name
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @CItem
WHILE @@FETCH_STATUS = 0
BEGIN
--Write your SQL here.
FETCH NEXT FROM db_cursor INTO @CItem
END
CLOSE db_cursor
DEALLOCATE db_cursor

Get All Friday Date of a Year in MS SQL

--Exec [dbo].getFriday '2011'
Create procedure [dbo].getFriday(@pYear nvarchar(50))
AS
BEGIN
DECLARE @FirstDay datetime
declare @intFlag int
set @FirstDay='01 Jan '+@pYear
set @intFlag=2
if datepart(dw,@FirstDay)=6 --For friday=6,Sunday=1....
print 'Friday: '+@FirstDay
WHILE (@intFlag<=365)
BEGIN
set @FirstDay=DATEADD(dd,1,@FirstDay)
set @intFlag = @intFlag + 1
if datepart(dw,@FirstDay)=6
print 'Friday: '+@FirstDay
END
END