Kayıtlar

Kasım, 2019 tarihine ait yayınlar gösteriliyor

SQL Date Function

Resim
SQL Date Function SELECT CURRENT_TIMESTAMP AS Result   -- Result -- 2019-11-23 00:27:26.280 SELECT DATEADD(day,2,'2019-11-25') AS Result   -- Resutl -- 2019-11-27 00:00:00.000 SELECT DATEADD(month,2,'2019-07-01') AS Result   -- Resutl -- 2019-11-27 00:00:00.000 SELECT DATEDIFF(day,'2018-01-01','2019-01-01') AS Result   -- Resutl -- 365 SELECT DATENAME(month, '2019-07-01') AS Result   -- Resutl -- July SELECT DATENAME(weekday, '2019-07-01')AS Result   -- Resutl -- Monday SELECT DATEPART(month, '2019-07-01')AS Result   -- Resutl -- 7 SELECT GETDATE()  AS Result   -- Resutl -- 2019-11-23 00:38:31.423 SELECT GETUTCDATE() AS Result   -- Resutl -- 2019-11-22 21:38:44.460 SELECT ISDATE('2019-07-01') AS Result   -- Resutl -- 1 SELECT ISDATE('2014-18-09') AS Result   -- Resutl -- 0  ...

Robocopy

Resim
robocopy [ [ ...]] [ ] Klasör altındaki dosyaları Silme:   del D:\Artifacts\*.* /s /f /q Get-ChildItem 'D:\Artifacts' -include *.* -Recurse |Remove-Item -Force Remove-Item –path D:\Artifacts -include *. * –recurse IIS RESET invoke-command -computername $[ServerName] -scriptblock {iisreset /RESTART} Release Deployment robocopy \\pcname\bin3 \\000.00.0.00\E$\Webservices\Integration.EDistraint\bin\ /S /E /COPY:DAT /MT:10 /R:0 /W:3 /XF robocopy \\pcname2\bin3 \\000.00.0.00\E$\Webservices\ervice.EDistraint\bin\ /S /E /COPY:DAT /MT:10 /R:0 /W:3 /XF \\000.00.0.00\E$\Webservices\Integration.Mobile\ /S /E /COPY:DAT /MT:10 /R:0 /W:3 /XF Copy from: \\files\files\WebSite Copy to: \\sreversite\Sites\WebSite\files\email robocopy \\files\files\WebSite \\site\c$\Sites\WebSite\files\emailing /E /w:5 /XF *.config robocopy H:\Users\xxxxxx\folder\folder C:\Users\xxxxx\folder\Target /E /w:5 /XF *.config *.pdf CefSharp*.dll /XD