PlItems

ID: 203
PlCodelang: Java
PlGroup: Filehandling
PlItemTitle: Ternary operator
Code: String thisVar = "OK"; boolean resultVar; resultVar = thisVar.equals("OK") ? true : false; // same as if-else construction if (thisVar.equals("OK")) { resultVar = true; } else { resultVar = false; }

ID: 204
PlCodelang: Python
PlGroup: Fallunterscheidung
PlItemTitle: Ternary operator
Code: thisVar = "OK" resultVar = False # [on_true] if [cond] else [on_false] resultVar = True if thisVar == "OK" else False // same as if-else construction if (thisVar == "OK"): resultVar = True else: resultVar = False

ID: 205
PlCodelang: MySQL
PlGroup: Datum, Zeit
PlItemTitle: Tagesname
Code: SELECT DAYNAME(NOW()); -- Monday SELECT DAYNAME('2014-08-10'); -- Sunday -- To get localized names switch the parameter, e.g. to German SET lc_time_names = 'de_DE'; SELECT DAYNAME('2014-08-10'); -- Sonntag

ID: 206
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: Tabelle DB übergreifend kopieren
Code: DROP TABLE IF EXISTS `DestinationDB`.`Table1`; CREATE TABLE `DestinationDB`.`Table1` SELECT * FROM `SourceDB`.`Table1`;

ID: 207
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: Manuell einen AutoIncrement/Identity/Serial Wert in Tabelle einfügen
Code: SET IDENTITY_INSERT myTable ON INSERT INTO myTable(Identity_ID, Value) VALUES (4711, 'Back To The Future...') SET IDENTITY_INSERT myTable OFF

ID: 208
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: Tabelleinhalt DB übergreifend kopieren
Code: -- siehe auch: http://stackoverflow.com/questions/6083132/postgresql-insert-into-select -- in DestinationDB do: INSERT INTO Table1 SELECT id, valuefield FROM dblink('dbname=SourceDB', 'SELECT id, valuefield FROM Table1') AS t(id integer, valuefield varchar(100));

ID: 209
PlCodelang: SQLite
PlGroup: Datum, Zeit
PlItemTitle: Kalenderwoche eines Datums
Code: -- Standard Weeknumber function from SQLite: -- http://www.sqlite.org/lang_datefunc.html SELECT strftime('%W', '2014-08-25') -- The above calculation can lead to an wrong number if you expect an iso calendar week. -- Therefore better: -- http://stackoverflow.com/questions/15082584/sqlite-return-wrong-week-number-for-2013 SELECT (strftime('%j', date('2014-08-25', '-3 days', 'weekday 4')) - 1) / 7 + 1 AS ISOCalendarWeekNumber;

ID: 210
PlCodelang: T-SQL
PlGroup: Datum, Zeit
PlItemTitle: Kalenderwoche eines Datums
Code: select DATEPART(ISO_WEEK,CAST('2014-08-25' AS DATE))

ID: 211
PlCodelang: SQLite
PlGroup: Datum, Zeit
PlItemTitle: Jahr aus Datum extrahieren
Code: SELECT strftime('%Y', '2014-08-25') AS Year;

ID: 212
PlCodelang: SQLite
PlGroup: Datum, Zeit
PlItemTitle: Tagesname
Code: -- There is no build in solution. Because of this you have to build a solution out of the weekday. -- Be careful, the first weekday (0) is a sunday SELECT ,CASE CAST(strftime('%w', myDateField) as integer) WHEN 0 then 'Sonntag' WHEN 1 then 'Montag' WHEN 2 then 'Dienstag' WHEN 3 then 'Mittwoch' WHEN 4 then 'Donnerstag' WHEN 5 then 'Freitag' WHEN 6 then 'Samstag' ELSE '????????????????????' END AS Tag_der_Woche_Deutsch ,CASE CAST(strftime('%w', myDateField) as integer) WHEN 0 then 'Sunday' WHEN 1 then 'Monday' WHEN 2 then 'Tuesday' WHEN 3 then 'Wednesday' WHEN 4 then 'Thursday' WHEN 5 then 'Friday' WHEN 6 then 'Saturday' ELSE '????????????????????' END AS Day_of_week_English

ID: 213
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: DB-Funktion erstellen
Code: -- Table-value -- Variant 1 CREATE FUNCTION whichContinent (@country nvarchar(15)) RETURNS TABLE AS RETURN ( SELECT @country AS Country ) -- Variant 2 CREATE FUNCTION whichContinent (@country nvarchar(15)) RETURNS @returnTableResult TABLE ( id int ,currency VARCHAR(100) ) AS BEGIN IF @country='Germany' BEGIN INSERT INTO @returnTableResult VALUES (1,'EURO') END RETURN END

ID: 214
PlCodelang: T-SQL
PlGroup: Exceptions
PlItemTitle: Try Catch Except
Code: -- See also: http://msdn.microsoft.com/de-de/library/ms175976(v=sql.105).aspx -- !! -- TRY-CATCH cannot be used for all operations/situations in T-SQL. -- Be careful and refer to the link above for details -- !! BEGIN TRY SELECT 1/0; END TRY BEGIN CATCH SELECT ERROR_NUMBER() AS ErrorNumber ,ERROR_SEVERITY() AS ErrorSeverity ,ERROR_STATE() AS ErrorState ,ERROR_PROCEDURE() AS ErrorProcedure ,ERROR_LINE() AS ErrorLine ,ERROR_MESSAGE() AS ErrorMessage; END CATCH;

ID: 215
PlCodelang: Python
PlGroup: Strings
PlItemTitle: Replace
Code: # http://www.tutorialspoint.com/python/string_replace.htm str1 = "abc#def" str1 = str1.replace("#",';") print str1 # Output: abc;def

ID: 216
PlCodelang: ORACLE PL/SQL
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: -- if todays date is: 2014-02-02 then a static query would be SELECT TO_DATE('02/02/2014','dd/mm/yyyy') FROM dual -- system variable SELECT SYSDATE AS TODAY FROM SYS."DUAL"

ID: 217
PlCodelang: T-SQL
PlGroup: Datenmengen
PlItemTitle: Anzahl Zeilen Resultset begrenzen
Code: SELECT TOP 100 * FROM tableA

ID: 218
PlCodelang: MySQL
PlGroup: Datenmengen
PlItemTitle: Anzahl Zeilen Resultset begrenzen
Code: SELECT * FROM tableA LIMIT 100;

ID: 219
PlCodelang: ORACLE PL/SQL
PlGroup: Datenmengen
PlItemTitle: Anzahl Zeilen Resultset begrenzen
Code: SELECT * FROM ( SELECT * FROM tableA ) WHERE ROWNUM <= 100

ID: 220
PlCodelang: T-SQL
PlGroup: Strings
PlItemTitle: Position eines Teilstrings finden
Code: DECLARE @searchFor_Charindex Varchar(10) DECLARE @searchFor_Patindex Varchar(10) DECLARE @text Varchar(100) SET @searchFor_Charindex = 'simple' SET @searchFor_Patindex = '%simple%' -- Remember the %. Patindex can also be used for RegEx! SET @text = 'this is a simple text' SELECT CHARINDEX(@searchFor_Charindex, @text) AS Position_Charindex SELECT PATINDEX(@searchFor_Patindex, @text) AS Position_Patindex -- 11

ID: 221
PlCodelang: Delphi
PlGroup: Strings
PlItemTitle: Position eines Teilstrings finden
Code: searchFor:='simple'; text:='this is a simple text'; ShowMessage(IntToStr(pos(searchFor,text))); // 11

ID: 222
PlCodelang: MySQL
PlGroup: Datenbank
PlItemTitle: NULL Wert eines Feldes übersteuern
Code: SELECT IFNULL(MyColumn1, 1) AS MyColumnWithoutNULL;