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 11-20 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

142	JavaScript	URL-Handling	Aktuelle URL bekommen	// http://www.w3.org/TR/DOM-Level-2-HTML/html.html#ID-46183437 myURL = document.URL; // => http://myDNSNameOrIP:1234/path/testfile.html
143	JavaScript	URL-Handling	Domain und Port einer URL	domainAndPort = document.URL.split("/")[2]; // => 192.168.1.100:1234 // => myDNSname.com:6789
187	PHP	URL-Handling	Aktuelle URL bekommen	// https://myDomain/appPath/index.php $protocol = (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off' \|\| $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://"; $domainName = $_SERVER['HTTP_HOST']; $query = $_SERVER['PHP_SELF']; $path = pathinfo( $query ); $myURLBasePath=$protocol.$domainName.$path['dirname']; echo $myURLBasePath; // https://myDomain/appPath echo $myURLBasePath.'/'.$path['basename']; // https://myDomain/appPath/index.php
139	T-SQL	Datenbank-Administration	Alle Transaktion/Jounal-Log Files verkleinern	-- The script is designed to work on a sql server -- 2008R2. However it works on 2005 and sql server -- 2012 instances. -- It shrinks all log files for the databases -- created by users -- Written by Igor Micev, 2012 -- from SQLServerCentral.com declare @logname nvarchar(128) declare @dbname nvarchar(128) declare @dynamic_command nvarchar(1024) set @dynamic_command = null declare log_cursor cursor for select db_name(mf.database_id),name from sys.master_files mf where mf.database_id not in (1,2,3,4) --avoid system databases and mf.name not like 'ReportServer$%' and right(mf.physical_name,4) = '.ldf' and mf.state_desc='online' open log_cursor fetch next from log_cursor into @dbname,@logname while @@fetch_status = 0 begin set @dynamic_command = 'USE '+@dbname+' DBCC SHRINKFILE(N'''+@logname+''',0,TRUNCATEONLY)' exec sp_executesql @dynamic_command fetch next from log_cursor into @dbname,@logname set @dynamic_command = null end close log_cursor deallocate log_cursor
294	BigQuery	Datenmengen	Differenzen anzeigen	WITH a AS ( SELECT * FROM UNNEST([1,2,3,4]) AS n ), b AS ( SELECT * FROM UNNEST([4,5,6,7]) AS n ) SELECT * FROM a EXCEPT DISTINCT -- <------------------ SELECT * FROM b
296	EXASOL	Datenmengen	Differenzen anzeigen	WITH a AS ( SELECT 1 AS n UNION ALL SELECT 2 AS n UNION ALL SELECT 3 AS n UNION ALL SELECT 4 AS n ), b AS ( SELECT 4 AS n UNION ALL SELECT 5 AS n UNION ALL SELECT 6 AS n UNION ALL SELECT 7 AS n ) SELECT * FROM a EXCEPT -- <------------------------------ SELECT * FROM b
137	T-SQL	Datenmengen	Differenzen anzeigen	SELECT field_to_compare FROM Destination_Table EXCEPT SELECT field_to_compare FROM Source_Table
217	T-SQL	Datenmengen	Anzahl Zeilen Resultset begrenzen	SELECT TOP 100 * FROM tableA
218	MySQL	Datenmengen	Anzahl Zeilen Resultset begrenzen	SELECT * FROM tableA LIMIT 100;
219	ORACLE PL/SQL	Datenmengen	Anzahl Zeilen Resultset begrenzen	SELECT * FROM ( SELECT * FROM tableA ) WHERE ROWNUM <= 100