Welcome to Programmers Language v2

ID: 273
PlCodelang: T-SQL
PlGroup: Strings
PlItemTitle: Leerzeichen vor/hinter String entfernen
Code: SELECT LTRIM(RTRIM(' 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()

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);

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
Code: COMMENT ON FUNCTION increment(i INT) IS 'This is a comment';

ID: 278
PlCodelang: PowerShell
PlGroup: Filehandling
PlItemTitle: Prüfen ob Verzeichnis existiert
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

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
Code: $d=(Get-Date).AddDays(-1) $output=Get-Date $d -format "yyyy-MM-dd" # 2014-02-27