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 251-260 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

253	T-SQL	Metadaten	Fremdschlüssel auflisten	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
254	PowerShell	Filehandling	Alle Dateien aus Verzeichnis auslesen	$CSVFullPath = "C:\Temp" $FileFilter = "*.csv" $ListOfFiles = (Get-ChildItem -Path $CSVFullPath -Filter $FileFilter) \| Select Name, BaseName, DirectoryName, FullName, Extension $ListOfFiles.Name
255	PowerShell	Filehandling	Verzeichnis rekursiv durchsuchen	$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
256	PowerShell	Textdateien	TextDatei auslesen	$myFilename = "file.txt" $fileContent = (Get-Content $myFilename)
257	PowerShell	Schleifen	For-Schleife	$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 }
258	PowerShell	Exceptions	Try Catch Except	$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 }
259	PowerShell	Strings	Multiline String Variable	# In PowerShell such variables are called: Here-Strings $mySQLString = @" SELECT 1 FROM dbo.TestTable WHERE 1=1 "@
260	SQLite	Datenbank	Temporäre DB-Tabelle	CREATE TEMPORARY TABLE myTempTable1 ( id INT ,myText TEXT )
261	T-SQL	Datenbank	CTAS	-- 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
262	MS Access SQL	Datenbank	CTAS	-- Sollte die Zieltabelle (myDestinationTable) bereits vorhanden sein -- wird diese überschrieben (neue Strukturen werden übernommen) SELECT * INTO myDestinationTable FROM mySourceTable