TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
vikas kanani
NA
149
114.7k
Store procedure for desktop application
Nov 8 2012 9:02 AM
ALTER procedure [dbo].[one_mnth_ago]
as
DECLARE @StartDate DATETIME, @EndDate DATETIME
SET @StartDate = dateadd(mm, 0, getdate())
SET @StartDate = dateadd(dd, datepart(dd, getdate())*0, @StartDate)
SET @EndDate = dateadd(mm, 1, @StartDate)
begin
SELECT *
FROM installation
WHERE warranty_expry_date BETWEEN @StartDate AND @EndDate
end
how to run this procedure in desktop application.and retrieve data in gridview
Reply
Answers (
2
)
Constructor in abstract class
No code execution before exit