VIPUL IT

 Some times Numeric Keypad not working however num lock key is on. This problem arise because of mouse key on in Ease of Access Center. Here is the step of how to turn off mouse key in Ease of Access Center. Solution Go to Control Panel --> Ease of Access Center --> Make the keyboard easier to use where you find 'Turn Your Mouse Keys' check box under the title of 'Control the mouse with the keyboard'. please untick the check box and then click on apply and ok. Now check keypad will working.

 To Gate Data Order by Month Name You can Use the 'DATENAME' Function for extract Month Name from the Date Column and then use order by clause to sort the result by the month name. as per below example. Select column1, column2, DateName(MM, Date_Column) as MonthName  from Table1 order by month(Date_Column) In this example replace 'column1' and 'column2' with your actual column name and 'Date_Column' with actual column which has date value. Replace Table1 with actual Table. 'DateName'  function is use to extract Month Name from the date_column. Order By clause is use to sort the data ascending and descending order. In above example 'Month' function used for the sorting data by month name like January, February, March. 

  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              

  There are Two Method for Run Command With Admin Privileges. 1)Click on Start and type "CMD" in windows search where you find "Command Prompt" App. Right Click on "Command Prompt" and Select "Run As Administrator". Then Command Prompt Open with Admin Privileges where you can type command which run with Admin Privileges. 2)Press Win + R on Your Keyboard. In the Run Dialog box type your Command which you want to run with Admin Privileges then Press Ctrl + Shift + Enter and Programme run with Admin Privileges.