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


Please Help Members By Posting Answers For Below Questions

What are the types of indexes?

600


What is policy management?

585


What are the disadvantages of indexes?

538


where the connection string store in the database

1532


Can we write a distributed query and get some data which is located on other server and oracle database?

769






What are the advantages of the mirroring?

575


Difference between primary key and clustered index?

506


What are the hotfixes and patches in sql server?

547


How do you know if sql server is running on your local system?

546


What is a dataset and what are the different types of datasets?

93


How are the exceptions handled in sql server programming?

611


What number sorts of privileges are accessible in sql?

600


How do I port a number to sql server?

508


Difference between drill down and drill through report.

547


What do you understand by coalesce in sql server?

501