Home » PlItems » DB-Funktion erstellen (T-SQL)

DB-Funktion erstellen

ID213
Link ReferenceNot set
Link CreditsNot set
Link Technical DocumentationNot set
PlCodelangT-SQL
PlGroupDatenbank
PlItemTitleDB-Funktion erstellen
Code-- Table-value

-- Variant 1
CREATE FUNCTION whichContinent
(@country nvarchar(15))
RETURNS TABLE
AS
RETURN
(
SELECT @country AS Country
)

-- Variant 2
CREATE FUNCTION whichContinent
(@country nvarchar(15))
RETURNS
@returnTableResult TABLE
(
id int
,currency VARCHAR(100)
)
AS
BEGIN
IF @country='Germany'
BEGIN
INSERT INTO @returnTableResult VALUES (1,'EURO')
END
RETURN
END
Result Example