This year was very special for me as it was very intensive and interresting. Advantages: 4 times described in employees newsletter (for all the computer programms I participated in implementation or was main contributor) award at work for the last „Bussiness Intelligence” project and doing things, which are considered to be impossible 3 fullfilled privateWięcej o2019 – summary and plans for the next year[…]
https://www.mssqltips.com/
Znów, tak jak w zeszłym roku, biorę udział w konkursie na najlepszą krawcową z DYIMarket, bo zamarzył mi się Overlock do moich projektów. Zapraszam do głosowania na moje projekty: https://diymarket.pl/users/magdaka
SQL Server follows client server architecture. When ever user performs any action on client machine, it converts in the form of query. This query moves from client to server in the form of network packets using protocols for connection and communication between source and destination servers. SQL server is mainly divided into two Engines, RelationalWięcej oMSSQL Server architecture[…]
Creating a simple stored procedure We will create a simple stored procedure that joins two tables and returns the result set as shown in the following example. CREATE PROCEDURE GetProductDescASBEGINSET NOCOUNT ON SELECT P.ProductID,P.ProductName,PD.ProductDescription FROM Product PINNER JOIN ProductDescription PD ON P.ProductID=PD.ProductID END We can use ‘EXEC ProcedureName’ to execute stored procedures. Creating a stored procedure with parametersWięcej oMSSQL Server – stored procedures[…]
$objOTApp = New-Object -ComObject OTAut.OtApplication$objOTSession = $objOTApp.MakeSession($strServerName, $strServerPort, $strLoginName, $strPassWd)$objOTFolder = $objOTSession.GetRequestFolderByPath($strFolderName) Do { Start-Sleep -Seconds 2 Write-Host „Waiting for OT response…” $objImport = $objOTFolder.MakeImport() #$objImport } Until ($objImport.Datasource -eq „”) #$objOTFolder.ImportDefinitionsWrite-Host „Importing objects to Omnitracker”$objImport.Datasource = $strFileName$objImport.Run($ImportName)$objImport$objOTSession.Logoff()
’pokazuje wszystkie pola z danego katalogu oprocz inherited select ufd.id, pa.parent,ufd.area, pa.name asFolder, ufd.label, ufd.alias, ufd.run_time_field, otFieldTypes.field_type, case when ufd.[type] = 254 then 'ReferenceList’+ Convert(nvarchar(50), ufd.id) else” end as RefTable, case when ufd.[type] = 254 then 'ReferenceList’+ Convert(nvarchar(50), ufd.id) + ’.Request = '+ rtrim(pa.name) + ’ Object’ else” end as Description_Request, case when ufd.[type] =Więcej oOmnitracker – reports in different way[…]
Sometimes it is needed to set individual user permissions to chosen COM objects like (Excel). Here is short explanation what are these permissions and how to set them: Dcomcnfg.exe provides a user interface for modifying certain settings in the registry. By using Dcomcnfg.exe, you can enable security either on a computer-wide or a process-wide basis. … OrWięcej oWindows Server 2008 R2 – permissions for COM objects[…]
Ich habe letzten Samstag die Deutcher Film „Kleinen Germanen” angeschaut. Der Film ist fuer Deutche Woche Film Festival in Gdansk gekommen. Der Festival wurdest organisiert von Generalkonsulat der Bundesrepublik Deutschland in Wrocław. Während diese Festival da waren viele interressant Filme, inzwishen Film über „Toten Hosen” Musikband, Deutche Komödie „Goldfisch” und psychologisch Film ” Systemsprenger”. AlleWięcej o"Kleinen Germanen" – eine Filmkritik[…]