18 lines
516 B
MySQL
18 lines
516 B
MySQL
|
CREATE PROCEDURE [dbo].[spWunschInfo_Insert]
|
|||
|
|
@Id INT,
|
|||
|
|
@Wunsch NVARCHAR(1024),
|
|||
|
|
@BildPrompt NVARCHAR(MAX),
|
|||
|
|
@BildBeschreibung NVARCHAR(MAX),
|
|||
|
|
@Datum DATETIME2,
|
|||
|
|
@GPTModel NCHAR(32)
|
|||
|
|
AS
|
|||
|
|
BEGIN
|
|||
|
|
INSERT INTO [dbo].[WunschInfo] (Wunsch, BildPrompt, BildBeschreibung, Datum, GPTModel)
|
|||
|
|
VALUES (@Wunsch,
|
|||
|
|
@BildPrompt,
|
|||
|
|
@BildBeschreibung,
|
|||
|
|
@Datum,
|
|||
|
|
@GPTModel);
|
|||
|
|
|
|||
|
|
SELECT Id FROM [dbo].[WunschInfo] WHERE Id = CAST(SCOPE_IDENTITY() AS INT);
|
|||
|
|
END
|