Welcome to Programmers Language v2

ID: 153
PlCodelang: PL/pgSQL
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: SELECT now();

ID: 154
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: Erstellen und Befüllen Tabelle aus Query
Code: DROP TABLE myTable; CREATE TABLE myTable AS SELECT * FROM mySecondTable;

ID: 155
PlCodelang: Python
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: from datetime import date iso_datum = date.today().isoformat() output = iso_datum print output # 2013-12-05 # or import datetime datetime.datetime.now().strftime("%Y-%m-%d_%H-%M-%S") # 2013-12-05_18-09-10

ID: 156
PlCodelang: PL/pgSQL
PlGroup: Datum, Zeit
PlItemTitle: Monat aus Datum extrahieren
Code: -- You get the local name for the spoken month name SELECT to_char(now(), 'TMMonth') -- results in german to "Januar" or "Dezember" (= "January", "December")

ID: 157
PlCodelang: PL/pgSQL
PlGroup: Datum, Zeit
PlItemTitle: Erster und letzter Tag des Monats ermitteln
Code: select date_trunc('month', now()) -- first day in month select date_trunc('month', now()) + interval '1 month - 1 day' -- last day in month

ID: 158
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: Schema-Vergleich
Code: SELECT * FROM ( SELECT TABLES_P.TABLE_SCHEMA AS [SCHEMA_P] , TABLES_P.TABLE_NAME AS [OBJECTNAME_P] , TABLES_P.TABLE_TYPE AS [OBJECTTYPE_P] FROM <DATABASE_PRODUCTION>.INFORMATION_SCHEMA.TABLES AS TABLES_P UNION ALL SELECT ROUTINES_P.ROUTINE_SCHEMA AS [SCHEMA_P] , ROUTINES_P.ROUTINE_NAME AS [OBJECTNAME_P] , ROUTINES_P.ROUTINE_TYPE AS [OBJECTTYPE_P] FROM <DATABASE_PRODUCTION>.INFORMATION_SCHEMA.ROUTINES AS ROUTINES_P UNION ALL SELECT '' AS [SCHEMA_P] , TRIG.name AS [OBJECTNAME_P] , 'TRIGGER TABLE' AS [OBJECTTYPE_P] FROM <DATABASE_PRODUCTION>.sys.triggers AS TRIG INNER JOIN <DATABASE_PRODUCTION>.sys.tables AS TAB ON TRIG.parent_id = TAB.object_id UNION ALL SELECT '' AS [SCHEMA_P] , TRIG.name AS [OBJECTNAME_P] , 'TRIGGER VIEW' AS [OBJECTTYPE_P] FROM <DATABASE_PRODUCTION>.sys.triggers AS TRIG INNER JOIN <DATABASE_PRODUCTION>.sys.views AS TAB ON TRIG.parent_id = TAB.object_id ) ss_P FULL OUTER JOIN ( SELECT TABLES_E.TABLE_SCHEMA AS [SCHEMA_E] , TABLES_E.TABLE_NAME AS [OBJECTNAME_E] , TABLES_E.TABLE_TYPE AS [OBJECTTYPE_E] FROM <DATABASE_DEVELOPMENT>.INFORMATION_SCHEMA.TABLES AS TABLES_E UNION ALL SELECT ROUTINES_E.ROUTINE_SCHEMA AS [SCHEMA_E] , ROUTINES_E.ROUTINE_NAME AS [OBJECTNAME_E] , ROUTINES_E.ROUTINE_TYPE AS [OBJECTTYPE_E] FROM <DATABASE_DEVELOPMENT>.INFORMATION_SCHEMA.ROUTINES AS ROUTINES_E UNION ALL SELECT '' AS [SCHEMA_P] , TRIG.name AS [OBJECTNAME_P] , 'TRIGGER TABLE' AS [OBJECTTYPE_P] FROM <DATABASE_DEVELOPMENT>.sys.triggers AS TRIG INNER JOIN <DATABASE_DEVELOPMENT>.sys.tables AS TAB ON TRIG.parent_id = TAB.object_id UNION ALL SELECT '' AS [SCHEMA_P] , TRIG.name AS [OBJECTNAME_P] , 'TRIGGER VIEW' AS [OBJECTTYPE_P] FROM <DATABASE_DEVELOPMENT>.sys.triggers AS TRIG INNER JOIN <DATABASE_DEVELOPMENT>.sys.views AS TAB ON TRIG.parent_id = TAB.object_id ) ss_E ON ss_P.[SCHEMA_P]=ss_E.[SCHEMA_E] AND ss_P.OBJECTNAME_P=ss_E.OBJECTNAME_E AND ss_P.OBJECTTYPE_P=ss_E.OBJECTTYPE_E

ID: 159
PlCodelang: Python
PlGroup: Textdateien
PlItemTitle: TextDatei auslesen
Code: myFilename = "file.txt" fileObj = open(myFilename , "r" ) array = [] for line in fileObj: array.append( line ) fileObj.close()

ID: 160
PlCodelang: Python
PlGroup: Exceptions
PlItemTitle: Try Catch Except
Code: try: print 1/0 except Exception as e: print traceback.extract_stack() else: print "this is the else block" finally: print "finally clean up or something"

ID: 161
PlCodelang: Python
PlGroup: Strings
PlItemTitle: String nach einem Teilstring durchsuchen
Code: # http://www.tutorialspoint.com/python/string_find.htm # this function is case sensitive fullstring = "This is my string" searchFor = "my" startPosition = fullstring.find(searchFor, 0, len(fullstring)) # startPosition will have 8 if startPosition>=0: print "I found it!" startPosition = fullstring.upper().find(searchFor.upper()) # case insensitive

ID: 162
PlCodelang: Python
PlGroup: Strings
PlItemTitle: String auf Wunschlänge zuschneiden
Code: myString = "Benzinverbrauch" print myString[2:10] # Ausgabe: "nzinverb"