Manage PlItems

You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done.

Advanced Search

Displaying 151-160 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

152	PL/pgSQL	Datenbank	Automatisch hochzählendes Feld	CREATE TABLE myTable ( id SERIAL, field1 varchar(100) )
151	T-SQL	Datenbank	Automatisch hochzählendes Feld	CREATE TABLE myTable ( id INT IDENTIY(1,1), field1 varchar(100) )
150	PL/pgSQL	Datenbank	DB-Funktion erstellen	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;
149	Perl	Datum, Zeit	Jahr aus Datum extrahieren	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";
148	PL/pgSQL	Strings	Strings miteinander verbinden	-- 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
147	PL/pgSQL	Datum, Zeit	Jahr aus Datum extrahieren	select extract(year from now())
146	PL/pgSQL	Datenbank	Tabelle kopieren	CREATE TABLE new_table AS SELECT * FROM old_table -- this action can't be done cross databases
145	JavaScript	Strings	Anzahl an Zeichen in einem String ermitteln	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
144	JavaScript	Strings	String nach Delimenter zerlegen	myTestString = "abc;def;ghj/1"; splittedString = myTestString.split(";"); elementTwo = splittedString[1]; // => def
143	JavaScript	URL-Handling	Domain und Port einer URL	domainAndPort = document.URL.split("/")[2]; // => 192.168.1.100:1234 // => myDNSname.com:6789