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
How to declare a cursor with "declare ... Cursor" in ms sql server?
Do you know what is difference between index seek vs. Index scan?
Define Joins?
how to determine the service pack currently installed on sql server? : Sql server database administration
How to find related tables in sql server?
Explain about system database?
Tell me when is the update_statistics command used?
What is the difference between varchar and nvarchar datatypes?
What is the difference between a check constraint and a rule?
What is database mirroring?
What are indexes in sql?
explain declarative management framework (dmf) in sql server 2008?
Explain primary key and foreign key constraints?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What are the difference between primary key and unique key? : sql server database administration