How to get month name from date in SQL Server

-

 

There are two function available in MS-SQL Server.


1) DATENAME

              We can use DATENAME() function to get Month Name from Date in MS-SQL Server.

Syntax

               




                     

2)FORMAT

              We can use FORMAT() function to get Month Name from Date in MS-SQL Server.

Syntax














             

Popular posts from this blog

How to Reset Terminal license on Windows 2008, 2008 R2 and 2012

-
The RD Licensing grace period has expired and the service has not registered with a license server with installed licenses. A RD Licensing server is required for continuous operation. A Remote Desktop Session Host server can operate without a license server for 120 days after initial start up. The official solution is to Activate the RDS/TS CAL License server and point the Server to License server with User/Device License and will be resolve the problem, but if you want to reset the timer and again avail the 120 days grace time here is the solution: Solution: 1) First open the registry editor with "regedit" command in command prompt. 2)open the registry key from below path HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Terminal Server \ RCM \ GracePeriod 3)From GracePeriod delete the key " REG_BINARY".don't delete default registry. 4)then Restart the computer and check the grace period with "tlsbln" command from command ...
Read more

Display a fixed number of rows per page for an SSRS report

-
Image
  Follow these steps to display a fixed number of records per page First create Query and create dataset then insert table and add details in table. Add a  Parent Group  to the existing top level row group. The recently                  created Tablix doesn’t have a row group, so right click on  Details  (under Row Groups section), click on  “Add Group”  and then  Parent Group . You can refer to the below image. Once you click on Parent Group, it will open a Tablix Group. In the Group By expression, enter   =CEILING(RowNumber(Nothing)/25)   where 25 is the number of records to be displayed per page. If you want to display 50 records then choose 50. In the expression I have used the Ceiling function (which returns the smallest integer greater than, or equal to, the specified numeric expression) and the RowNumber function (which performs a running count of rows within a specified scope). The “No...
Read more