Double som input parameter
HejJeg har denne stored proceduere. Jeg får fejl ved brug af double som input parameter???
ALTER PROCEDURE [dbo].[add_customer](@para_customer_user_id uniqueidentifier, @para_customer_name NVARCHAR(50),
@para_customer_street NVARCHAR(100),@para_customer_street_no NCHAR(10), @para_customer_zip NCHAR(10),@para_customer_phone Double)
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO customer_table (customer_table_aspnet_users_userid_set,
customer_table_name,customer_table_street,customer_table_streetnumber,
customer_table_zipcode_table_zip_set, customer_table_phone)
VALUES(@para_customer_user_id ,@para_customer_name,@para_customer_street,@para_customer_street_no,@para_customer_zip,@para_customer_phone)
END