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
Karan Thakkar
1.5k
204
89.5k
how to create paramterised sql function?
Jan 28 2019 6:29 AM
I have one table, in that i have many column name.
but in function there is use of only three column
I want to calculate and insert data in column NO_OF_MONTHS from START_DT to todays date. and there is one more column end date
function should have paramter @start_dt and end_dt
suppose start date is 1-1-2018 and end_dt is 1-1-2020
the function should insert 12 in column NO_OF_MONTHS because its 12 months passed from 1-1-2018.
I hope you guys understand my question.
Thanks waiting for reply.
Reply
Answers (
2
)
Update data from one table to another table?
how to updated data from one table to anohter