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 cte (common table expression)?
What is indexed view? How to create it?
What is the purpose of sql profiler in sql server?
How can change procedure in sql server?
Difference between aggregate functions of sql?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What is the difference between the 2 operating modes of database mirroring?
What does this statement do @@rowcount?
What are different types of subquery?
What is index fragmentation in ms sql server?
what is denormalization? : Sql server database administration
What is a view in sql?
What is an index. What are the types?