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

133	VB.NET	Strings	String nach einem Teilstring durchsuchen	Dim longStr = "This is a long string" Dim searchFor = "long" position = InStr( longStr, searchFor )
134	SSIS	Fallunterscheidung	Wenn-Dann Abfrage	' Using IF(IIF) logic in Derived Column (LEN(TRIM(Test)) > 0 ? SUBSTRING(Test,1,5) : NULL(DT_WSTR,5))
135	T-SQL	Security	Zugriff auf DB-Tabellen für Schema/Package gewähren	GRANT UPDATE,INSERT,SELECT,DELETE ON SCHEMA :: schema_test TO user_test
136	PHP	Textdateien	Textdatei schreiben	$datei = fopen("myfile.txt","w+"); // write rewind($datei); fwrite($datei, time()"); fclose($datei);
137	T-SQL	Datenmengen	Differenzen anzeigen	SELECT field_to_compare FROM Destination_Table EXCEPT SELECT field_to_compare FROM Source_Table
138	T-SQL	Datenbank	String nach einem Teilstring durchsuchen	-- Find characters which are also special characters for search terms, e.g. % or _ -- see also: http://msdn.microsoft.com/en-us/library/ms179859%28v=sql.105%29.aspx SELECT * FROM table_1 WHERE column_1 LIKE '%!_%' ESCAPE '!' -- Find results which includes the character "_". The escape character is defined as "!"
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
140	T-SQL	Datenbank	Aktuellen Datenbanknamen ausgeben	SELECT DB_NAME() AS DB_Name
141	SQLite	Datenbank	Fremdschlüsselprüfung aktivieren	-- http://www.sqlite.org/foreignkeys.html PRAGMA foreign_keys = ON; -- !! this is only valid for the current session. -- If you want to use this permanent, you have to use this statement every time you start a new session
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