Welcome to Programmers Language v2

ID: 143
PlCodelang: JavaScript
PlGroup: URL-Handling
PlItemTitle: Domain und Port einer URL
Code: domainAndPort = document.URL.split("/")[2]; // => 192.168.1.100:1234 // => myDNSname.com:6789

ID: 144
PlCodelang: JavaScript
PlGroup: Strings
PlItemTitle: String nach Delimenter zerlegen
Code: myTestString = "abc;def;ghj/1"; splittedString = myTestString.split(";"); elementTwo = splittedString[1]; // => def

ID: 145
PlCodelang: JavaScript
PlGroup: Strings
PlItemTitle: Anzahl an Zeichen in einem String ermitteln
Code: myString = "This is a string, containing some words. Try it, if you don't believe ;-)"; // Get the count of commas in the string: cntCommas = myString.split(",").length-1; // => 2

ID: 146
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: Tabelle kopieren
Code: CREATE TABLE new_table AS SELECT * FROM old_table -- this action can't be done cross databases

ID: 147
PlCodelang: PL/pgSQL
PlGroup: Datum, Zeit
PlItemTitle: Jahr aus Datum extrahieren
Code: select extract(year from now())

ID: 148
PlCodelang: PL/pgSQL
PlGroup: Strings
PlItemTitle: Strings miteinander verbinden
Code: -- Bei PL/pgSQL sollte man die Funktion concat verwenden. -- Felder verbinden mit || kann zu NULL im Ergebnisfeld führen SELECT field_a ,field_b ,NULL as field_c ,concat(field_a, field_b, field_c) as together FROM table_1

ID: 149
PlCodelang: Perl
PlGroup: Datum, Zeit
PlItemTitle: Jahr aus Datum extrahieren
Code: use POSIX qw/EXIT_SUCCESS EXIT_FAILURE/; # Datum Vorbereitung: my $DateTime = POSIX::strftime('%c', localtime(time)); my ($Date, $Time) = split(/\s+/, $DateTime); my ($Day, $Month, $Year) = split(/\./, $Date); my ($Hour, $Minute, $Second) = split(/:/, $Time ); my $Datum = "$Year"."$Month"."$Day"; #oder # my $Datum = "$Day"."$Month"."$Year"; my $Uhrzeit = "$Hour".":"."$Minute".":"."$Second";

ID: 150
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: DB-Funktion erstellen
Code: CREATE OR REPLACE FUNCTION whichContinent(country TEXT) RETURNS character varying AS $BODY$ DECLARE returnValue character varying; BEGIN SELECT INTO returnValue CASE country WHEN 'ARGENTINA' THEN 'SOUTH AMERICA' WHEN 'BELGIUM' THEN 'EUROPE' WHEN 'BRAZIL' THEN 'SOUTH AMERICA' WHEN 'CANADA' THEN 'NORTH AMERICA' WHEN 'DENMARK' THEN 'EUROPE' WHEN 'FINLAND' THEN 'EUROPE' WHEN 'FRANCE' THEN 'EUROPE' ELSE 'UNKNOWN' END; RETURN returnValue; END; $BODY$ LANGUAGE PLPGSQL;

ID: 151
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: Automatisch hochzählendes Feld
Code: CREATE TABLE myTable ( id INT IDENTIY(1,1), field1 varchar(100) )

ID: 152
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: Automatisch hochzählendes Feld
Code: CREATE TABLE myTable ( id SERIAL, field1 varchar(100) )