---
title: "Stored Procedure och Insert"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/90176-stored-procedure-och-insert"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "aleborg"
published: "2003-11-12T13:06:01.000Z"
updated: "2003-11-12T14:20:48.000Z"
replies: 2
views: 252
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/90176-stored-procedure-och-insert"
---

# Stored Procedure och Insert

## #1 — aleborg, 2003-11-12T13:06Z

Jag har följande kod:

```
CREATE PROCEDURE sp_InsertSupportQ
	@subject (char) (255),
	@message (text),
	@date (datetime),
	@from (char) (100),
	@name (char) (100),
	@username (char) (100),
	@telephone (char) (100),
	@email (char) (100),
	@uniqueid (char) (30)
AS
INSERT INTO 	SupportQ
		(Subject, Message, [Date], [From], [Name], Username, Telephone, Email, UniqueID) 
values
		(@subject, @message, @date, @from, @name, @username, @telephone, @email, @uniqueid)
GO
```

Must declare the variable @subject när jag försöker spara SP:n
Vad är fel?

Permalänk: https://www.webforum.nu/p/90176

## #2 — andreas_lindh, 2003-11-12T13:43Z

```
@subject char(255),
@message text,
@date datetime,
@from char(100),
@name char(100),
@username char(100),
@telephone char(100),
@email char(100),
@uniqueid char(30)
```

Permalänk: https://www.webforum.nu/p/1204412

## #3 — aleborg, 2003-11-12T14:20Z

Tack :)

Permalänk: https://www.webforum.nu/p/1204435

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/90176-stored-procedure-och-insert