Answer / Mohd Yameen

To find the first and last day of the current month in SQL Server, you can use EOMONTH function:nn```sqlnSELECT EOMONTH(GETDATE()) + 1 AS LastDayOfMonth,n EOMONTH(GETDATE()) + 1 - DATEPART(DAY, GETDATE()) AS FirstDayOfMonth;n```

Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,

---

does physical index sort data

1 Answers  

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

1 Answers  

---

When I run the sql server 2000 setup, it just hangs. What do I do?

1 Answers  

---

Why does sql studio use a single registered database repository? : sql server management studio

1 Answers  

---

Alternative way to DetDate() function?

5 Answers  

---

What is read uncmmited?

1 Answers  

---

How to use column default values in insert statements in ms sql server?

1 Answers  

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1 Answers  

---

How to use transact-sql statements to access the database engine?

1 Answers  

---

What are the tool windows in sql server management studio? : sql server management studio

1 Answers  

---

What is a scheduled job or what is a scheduled task?

0 Answers  

---