Welcome to Programmers Language v2

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;