There is table like Events...in that name ,startdate
,enddate,location are the column names
write a stored Procedure for this table to get events by
Months "GetEventsByMonths"
Answer Posted / krishna mohan thamisetty
select datename(mm, startdate) startdate, datename(mm,
enddate) enddate, location from t1
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is for xml in sql server?
What is a trigger and its types?
What is meant by Active-Passive and Active-Active clustering setup?
What are the basic features of a trigger in ms sql server?
What is the purpose of forms?
What are the types of subquery?
What is the difference between count () and rowcount ()?
What is the maximum size per database for sql server express?
Explain the disadvantages of cursors?
What are the advantages of using third-party tools?
Define candidate key, alternate key, and composite key.
How to name query output columns in ms sql server?
What is exporting and importing utility?
What are out-of-range errors with date and time literals?
What is compression - row-level and page-level compression?