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 121-130 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

99	C#	Sonstiges	Beendet die aktuelle Applikation	Application.Current.Shutdown();
77	Delphi	Filehandling	Applikations-/Script-Verzeichnis ermitteln	AppPath:=ExtractFilePath(Application.Exename);
107	C#	Sonstiges	Arbeiten mit der Zwichenablage (Clipboard)	Clipboard.SetText("Text..."); string myString = Clipboard.GetText();
277	PL/pgSQL	Datenbank	Datenbankobjekte Kommentar	COMMENT ON FUNCTION increment(i INT) IS 'This is a comment';
98	C#	Sonstiges	Gibt den aktuellen ProgrammOrdnerPfad der Applikation aus.	Console.WriteLine(AppDomain.CurrentDomain.BaseDirectory);
57	T-SQL	Datenbank	SQL-Cursor	CREATE #myTempTable ( ID Int IDENTITY ,tempField1 Int ,tempField2 VarChar(30) ) DECLARE @field1 AS Int DECLARE @field2 AS VarChar(30) DECLARE myCursor CURSOR FOR SELECT myTableField1, myTableField2 FROM myTable OPEN myCursor FETCH NEXT FROM myCursor INTO @field1, @field2; WHILE @@FETCH_STATUS=0 BEGIN PRINT @field1 -- Prints value from column myTable.myTableField1 PRINT @field2 -- Prints value from column myTable.myTableField2 INSERT INTO #myTempTable (tempField1,tempField2) VALUES (@field1, @field2) -- do something else... FETCH NEXT FROM myCursor INTO @field1, @field2; -- next row END CLOSE myCursor DEALLOCATE myCursor DROP #myTempTable
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);
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;
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;
151	T-SQL	Datenbank	Automatisch hochzählendes Feld	CREATE TABLE myTable ( id INT IDENTIY(1,1), field1 varchar(100) )