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 281-290 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

269	PL/pgSQL	Datenbank	UPDATE SQL mit JOIN	UPDATE TableToBeUpdated SET myField1 = 'Update this field' FROM ( SELECT * FROM JoinedTable WHERE cond1 = 1 ) J WHERE J.ID = TableToBeUpdated.ID ;
270	T-SQL	Datenbank	UPDATE SQL mit JOIN	UPDATE UPD_TABLE SET UPD_TABLE.myField1 = 'Update this field' FROM TableToBeUpdated UPD_TABLE LEFT JOIN ( SELECT * FROM JoinedTable WHERE cond1 = 1 ) J WHERE J.ID = UPD_TABLE.ID ;
271	MySQL	Datenbank	UPDATE SQL mit JOIN	UPDATE TableToBeUpdated UPD_TABLE INNER JOIN JoinedTable J ON J.id = UPD_TABLE.id SET UPD_TABLE.myField1 = 'Update this field' ;
300	BigQuery	Datenbank	UPDATE SQL mit JOIN	UPDATE `project.dataset.table1` t1 SET t1.target_column = t2.source_column FROM `project.dataset.table2` t2 WHERE t1.join_key = t2.join_key;
273	T-SQL	Strings	Leerzeichen vor/hinter String entfernen	SELECT LTRIM(RTRIM(' x text x '))
274	Python	Strings	Leerzeichen vor/hinter String entfernen	myText = " x text x \r\n" print myText.strip()
275	PL/pgSQL	Datenbank	Stored Procedure anlegen/löschen	CREATE OR REPLACE FUNCTION increment(i INT) RETURNS void AS $$ BEGIN INSERT INTO accounts (id,name, balance) VALUES (i, 'Test', 1200); END; $$ LANGUAGE plpgsql; DROP FUNCTION increment(i INT);
276	T-SQL	Datenbank	Stored Procedure anlegen/löschen	CREATE PROCEDURE increment(@i INT) AS BEGIN INSERT INTO accounts (id,name, balance) VALUES (i, 'Test', 1200); END;
277	PL/pgSQL	Datenbank	Datenbankobjekte Kommentar	COMMENT ON FUNCTION increment(i INT) IS 'This is a comment';
278	PowerShell	Filehandling	Prüfen ob Verzeichnis existiert	$myFolder = "C:\TEMP" if ((Test-Path $myFolder) -eq $true) { write-host "Folder exists!" } else { write-host "Folder doesn't exist!" }