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.
#!/bin/sh
myFilename="$1"
# or
myFilename="/tmp/Test/myFile.txt"
# Get only the path
path_only=$(dirname "$myFilename")
# /tmp/Test
# if it is a local file in the path, then . will be prompted e.g. myFilename="myFile.txt"
# Filename only
filename_only=$(basename "$myFilename")
# myFile.txt
# get only filename without extention
filename_without_ext="${filename_only%.*}"
# myFile
# get only the extension
filename_extention_only="${myFilename##*.}"
# txt
# put them together again
myFilename_together="${path_only}/${filename_without_ext}.${filename_extention_only}"
# /tmp/Test/myFile.txt
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
265
T-SQL
Datenbank
Eine Menge B reduziert um Menge A
-- Es soll die Menge an Datensätze ausgegeben reduziert um eine andere Menge (Rest)
-- Die einzelnen Tabellen oder Subqueries müssen die gleichen Spalten im Statement haben
SELECT
FieldA
,FieldB
,FieldC
FROM myTable1
EXCEPT
SELECT
FieldA
,FieldB
,FieldC
FROM myTable2
268
T-SQL
Encoding / Decoding
Checksumme
SELECT
[CHECKSUM_1] = CHECKSUM(Column1, Column2)
FROM
TableA
270
T-SQL
Datenbank
UPDATE SQL mit JOIN
UPDATE UPD_TABLE
SET UPD_TABLE.myField1 = 'Update this field'
FROM TableToBeUpdated UPD_TABLE
LEFT JOIN
(
SELECT * FROM JoinedTable
WHERE cond1 = 1
)
J
WHERE J.ID = UPD_TABLE.ID
;
273
T-SQL
Strings
Leerzeichen vor/hinter String entfernen
SELECT LTRIM(RTRIM(' x text x '))
276
T-SQL
Datenbank
Stored Procedure anlegen/löschen
CREATE PROCEDURE increment(@i INT) AS
BEGIN
INSERT INTO accounts (id,name, balance) VALUES (i, 'Test', 1200);
END;
DECLARE @newDT DATETIME
SET @newDT = CAST('2021-01-01 01:23:45' AS DATETIME)
SELECT FORMAT(GETDATE(), 'yyyy-MM-dd', 'En')
SELECT FORMAT(GETDATE(), 'yyyy-MM-dd HH:mm:ss', 'En')
46
T-SQL
Datenbank
DB-Funktion erstellen
-- Scalar-value
CREATE FUNCTION whichContinent
(@country nvarchar(15))
RETURNS varchar(30)
AS
BEGIN
DECLARE @returnValue varchar(30)
SELECT @returnValue = CASE @country
WHEN 'ARGENTINA' THEN 'SOUTH AMERICA'
WHEN 'BELGIUM' THEN 'EUROPE'
WHEN 'BRAZIL' THEN 'SOUTH AMERICA'
WHEN 'CANADA' THEN 'NORTH AMERICA'
WHEN 'DENMARK' THEN 'EUROPE'
WHEN 'FINLAND' THEN 'EUROPE'
WHEN 'FRANCE' THEN 'EUROPE'
ELSE 'UNKNOWN'
END
RETURN @returnValue
END
