wynalazkowo - eksperymenty małe i duże

MSSQL Server – stored procedures

MSSQL Server – stored procedures

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[…]

Omnitracker – import of data from Powershell

Omnitracker – import of data from Powershell

$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()

Omnitracker – reports in different way

Omnitracker – reports in different way

‚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[…]

Windows Server 2008 R2 – permissions for COM objects

Windows Server 2008 R2 – permissions for COM objects

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[…]

"Kleinen Germanen" – eine Filmkritik

"Kleinen Germanen" – eine Filmkritik

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[…]

Love, Death and Robots

Love, Death and Robots

Coś dla duszy teraz;) Ten serial oglądałam jakiś czas temu na Netflixie. Jest naprawdę godny polecenia, choć radzę go nie oglądać z dziećmi, co by nie zadawały zbyt wielu niewygodnych pytań;) Krótki opis z Wikipedii: https://en.wikipedia.org/wiki/Love,_Death_%26_Robots W moje opinii najlepiej nakręcony od dłuższego czasu serial animowany dla dorosłych z elementami komedii, zaskoczenia, s-f no iWięcej oLove, Death and Robots[…]

PostgreSQL – informacje o bazie

PostgreSQL – informacje o bazie

1. list of table indexes:SELECTtablename,indexname,indexdefFROMpg_indexesWHEREschemaname = ‚public’ \d table_name 2. DB & tables related \q: Quit/Exit \c __database__: Connect to a database \d __table__: Show table definition including triggers \d+ __table__: More detailed table definition including description and physical disk size \l: List databases \dy: List events \df: List functions \di: List indexes \dn: ListWięcej oPostgreSQL – informacje o bazie[…]

Oracle – errors

Oracle – errors

ORA-00001: unique constraint violated The ORA-00001 message is triggered when a unique constraint has been violated. Essentially the user causes the error when trying to execute an INSERT or UPDATE statement that has generated a duplicate value in a restricted field. The error can commonly be found when a program attempts to insert a duplicateWięcej oOracle – errors[…]