.Net Basic

This blogs gives introduction to C#.NET programming for beginners. This blogs assumes that you have no programming experience whatsoever. It's a lot easier than you think, and can be a very rewarding hobby!after Refer this blog

12 May 2010

Like operator for date in sqlserver

create PROCEDURE sp_Delete_RehabilitationDtls
(
@EmpId VARCHAR(50), @RehabDt datetime
)
AS
declare @Dtdate varchar(50)
select @Dtdate=replace((convert(varchar, @RehabDt,107) +'%'),',','')
delete
FROM Pro_Emp_Rehabilitation_Dts where Emp_Id=@EmpId and RehabilitationDate like @Dtdate

Labels: