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 131-140 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

152	PL/pgSQL	Datenbank	Automatisch hochzählendes Feld	CREATE TABLE myTable ( id SERIAL, field1 varchar(100) )
263	SQLite	Datenbank	CTAS	CREATE TABLE newDestinationTable AS SELECT * FROM oldSourceTable
146	PL/pgSQL	Datenbank	Tabelle kopieren	CREATE TABLE new_table AS SELECT * FROM old_table -- this action can't be done cross databases
83	MySQL	Datenbank	Tabellenstruktur kopieren	CREATE TABLE zieltabelle SELECT * FROM quelltabelle WHERE ID=-1;
260	SQLite	Datenbank	Temporäre DB-Tabelle	CREATE TEMPORARY TABLE myTempTable1 ( id INT ,myText TEXT )
200	JavaScript	Datum, Zeit	Aktuelles Datum/Uhrzeit	date = new Date(); // Sat Jun 14 2014 13:15:27 GMT+0200 (CEST) dateStringISO = date.toISOString(); // "2014-06-14T11:15:27.097Z" // Attention: Time is different because of the timezone date.toISOString().substring(0,10); //"2014-06-14" dateStringISO.split("T")[1]; // 11:15:27.097Z
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
290	T-SQL	Datum, Zeit	Aktuelles Datum/Uhrzeit	DECLARE @newDT DATETIME SET @newDT = CAST('2021-01-01 01:23:45' AS DATETIME) SELECT FORMAT(GETDATE(), 'yyyy-MM-dd', 'En') SELECT FORMAT(GETDATE(), 'yyyy-MM-dd HH:mm:ss', 'En')
220	T-SQL	Strings	Position eines Teilstrings finden	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
119	T-SQL	Strings	Vorkommnisse eines Zeichen in einem String ermitteln	DECLARE @TestString VarChar(max) = 'abcdeeeff' DECLARE @SearchFor VarChar(1) = 'e' SELECT Len(@TestString)-Len(replace(@TestString,@SearchFor,'')) As Count