Welcome to Programmers Language v2

ID: 253
PlCodelang: T-SQL
PlGroup: Metadaten
PlItemTitle: Fremdschlüssel auflisten
Code: SELECT [FK_NAME] = obj.name ,[Schema_Name] = sch.name ,[Table] = tab1.name ,[Column] = col1.name ,[Referenced_Schema_Name] = sch2.name ,[Referenced_Table] = tab2.name ,[Referenced_Column] = col2.name FROM sys.foreign_key_columns fkc INNER JOIN sys.objects obj ON obj.object_id = fkc.constraint_object_id INNER JOIN sys.tables tab1 ON tab1.object_id = fkc.parent_object_id INNER JOIN sys.schemas sch ON tab1.schema_id = sch.schema_id INNER JOIN sys.columns col1 ON col1.column_id = parent_column_id AND col1.object_id = tab1.object_id INNER JOIN sys.tables tab2 ON tab2.object_id = fkc.referenced_object_id INNER JOIN sys.columns col2 ON col2.column_id = referenced_column_id AND col2.object_id = tab2.object_id INNER JOIN sys.schemas sch2 ON tab2.schema_id = sch.schema_id

ID: 254
PlCodelang: PowerShell
PlGroup: Filehandling
PlItemTitle: Alle Dateien aus Verzeichnis auslesen
Code: $CSVFullPath = "C:\Temp" $FileFilter = "*.csv" $ListOfFiles = (Get-ChildItem -Path $CSVFullPath -Filter $FileFilter) | Select Name, BaseName, DirectoryName, FullName, Extension $ListOfFiles.Name

ID: 255
PlCodelang: PowerShell
PlGroup: Filehandling
PlItemTitle: Verzeichnis rekursiv durchsuchen
Code: $CSVFullPath = "C:\Temp" $FileFilter = "*.*" $ListOfFiles = (Get-ChildItem -Path $CSVFullPath -Filter $FileFilter -Recurse) | Select Name, BaseName, DirectoryName, FullName, Extension | Where {$_.DirectoryName -like "*not_processed*" } $ListOfFiles.FullName

ID: 256
PlCodelang: PowerShell
PlGroup: Textdateien
PlItemTitle: TextDatei auslesen
Code: $myFilename = "file.txt" $fileContent = (Get-Content $myFilename)

ID: 257
PlCodelang: PowerShell
PlGroup: Schleifen
PlItemTitle: For-Schleife
Code: $elements ="A;B;C" $elements.Split(";") | ForEach-Object { write-host $_ } Write-Host " - Next example -" $elements ="D;E;F" ForEach ($element in $elements.Split(";")) { Write-Host $element }

ID: 258
PlCodelang: PowerShell
PlGroup: Exceptions
PlItemTitle: Try Catch Except
Code: $DirectoryName = "C:\Temp\rename_test_new" Try { $newDirectoryName = $DirectoryName -replace "_new", "_old" Rename-Item -path $DirectoryName -newName $newDirectoryName } Catch { Write-host "Error. Exit!" Write-Error $_.Exception.Message exit # Wenn das Script hart beendet werden soll, dann kann exit verwendet werden }

ID: 259
PlCodelang: PowerShell
PlGroup: Strings
PlItemTitle: Multiline String Variable
Code: # In PowerShell such variables are called: Here-Strings $mySQLString = @" SELECT 1 FROM dbo.TestTable WHERE 1=1 "@

ID: 260
PlCodelang: SQLite
PlGroup: Datenbank
PlItemTitle: Temporäre DB-Tabelle
Code: CREATE TEMPORARY TABLE myTempTable1 ( id INT ,myText TEXT )

ID: 261
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: CTAS
Code: -- Achtung, er werden nur Felder mit Datentypen übernommen. -- Keine Constraints (PK, FK, Defaults, ...) oder IDENTITY Informationen -- Sollte die Zieltabelle (myDestinationTable) bereits vorhanden sein, kommt es zu einer Fehlermeldung SELECT * INTO myDestinationTable FROM mySourceTable

ID: 262
PlCodelang: MS Access SQL
PlGroup: Datenbank
PlItemTitle: CTAS
Code: -- Sollte die Zieltabelle (myDestinationTable) bereits vorhanden sein -- wird diese überschrieben (neue Strukturen werden übernommen) SELECT * INTO myDestinationTable FROM mySourceTable