Database

SELECT t.Name <br />
FROM MyTable AS t <br />
WHERE DATEPART(week,t.Date_of_Birth)=DATEPART(week,GETDATE())

SELECT t.Name <br />
FROM MyTable AS t <br />
WHERE t.Date_of_Birth between GETDATE() AND DATEADD(d, 7, GETDATE()) 

<br />
SELECT t.myName, cast(cast(Month(getdate()) as varchar(2)) + '/' + cast(Day(getdate())as varchar(2)) + '/' + cast(Year(getdate())as varchar(4)) as datetime), <br />
cast(cast(Month(t.DOB)as varchar(2)) + '/' + cast(Day(t.DOB)as varchar(2)) + '/' + cast(Year(getdate())as varchar(4)) as datetime)<br />
FROM DOB AS t <br />
WHERE datediff(d, <br />
cast(cast(Month(getdate()) as varchar(2)) + '/' + cast(Day(getdate())as varchar(2)) + '/' + cast(Year(getdate())as varchar(4)) as datetime), <br />
cast(cast(Month(t.DOB)as varchar(2)) + '/' + cast(Day(t.DOB)as varchar(2)) + '/' + cast(Year(getdate())as varchar(4)) as datetime)) Between 0 and 6 <br />
<br />

<br />
DECLARE @now AS datetime<br />
SET @now = GETDATE()<br />
DECLARE @today AS datetime<br />
SET @today = CAST(CONVERT(char(8), @now, 112) AS datetime)<br />
SELECT t.Name <br />
FROM MyTable AS t <br />
WHERE DATEDIFF(Day,@today,t.Date_of_Birth) BETWEEN 0 AND 6<br />

CREATE PROCEDURE locSP_OpenBlob( @idsd_file uniqueidentifier )
AS
begin

SELECT

	sd_file.data

	from  sd_file 
	WHERE sd_file.idsd_file	= @idsd_file

end

GO

MemoryStream st = new MemoryStream();
BinaryWriter bw = new BinaryWriter( st,System.Text.Encoding.Default );
while(( retval  = datareader.GetBytes(0, len, outbyte, 0, bufferSize )) > 0 )
{
    bw.Write( outbyte );
    bw.Flush();
    len += retval;
}