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 61-70 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

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' ;
272	MS Access SQL	Datenbank	NULL Wert eines Feldes übersteuern	SELECT FieldA ,Nz([FieldB,"This field is null") As FieldB_Nz FROM TableA
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';
283	Yii2	Datenbank	Verzeichnis erstellen	<?php // Example as SQL: // SELECT * FROM MainTable // WHERE fieldA=5 AND fieldB IN (SELECT id FROM SubTable WHERE fieldC=551) $fieldC = 551; $SubTable_idQry = SubTable::find()->select('id')->where(['fieldC' => $fieldC]); // Static way: $fieldA = 5; // As result: $fieldA = ThirdTable::find() ->select('fieldA_Reference') ->where(['fieldC' => $fieldC]) ->one(); $MainTableResultQry = MainTable::find() ->where(['in', 'fieldB', $SubTable_idQry]) ->andWhere(['fieldA' => $fieldA]) ->all(); ?>
284	Yii2	Datenbank	Abfrage mit Aggregration	<?php /* // Example as SQL SELECT FieldA ,COUNT(FieldA) as cnt FROM MainTable WHERE FieldA = 5 GROUP BY FieldA */ $MainTableResultQry = MainTable::find() ->select(['FieldA', 'COUNT(FieldA) as cnt']) ->where(['FieldA' => 5]) ->groupBy(['FieldA']) ->createCommand() ->queryAll(); ?>
295	BigQuery	Datenbank	Eine Menge B reduziert um Menge A	-- Siehe BigQuery -> Differenzen anzeigen -- https://proglang.meta-grid.com/index.php?r=plItems/view&id=294
299	PL/pgSQL	Datenbank	Alle Datenbanken	SELECT "oid", datname, -- database name datdba, "encoding", datcollate, datctype, datistemplate, datallowconn, datconnlimit, datlastsysoid, datfrozenxid, datminmxid, dattablespace, datacl FROM pg_catalog.pg_database WHERE datistemplate = FALSE -- do not list template0, template1, ... ;