PlItems

ID: 263
PlCodelang: SQLite
PlGroup: Datenbank
PlItemTitle: CTAS
Code: CREATE TABLE newDestinationTable AS SELECT * FROM oldSourceTable

ID: 264
PlCodelang: SQLite
PlGroup: Datenbank
PlItemTitle: Eine Menge B reduziert um Menge A
Code: -- Es soll die Menge an Datensätze ausgegeben reduziert um eine andere Menge (Rest) -- Die einzelnen Tabellen oder Subqueries müssen die gleichen Spalten im Statement haben SELECT FieldA ,FieldB ,FieldC FROM myTable1 EXCEPT SELECT FieldA ,FieldB ,FieldC FROM myTable2

ID: 265
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: Eine Menge B reduziert um Menge A
Code: -- Es soll die Menge an Datensätze ausgegeben reduziert um eine andere Menge (Rest) -- Die einzelnen Tabellen oder Subqueries müssen die gleichen Spalten im Statement haben SELECT FieldA ,FieldB ,FieldC FROM myTable1 EXCEPT SELECT FieldA ,FieldB ,FieldC FROM myTable2

ID: 266
PlCodelang: MS Access VBA
PlGroup: Array
PlItemTitle: Dictionary Basics
Code: ' empty dict Dim myDict As Dictionary Set myDict = New Dictionary ' some static values myDict.Add "key1", "value1" myDict.Add "key2", "valueY" myDict.Add "keyX", "value98" ' update a key programmatically myDict.Remove "key1" myDict.Add "key1", "new value" ' iterate Dim strKey As Variant Dim current_key As String Dim strValue As String For Each strKey In myDict.Keys() current_key = strKey strValue = myDict.Keys(strKey) Next ' Exists If myDict.Exists(strKey) Then Debug.Print "yes" End If ' get an specific item Dim subdict As String subdict = myDict.Keys("key2") # valueY

ID: 267
PlCodelang: PowerShell
PlGroup: Array
PlItemTitle: Dictionary Basics
Code: # empty Hashtable $myDict = @{} # some static values $myDict.Add("key1", "value1") $myDict.Add("key2", "valueY") $myDict.Add("keyX", "value98") # update a key programmatically $myDict.Remove("key1") $myDict.Add("key1", "new value") # iterate Foreach ($key in $myDict.keys) { $strKey = $key $strValue = $Parameter[$key] } # Exists If ($myDict.ContainsKey("key1") -eq $true) { write-host "yes" } # get an specific item $subdict = $myDict("key2") # valueY

ID: 268
PlCodelang: T-SQL
PlGroup: Encoding / Decoding
PlItemTitle: Checksumme
Link Technical Documentation: https://docs.microsoft.com/en-US/sql/t-sql/functions/checksum-transact-sql?view=sql-server-2016
Code: SELECT [CHECKSUM_1] = CHECKSUM(Column1, Column2) FROM TableA
Result Example:

123456

ID: 269
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: UPDATE SQL mit JOIN
Code: UPDATE TableToBeUpdated SET myField1 = 'Update this field' FROM ( SELECT * FROM JoinedTable WHERE cond1 = 1 ) J WHERE J.ID = TableToBeUpdated.ID ;

ID: 270
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: UPDATE SQL mit JOIN
Code: UPDATE UPD_TABLE SET UPD_TABLE.myField1 = 'Update this field' FROM TableToBeUpdated UPD_TABLE LEFT JOIN ( SELECT * FROM JoinedTable WHERE cond1 = 1 ) J WHERE J.ID = UPD_TABLE.ID ;

ID: 271
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: UPDATE SQL mit JOIN
Code: UPDATE TableToBeUpdated UPD_TABLE INNER JOIN JoinedTable J ON J.id = UPD_TABLE.id SET UPD_TABLE.myField1 = 'Update this field' ;

ID: 272
PlCodelang: MS Access SQL
PlGroup: Datenbank
PlItemTitle: NULL Wert eines Feldes übersteuern
Link Technical Documentation: https://www.techonthenet.com/access/functions/advanced/nz.php
Code: SELECT FieldA ,Nz([FieldB,"This field is null") As FieldB_Nz FROM TableA
Result Example:

FieldA | FieldB_Nz ContentA | This field is null

ID: 273
PlCodelang: T-SQL
PlGroup: Strings
PlItemTitle: Leerzeichen vor/hinter String entfernen
Code: SELECT LTRIM(RTRIM(' x text x '))
Result Example:

x text x

ID: 274
PlCodelang: Python
PlGroup: Strings
PlItemTitle: Leerzeichen vor/hinter String entfernen
Code: myText = " x text x \r\n" print myText.strip()
Result Example:

x text x

ID: 275
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: Stored Procedure anlegen/löschen
Code: CREATE OR REPLACE FUNCTION increment(i INT) RETURNS void AS $$ BEGIN INSERT INTO accounts (id,name, balance) VALUES (i, 'Test', 1200); END; $$ LANGUAGE plpgsql; DROP FUNCTION increment(i INT);
Result Example:

CREATE FUNCTION DROP FUNCTION

ID: 276
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: Stored Procedure anlegen/löschen
Code: CREATE PROCEDURE increment(@i INT) AS BEGIN INSERT INTO accounts (id,name, balance) VALUES (i, 'Test', 1200); END;

ID: 277
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: Datenbankobjekte Kommentar
Link Technical Documentation: https://www.postgresql.org/docs/9.1/sql-comment.html
Code: COMMENT ON FUNCTION increment(i INT) IS 'This is a comment';

ID: 278
PlCodelang: PowerShell
PlGroup: Filehandling
PlItemTitle: Prüfen ob Verzeichnis existiert
Link Credits: https://www.powershelladmin.com/wiki/Powershell_check_if_folder_exists
Code: $myFolder = "C:\TEMP" if ((Test-Path $myFolder) -eq $true) { write-host "Folder exists!" } else { write-host "Folder doesn't exist!" }

ID: 279
PlCodelang: T-SQL
PlGroup: Datum, Zeit
PlItemTitle: Gestriges Datum
Code: SELECT GetDate() SELECT DATEADD(d, -1, GetDate()) SELECT GetDate()-1
Result Example:

2012-01-17 08:15:45 2012-01-16 08:15:45 2012-01-16 08:15:45

ID: 280
PlCodelang: Python
PlGroup: Filehandling
PlItemTitle: Prüfen ob Verzeichnis existiert
Code: import os.path from os import path myFolder = "/tmp/test" if path.exists(myFolder) & path.isdir(myFolder): print "Folder exists!" else: print "Folder doesn't exist!"

ID: 281
PlCodelang: Python
PlGroup: Filehandling
PlItemTitle: Verzeichnis erstellen
Code: import os myFolder = "/tmp/test" try: os.mkdir(myFolder) except OSError: print ("Error creating directory: %s" % myFolder) else: print ("Directory created: %s " % myFolder)

ID: 282
PlCodelang: PowerShell
PlGroup: Datum, Zeit
PlItemTitle: Gestriges Datum
Link Credits: https://social.technet.microsoft.com/Forums/en-US/1ff6097b-0d6d-458c-bbef-529fa4e35238/powershell-format-a-date-after-using-adddays?forum=ITCG
Code: $d=(Get-Date).AddDays(-1) $output=Get-Date $d -format "yyyy-MM-dd" # 2014-02-27
Result Example:

2014-02-27