Category / Development / MS SQL
-
![]()
SQL query for today’s date minus year, month, day or minute
To add or subtract some date/time you can use MS SQL function: DATEADD(datepart, number, date) Let's say you need to add five months to current date, use this: SELECT * FROM YourTable… -
![]()
How to select first row in each group ordered by some columns
I'm just gonna show you an example how to select first row in each group of logins ordered by IsActive and Created columns, hope you will realise how it works. For example… -
Adding Resharper Code Quality Analysis to TFS/VSTS
To improve code qulaity of your project is't good to check every build with some analyzing tool such as Resharper Code Quality Analysis. Install Resharper Code Quality Analysis Now you have to… -
Add event log source in Windows
Run powershell as Administrator and run following command: New-EventLog -Source "TestApi" -LogName "Application" -
![]()
Setup WebClient timeout in PowerShell
If you want to setup timeout value for downloadString method of WebClient Class in PowerShell, you need to extend WebClient Class, because property Timeout isn't public. So, in the next example I inherited… -
![]()
Windows App Certification Kit doesn’t work in Windows Server 2016
I develop Universal Windows Programs and found an interesting problem. You can't use UI version of Windows App Certification Kit when your OS is Windows Server 2016. When I tried to test my… -
![]()
Start of month from date in MS SQL (opposite to EOMONTH function)
Sometimes we need to select values grouped by month from MS SQL Table. Probably the easiest way to do it is to call function DateAdd with DateDiff: SELECT Sum(YourColumn), DATEADD(month, DATEDIFF(month, 0, [YourDateColumn]), 0)…
Loading posts...
