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
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What is the difference between Normalization and De-normalization?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What is advantage data architect?
How to modify the underlying query of an existing view?
Can you move the resources after pausing the node? : sql server database administration
What is difference between rownum and row_number?
how to avoid cursors? : Sql server database administration
What is the difference between seek predicate and predicate?
What are the advantages of having an index on the sql server?
What is delete query?
What is co-related sub query?
How to rebuild master databse?
How to get a list of columns using the "sys.columns" view in ms sql server?
What is user-defined scalar function?