Welcome to Programmers Language v2

ID: 133
PlCodelang: VB.NET
PlGroup: Strings
PlItemTitle: String nach einem Teilstring durchsuchen
Code: Dim longStr = "This is a long string" Dim searchFor = "long" position = InStr( longStr, searchFor )

ID: 134
PlCodelang: SSIS
PlGroup: Fallunterscheidung
PlItemTitle: Wenn-Dann Abfrage
Code: ' Using IF(IIF) logic in Derived Column (LEN(TRIM(Test)) > 0 ? SUBSTRING(Test,1,5) : NULL(DT_WSTR,5))

ID: 135
PlCodelang: T-SQL
PlGroup: Security
PlItemTitle: Zugriff auf DB-Tabellen für Schema/Package gewähren
Code: GRANT UPDATE,INSERT,SELECT,DELETE ON SCHEMA :: schema_test TO user_test

ID: 136
PlCodelang: PHP
PlGroup: Textdateien
PlItemTitle: Textdatei schreiben
Code: $datei = fopen("myfile.txt","w+"); // write rewind($datei); fwrite($datei, time()"); fclose($datei);

ID: 137
PlCodelang: T-SQL
PlGroup: Datenmengen
PlItemTitle: Differenzen anzeigen
Code: SELECT field_to_compare FROM Destination_Table EXCEPT SELECT field_to_compare FROM Source_Table

ID: 138
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: String nach einem Teilstring durchsuchen
Code: -- 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 "!"

ID: 139
PlCodelang: T-SQL
PlGroup: Datenbank-Administration
PlItemTitle: Alle Transaktion/Jounal-Log Files verkleinern
Code: -- 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

ID: 140
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: Aktuellen Datenbanknamen ausgeben
Code: SELECT DB_NAME() AS DB_Name

ID: 141
PlCodelang: SQLite
PlGroup: Datenbank
PlItemTitle: Fremdschlüsselprüfung aktivieren
Code: -- 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

ID: 142
PlCodelang: JavaScript
PlGroup: URL-Handling
PlItemTitle: Aktuelle URL bekommen
Code: // http://www.w3.org/TR/DOM-Level-2-HTML/html.html#ID-46183437 myURL = document.URL; // => http://myDNSNameOrIP:1234/path/testfile.html