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 81-90 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

50	Java	Typenkonvertierung	String in Integer konvertieren	String aString = "78"; int aInt = Integer.parseInt(aString);
74	Delphi	Typenkonvertierung	String in Integer konvertieren	MyInt:=StrToInt('125');
75	C#	Typenkonvertierung	String in Integer konvertieren	int MyInt if (Int32.TryParse("125", out MyInt)) { // Parsing was successfull }
51	T-SQL	Datenbank	Alle angelegten Tabellen anzeigen	SELECT T.TABLE_CATALOG ,T.TABLE_SCHEMA ,T.TABLE_NAME ,T.TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES T
53	T-SQL	Datum, Zeit	Erster und letzter Tag des Monats ermitteln	DECLARE @Now SMALLDATETIME ,@FirstDayOfMonth SMALLDATETIME ,@Laufperiode CHAR(21) ,@LastDayOfMonth SMALLDATETIME -- SET @Now = GetDate() SET @Now = {d '2008-02-01'} SET @FirstDayOfMonth = CAST(year(@Now) * 10000 + MONTH(@Now) * 100 + 1 as CHAR(8)) SET @Laufperiode = CONVERT(CHAR(10), @FirstDayOfMonth, 104) + '-' + CONVERT(CHAR(10), DATEADD(mm, 1, @FirstDayOfMonth) - 1, 104) SET @LastDayOfMonth=DATEADD(mm, 1, @FirstDayOfMonth)-1 SELECT [@Laufperiode] = @Laufperiode ,[@FirstDayOfMonth] = @FirstDayOfMonth ,[@LastDayOfMonth] = @LastDayOfMonth
157	PL/pgSQL	Datum, Zeit	Erster und letzter Tag des Monats ermitteln	select date_trunc('month', now()) -- first day in month select date_trunc('month', now()) + interval '1 month - 1 day' -- last day in month
168	SQLite	Datum, Zeit	Erster und letzter Tag des Monats ermitteln	select date('now','start of month'); --first day of current month select date('now','start of month', '+1 months','-1 day'); --last day of current month
54	T-SQL	Datenbank	Stored Function aufrufen	SELECT schema.functionname(para1, para2)
55	Delphi	GUI, Komponenten allgemein	Mit Return ein Ereignis im Textfeld auslösen	procedure TForm1.Edit1KeyPress(Sender: TObject; var Key: Char); begin if Key = #13 then begin Key := #0; ShowMessage('Auswerten ...'); end; end;
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