Interested to Buy Any Domain ? << Click Here >> for more details...
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"
- 2 Answers
- 4193 Views
- I also Faced
- E-Mail Answers
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 a unique index?
Tell me what is difference between clustered and non clustered index?
How to create sub reports?
What is open database communication (odbc)?
How to Update from select query in sql server?
What is difference between inner join and join?
What are horizontal and vertical scaling?
How to modify existing triggers using "alter trigger"?
Tell me the phases a transaction has to undergo?
What is data block and how to define data block size?
How to create prepared statements using odbc_prepare()?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Where are SQL server users names and passwords are stored in sql server?
Write a query for primary key constraint with identity key word?
What authentication modes does sql server support?
